Search results for query: *

Hi guys, I'm creating a new table, and want to create a field whereby when you enter a new record, a random 'Customer ID' is generated with four digits, which is never duplicated. How do I go about doing this? Cheers, Antoni

As title really, I have a form called Contact Lookup, and I'd like it to oen on startup in fullscreen view, I'd also like to set the title to a different caption, and disallow user access to any other form functions. Cheers guys, Antoni

Hi guys, I'm setting up a database whereby a user can query a database for company information and employee details (in two seperate subforms) and then add notes to the company details if the user wishes. The company is selected via four combo boxes, Company Type, Area, Postcode and Name. After...

Hi guys, I'm trying to set up a drop-down combo box which contains all the records from table 'Company' that have either no data for PostalCode or CompanyType. Below is what I've tried to use, evidently it doesn't work; it displays nothing in the drop down, and only one row. SELECT...

Hey fellas, Following on from the database form work I was doing before, I now need to add the functionality of adding notes to records to say that the company has been contacted/needs to be contacted again. Basically I have two subforms whose sources are queries that display company details...

Hey guys, In relation to my post before, I have a problem regarding populating a subform with a query, whose information is based on the selection in a listbox. I have four listboxes, who're linked as to ultimately select one company, and I want to display said company's employees in the...

Hi guys, After reading the faq regarding this, I'm having some issues with linking the first two drop boxes on the form I'm creating. The form takes info from two tables: Company:- companyType, companyArea, PostalCode, Company Name Contact:- Salutation, Forename I have two drop down list...