Recent content by Fisher31

Hi all, I am having problems setting up auto lookups I want my PurchaseOrder form to automatically fill in the name and address fields when a customers ID is entered. I understand that this will only work as part of a one to many relationship. Where I am having problems is making it work...

Hi again, I need some advice, I setting a form called day_work_log where I can keep a log on how long guys have been on a particular project for. I want to input individually each member of staff, what they did and where they were. is there a way I can have say a list of who has been where...

I hope I have uploaded the database im talking about

I am trying to do something simular (with the prefix letter) and I found a simple way of doing this by entering say "T"000 into the caption box in the field properties in the table design veiw. I hope this makes sense

if I was to write a union query and wanted the "company name" field to appear from two different tables i.e. "customer details table" and "supplier details table" in one list box on a form (say called “company contact details form”)what would I write in the SQL screen? Also am I using this right...

I tried uploading it but it exceeds the download limit as it 1.2mb, :mad:

Im really sorry, where do I put this and what would I need to change? I really appriciate your help

I am trying to change the query behind the combobox but dont seem to be able to do it,

Sorry from two different tables within the same database

Hi dcd, Thank you for repling, I would use one combo box but the lists I need are from two different databases, can I have a two fields from two different databases in the same combo box?

Hi I am relatively new to using Access and I'm having a problem, I am setting a form up and need an option button that when selected a combo box is activated and can be used (I hope this makes sense) The reason I need this is because on the form I'm setting up I have two lookup boxes but I...