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 Chriss Miller 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: *

  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

    Perfect!!! Thanks muchly mate. Antoni
  5. WantoN

    Selection Box - Display records where a field is blank

    Thanks mate, but I'm still having trouble, using both Is Null and "" (which is what I had originally). With : SELECT Company.CompanyID, Company.CompanyName FROM Company WHERE Company.PostalCode = 'Is Null' OR Company.CompanyType = 'Is Null' ORDER BY Company.CompanyName; I get the same...
  6. 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...
  7. WantoN

    Add a note to a record via txtbox + cmd button

    basically I'd like a way, either an afterupdate event or anything else, to allow me to add the details of a textbox to the Notes row of any selected record. Antoni
  8. WantoN

    Add a note to a record via txtbox + cmd button

    Sorry I wasn't very clear. As opposed to displaying the notes in the text box, I want to be able to use it to edit the notes for the selected company. Antoni
  9. WantoN

    Still Have SubForm Blues!

    I may have misunderstood you here, but have coded the comboboxes to requery the next combo box after each selection? And to requery the subform data too. Antoni
  10. 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...
  11. WantoN

    Displaying Queries in Sub Forms by Field

    I've sorted the problem :) I stupidly didn't think of simply adding a requery statement to the cmdbox. To clarify, I added the following the form code: Private Sub cmdCriteriaLookup_Click() subCriteriaLookup.Requery End Sub Where "cmdCriteriaLookup" is the command button and...
  12. WantoN

    Displaying Queries in Sub Forms by Field

    That has been done, but as the user may want to alter to the information in the listbox multiple times, surely I will need a cmdbox and a way of requerying the data inside the subform, so that it can be done more than once? Perhaps I'm being stupid? Antoni
  13. 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...
  14. WantoN

    Issue Regarding linked combo boxes

    I've managed to resolve the problem! It was actually a case of the first column widths being set to 0cm, and as such they were invisible. I've made some small adjustments to the code to get everything work, and now I've achieved everything I wanted. Much thanks go to the guys who've helped me...
  15. WantoN

    Issue Regarding linked combo boxes

    Hmmm, I seem to have rectified the error message regarding the expression, by removing the ")" after SalesArea. However I'm still really at a loss as to why the information isnt appearing as expected in the boxes. There's evidently something minor that I've over looked, all additional help is...
  16. WantoN

    Issue Regarding linked combo boxes

    Sorry PH mate, but I've entered it exactly as stated, and no joy. All three boxes display no information, the first displays a drop down with an arrow, but all info is blank, the second two have nothing. When I click the third drop down (postcode) I'm given the error message "Extra ) in Query...
  17. WantoN

    Issue Regarding linked combo boxes

    You have to appreciate I really know very little about access :) Basically last night I had the linked combo boxes working (well two of them) but when the third correctly displayed the postcodes, I clicked on it and nothing was selected in the box :/ When I removed CompanyID from the...
  18. WantoN

    Issue Regarding linked combo boxes

    Ok kev mate. To clarify, I went to the properties of the list box cboCompanyType and placed it in Events>AfterUpdate. Was this the wrong thing to do? Also, the SELECT DISTINCT doesn't seem to have any affect on the combo box :S Thanks again, Antoni
  19. WantoN

    Issue Regarding linked combo boxes

    When that's done, both CompanyType and CompanyArea are blank... Should I retain the form code? I'm a little confused myself. I also get an error code about not being able to find the macro named 'Me!cboCompanyArea' By the way, ultimately there will be four boxes, but I assume that once I've...
  20. WantoN

    Issue Regarding linked combo boxes

    Update, I've resolved the error message, but the box cboCompanyArea isn't displaying any data, it's empty. Rowsource for the boxes is as follows: cboCompanyType: - SELECT Company.CompanyID, Company.CompanyType FROM Company ORDER BY Company.CompanyType; cboCompanyArea: - SELECT...

Part and Inventory Search

Back
Top