Recent content by WantoN

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