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

Perfect!!! Thanks muchly mate. Antoni

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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