Search results

Hello, From a Form where I input information to be printed, I always have to re-open the form in order to print (otherwise, it doesn't print the most recent information added.) Is there a way to get my VBA print command to create a report to print with the most recent refreshed information...

Hi, I'd like to have multiple lines displayed in a subreport for each entry, for example ------------- Description PartNumber EntryNumber Delivery Date Comments ------------- Description Part Number EntryNumber ...etc I think this should be...

Is it possible to open a report on startup? I know it's easy to open a form on startup, so I assumed it's the same for reports, but no no no. Any tricks?

Hello, I have a few openform buttons that I'd like to open on a "New" entry.... I've tried entering new in the where clause of the macro action, but it doesn't seem to be working like this... Action Arguments OpenForm Enter/Edit Orders, Form, , [OrderID]=[New], , Normal Much...

Hello, I have a WorkOrder Print Button in a form that I want to print TWO copies instead of the standard one... Could someone help me with where I need to add to my VBA. Private Sub PrintWorkOrders_Click() DoCmd.OpenReport "WorkOrders", PrintOut, , _...

Hello, I have a receiving log where WorkOrder numbers are attached to each receiving ID.... I'm trying to have a "search query" option inside my input form. I save the input (4 numbers) in a blank text box called [SearchInput] and then have a button to open the query I want to filter...

Hello, I have a button in my form to print work orders... I'm trying to have a selection box below the print button be automatically checked once I print. I've tried adding a "set value" in VBA below the printing code, but that didn't work.... I've also tried "setvalue" in a separate macro...