Search results

Hi, Any help would be appriciated. I have an order form with a subform for the parts ordered. The forms are linked. The parts ordered form gets parts information from the parts table (there is also a parts ordered table of course.) Problem is when I change the price on one line (maybe a no...

I have a table that holds invoice information. I have a query that gathers the information for printing the invoice. I need to be able to change the invoice date on the invoice form before I print (as in reprint on a differant day) Problem is it pulls the date from the table not from the form...

I have a querie that gets data for packing slips and invoices. (Same querie) Yet when I print or view the report the line item parts are reversed in order. Any ideas??

Thank you Jack, that was great. Lon

When trying to specify (in a macro) a control from a subform on a open form, the macro errors saying that it cant find the control. If I open the subform alone and run the macro it works fine. How do I get the macro to see the subform so I can specify a control in it for a condition in the...

Works great ! Thanks Richie.

Richie, That seems to have helped but it turns out that by forcing the user to leave the orders screen after they enter the appropiate data, I can control the flow better. Thanks very much for your help Lon

How can I cause a form to open maximized each time it opens? Thanks

OK I found out that if I leave the form from which I am processing the records, I do not get the Key errors. So I set the macro to run on the On Unload Event and it works. Can anyone tell me why and what I can do to be able to stay on that form and process successive updates. This is also true...

I am using 7 queries to build an packing slip and invoice data table including incrimenting the Invoice Number. When I run the queries one after the other manually they all work fine and the record gets built. When I put them into a Macro the first time it works fine. The second time I get a...