Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: WantoN
  • Content: Threads
  • Order by date
  1. WantoN

    AutoNumber, 4 digits

    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
  2. WantoN

    Force a Form to open in Full Screen

    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
  3. WantoN

    Adding a Note from a txtbox to a record

    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...
  4. WantoN

    Selection Box - Display records where a field is blank

    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...
  5. WantoN

    Add a note to a record via txtbox + cmd button

    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...
  6. WantoN

    Displaying Queries in Sub Forms by Field

    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...
  7. WantoN

    Issue Regarding linked combo boxes

    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...

Part and Inventory Search

Back
Top