Recent content by TheSouthCole

PHV, I was given the following code for NotInList, but if you need to add a Tom Smith and there is already another Smith, the code doesn't start the process of opening the "Add" form. Code is: Private Sub CustID_NotInList(NewData As String, Response As Integer) Dim Result Dim msg As...

...and would I be able to get that code here?

I can't write VBA code, so maybe I can't do this.... On a data entry form is a combo box for users to choose a customer. The CustID# is stored in that field. But if the customer's not in the list, I want the combo box to open an AddCustomer form, and then take the new customer's CustID# from...

that worked wonderfully! (much simpler than my attempts) Thanks so very much!

Ok, now how do I modify this SQL to allow the user to choose ALL Segments? I can't make the FAQ's on this topic work because my choices are not coming from a table, so I can't use a UNION. Here's my working code: SELECT [NEW YTD Bookings for %MarketShareReport].[Cust#], [NEW YTD Bookings for...

Thanks to dhookom for taking the time to discover that my form was corrupt. Creating a new one caused the report to work beautifully. Thanks also to PHV for the WHERE syntax 15 Nov 05 16:59, which worked flawlessly once dhookom discovered my form problem and I was able to continue.

...send the mdb file to your email address?

I tried that first and got the same message. I changed it to be specific thinking it would help, but it didn't.

Dhookom: before I email you the mdb file, perhaps this one snag will solve the whole thing: I open the report, which is based on my parameter queries. (The parameters point to the form.) The report's Open event has a DoCmd to open the form frmSegment, which the user will use to feed parameter...

yes, it is. Can't figure for the life of me why the queries don't recognize it. Any suggestions?

PVH: Unfortunately, I can't even get that far, because I have another more simple parameter to filter year, and even that doesn't recognize that the dialog box is open. I'm quite sure that your WHERE coding will suit me beautifully, however I've got something more basic that's wrong (open...

the table that would feed the combo box does not include "rail." Rail is a grouping of two of the field choices: boxcar and intermodal. There are no other groupings. Therefore, a SELECT DISTINCT query like above would NOT return "rail." You'll be glad to know that I teach new Access users NOT...

combo box: Form Name: frmSegment Combo box Name: txtYear, cboSegment Row Source: none for txtYear. cboSegment is "Leased"; "OTR";"Grocery";"Dairy";"Distribution";"Stock"; "Owner/Operator";"Rail" Bound Column: txtYear: none. cboSegment: 1 Column Count: cboSegment: 1 Regarding your query...

ok, I don't know what I'm doing wrong, but I cannot get the query's parameters to recognize the values in the open dialog box. Yes, I've looked at Help and yes, I've looked at Northwinds. Yes, all my form & field names match. I'm about ready to get a job pumping gas. Help!

ok, I'll check out all this info tonight and get back to you, dhookom and PVH, with my level of success! Thanks to you both.....