Recent content by The John Rambo

If you have an Autonumber field in your table (e.g. AutoID), instead of... Expression Is : [IsRecord]=-1 And IsNull([txtNetProduct]) you could use... Expression Is : NOT IsNull([AutoID]) And IsNull([txtNetProduct])

I had the same problem where the subreport did not show when printed or exported to any other format but showed on my screen (preview). I could print the sub-report/export by itself with no problems. I systematically deleted the controls on the subreport until the subreport showed up when...

Take a look at these threads and see if they help... Modify stored query using VBA This one also might help

You can move to the previous record by inserting .Moveprevious Set RstInv = dbInv.OpenRecordset("Inventory") With RstInv .GetRows ([StrBarcode]) .Moveprevious .EditIt may not be the best method but it'll work. :rolleyes: You got an error because you need to...

Try using the IIf Function: MaxiCost: IIf([Maxi]=-1,160000,0) With Currency format: MaxiCost: Format$(IIf([Maxi]=-1,160000,0),"Currency")

I see that you are entering the data into the table and not via a form. Try replacing: 'Open Marketing Form DoCmd.OpenTable "Inventory" 'Add new record OK up to here DoCmd.GoToRecord , , acGoTo, StrBarcode 'goto line 9...

You can hide the True/False field by disabling Show: in the design view of the Query by clicking the checkbox. (See attached JPEG). 1. Please send me the layout of all of your tables involved (including links) e.g. Table1: WorkToBeDone Field1: Stores Field2: Works Field3: Cost

Hi bobp, Did you manage to get a solution to the problem in your "copying data from one table to another" post? The John Rambo

Apologies, the code I entered was incorrect for ur situation :o (removed). If you are running the append query from a macro you can change the Setwarnings options in your macro. Insert an Action before your append query and select "Setwarnings", change the option to "Warnings Off" then insert...

I would suggest removing the BeforeUpdate Procedure completely and placing the TURN OFF code just before the event and the TURN ON code just after the event that is causing the undesireable system messages. As Pat has described, leaving system messages off is very dangerous because it doesn't...

In the VBA editor insert the following code before you run your query (Turns OFF all system messages): DoCmd.SetWarnings FalseAND insert the following code after you run your query (Turns ON all system messages and refreshes the form): Please note if you do not turn on again NO system messages...

Change the name of your PAINTING control to something else e.g. txtPAINTING. There is a "Painting" property for forms which can only be set to TRUE or FALSE. When you enter you refer to the property of the form and not the control.

Please post the code you are entering into the query?

Try these sites... They may help. *See attached Notepad file This forum has also helped me alot by just reading the questions and the replies. I suspect you will need these two functions, not only to solve this problem but in many others. I use them quite regularly. 1. Dlookup() *See attached...

I think what Gina is trying to say is do you have a field in your table that can differentiate what is displayed in the three different sub forms. E.g. A field called "Allocation" which you include into each of your subforms as a combo box. You will then be able to select "Order Form", "Back...