Search results for query: *

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

Thanks, dhookom! A few more questions, if you don't mind... Rather than create another table, I had thought about adding a "Rail" field to the existing table, but I was unable to figure out how to get the TABLE's field to populate the data automatically if the Segment field contained either...

dhookom: I'm sorry, but I don't understand what you mean. I have a table with a field called Segment, and Intermodal and Boxcar are two of the many choices therein. Just now, I am asked to allow the users to choose Rail and have Rail = intermodal or boxcar. Does this mean I should create some...

I'll try it tomorrow and report back...THANKS ALL!

for 2) above: if they choose "Rail" from my combo box, how do I make that pick the records with "intermodal" and "boxcar" data?

I have a very complex query (based on several other queries and tables) and want to provide a combo box for user to select queried data. Question #1: is there any way to do that without VBA code, and if so, how? Question #2: user wants one of the choices (from this combo box) to be "Rail" but...