Search results

Thanks again. I did screen shots of the window sticker design, the tables in the database, the query design, and tblModelStandardFeatures design and attached it to the reply. It was too big to send, even after zipping them into one file. My database size after compacting and zipping is 254...

I would be more than happy to send a screen shot if this was possible. But I cannot seem to get my computer to do a screen shot. I don't know if its me or the fact this is such a new computer I cannot figure it out. Can you tell me how I can accomplish this task? I have a Pentium 4 Gateway...

Sometimes I am not too good at explaining. I would be glad however to attach the db but it is too big. Any suggestions.

I have a report on which I need a list of items to print. The report is similar to a window sticker on a car and gives details about a unit in our inventory. The list I need to print is a list of standard features for the unit. The list comes from a table. Of course, there are multiple...

Thanks Rob for answering so quickly. I tried what you said but I am still getting the error. I am writing a database to track boat inventory and print window stickers. Any other ideas? Or is there some part of my database I can attach to the message and perhaps you can help me to find the...

Can anyone tell me how to find and correct an application-defined or object-defined error? When I click the OK button, the message goes away and my form page works fine. But the message appears everytime the form page is opened. I have checked the help section and cannot find mention of this...

Is the problem that I deleted the selected options via going to tblModelOptions, highlighting all records, and deleting them, instead of double clicking the option on the form to delete it. However, please note the reason I deleted this way was because I was getting the No Match Found message...

I have a text box which populates when you double click an item from a list box. Likewise when you double click an item in the text box, it should remove the item. The purpose is to select options on a vehicle in inventory. The list box shows all options available and the text box shows the...

I changed the last mention of txtModelID to the full identifier. But this did not work either. I may need to mention the first On click is related to the NEXT command button on page 1 of the form. The second is related to the NEXT button on page 2 of the form. Did I change the correct...

3 forms exists. frmInvEntry frmInvEntryPg2 frmInvEntryPg3 Question: When I move from frmInvEntry to frmInvEntryPg2, selections made in frmInvEntry carry forward to frmInvEntryPg2. However, when moving from frmInvEntryPg2 to frmInvEntryPg3, prior selections made are not carrying forward. Why...

I have a query that includes a field for ModelID and one for MotorID. The criteria for ModelID is 125 (for ModelID 125). The criteria for MotorID is a range of numbers, not necessarily consecutive. MotorID = 6,16,17,18,19,20,21,30. (The motors with these MotorIDs are the only motors...

I have the following tables: tblModels --fields-- ModelID BandID ModelName MotorID etc. tblMotors --fields-- MotorID MotorBrandID MotorName etc. I need to link the 2 tables via MotorID. The data type for the MotorID field in both tables is "number". Please note that not all motors are...