Search results

Thanks for responding. Here is my SQL. In this particular one I just tried to total the 7 fields ending in B101-B107. SELECT [IN Part Master].INPM_PART, [IN Part Master].INPM_DESC, [IN Whse Quantities].INPM_BWID, [IN Part Master].INPM_SNAM, [IN Part Master].INPM_ASK1, [IN Part...

I am have difficulty in developing an average of seven months of transactions in a query based on three tables involving inventory. Inv Master Table, Invoice Item Qty History Table and WarehouseLocation Qty table. The plan is to use the last seven months of transactions my inventory line and...

Here is a response that Bob Larson gave me for a similar problem. It works well for me. For future reference, I think I would make it easier on yourself by using a listbox which can AUTOMATICALLY list all reports available, so you never need update the controls on the form and you can let it...

Thanks for working with me on this. I can't get the form and code down small enough to post. Have the increment working as I indicated in my code posting but is doesn't cover all the possible scenarios, such as, the user tries to add an order to a route A, as an example, if there has been...

Paul I'll see if I can get the essentials small enough.

Using this statement appears to do nothing. I don't get a result. The order gets assigned a Route letter but no sequence number. Do I have something out of place? Private Sub Combo35_AfterUpdate() On Error Resume Next ' Find the record that matches the control. Me.RecordsetClone.FindFirst...

Thanks Wayne I get "Wrong number of arguments" when I run this code. PegRoute is an unbound text box on my form. PegDelSeq is an unbound text box on my form. DeliverySeq is the sequence number on my table RouteId is the Route letter on my table. I have additional code in the afterUpdate for...

Thanks for the help Paul, So far I can't Dmax to work for me here as I have to reset the value to 0 when the Route letter changes and its all part of the same table. I don't know if there is a way to make Dmax look at the Route letter to find the Dmax of the Sequence number?

Thanks for your help. I have moved on now to more critical issues. I just posted my results in case some one else has the same issue. I will again try and solve it if I have a future problem. Thanks again, this site is awsome.

When you say the combo box is empty are you say that you cannot select a flight number from the drop down? I would dump the combobox and redo it. You used the correct procedure to sort so I don't know what the problem might be.

Thanks RG, For others that do the same dumb things I do I also found that that there is an option for More Commands in the Customize Quick Access drop down menu lets me get back to the Access Options fields. I'm going to have a lot of fun going back to Access 2003.

Thank Paul. I'm sorry I am so dense but I have viewed the Dmax before and I can't understand now to apply it. Could you give me an example on how to use it in this situation?

I have had results you are looking for by adding an unbound combobox to the form and in the wizard that follows select Find a record on my form then use the flight number field as a lookup. Then when you view your form in Form View either type in the flight number or use the down arrow to select...

The problem still persisted after I copied the name from the report widow. It only resolved when I deleted the report and rebuilt it with the same name.

My form is based on a table. The form updates table fields by user as they assign a Route ID and a Delivery Sequence to each order selected. I have one text box that updates a route field with a letter A through F, and one text box that is currently manually entering in a sequence number for...

I changed the option to Current Database by unclicking the Ribbon & Toolbar by unclick the Allow full menus to see what would happen and now I can't get to the Options screen to change it back. I tried all the F keys so I assume its some other tricky thing or I have to go to backup. Thanks for...

Thans for responding I know you think it is obvious but as I told you in my original post that that was what the error said it was. What I am saying is the name is not spelled wrong. I click on the report in the object screen and selected Rename copy pasted it in to the code and I still get...

This code allows the user to select any or all of the reports by clicking on a check box on a form and clicking the Command0 button to print. Every report prints out except the Production report down near the bottom of the code. The error says I don’t have a report by the name listed. The report...

Great info. Thanks

Thanks RG, I get a real eductation on this site.