Recent content by carelfly

thanks vbaInet - being new to databases i didn't understand how access obtains its data from different tables and thought i had to have a direct relationship between all tables i wanted to get data from rather than working through the single relationships between the tables. Thanks

Access version 2007 - and 2003 after conversion from 2007 it is a stripped down version: tables: customers, equipment, sale forms for entry: customers, equipment, sale query to calculate cost in the sale form: sale inv at the moment the query is in the record source and it is causing the...

I have come back to the same problem again - when i am creating a form that has more than two sources (tables or queries), as soon as i add the third source and try view the form it gives me a blank page - in form view i have a completely blank screen - no controls, no subforms, no textboxes -...

i need to setup a form to entering new clients into our database - the problem is we need each client to be "referred" to us by another client (this is important info) but if i try use a lookup to find the client i can't do it coz they're on the same table - any ideas. I also need to make a...

I would like to use my database to generate invoices... i have a customer table with customer info, a invoice table to collect data for each invoice. i want to insert a subform to collect the invoice detail (individual invoice lines). i am having trouble getting the queries in the right place to...

sorry but i deleted the form and started from scratch so i can't even send in the db for a "checkup" at the docs, :)

I think i have steered down the wrong alley - i have redone my form but in case it happens again - when i designed the form with all the text boxes, checkboxes, fill-in-the-blanks, i kept clicking form view to check the form looked the way it was supposed to... suddenly when i clicked on form...

it shows the data in datasheet view if posted into a query

data entry = yes Allow additions = yes, allow deletions = yes, allow edits = yes, allow filters = yes

hi - the records are empty - there is no data in them - i have checked all the fields in the form are linked to a data source but the problem is that the design of the form has vanished when i view the form - not only the data in the fields

Hi There, making up my first database: i have a problem where i have designed a form and everything in it can be seen in design view but when i view it in form view i get a blank background - no boxes pics, subform... can anyone lead me in the right direction - it is a form containing a...

I have a table in a database that allows input of customers and a referring customer. it also has a checkbox to allow the customer to be used in the report. each referring customer is taken from a lookup list of current customer stored in a separate table(created by a query). i need to make a...

Hi there, i'm starting to learn access by being thrown in the deep end... typical, just looking for help in various sections - thanks in advance