Search results

Awesome, THANKS for the help!! Everything is working great now, thanks again!!

Here it is stripped of sensitive data. Please excuse how terrible it looks, i had to jumble things around a bit to remove all the company info. The test db was larger than the 393k limit this forum has so i sent it out on MegaUpload, hope that is ok. http://www.megaupload.com/?d=JQP9Y9Y5...

I've been playing with this for a while and i'm really not getting anywhere useful. It now prompts for "PO Number" with an input box but regardless of which number i enter, it still shows all items in the table. Maybe you can help me re-write the code from scratch, i just want to click the...

Yes it is a text field. Print_PO_Query is the query the report is based on. If i run it by itself it populates correctly but prints out all the POs i have in the database. I just want it to print out the Purchase Order in [PO Number] on the form

Actually this is an exact copy/paste. I have modified the code to: Private Sub cmdPrint_Click() Dim strWhere As String strWhere = "[PO Number] = """ & Me.[PO Number] & """" DoCmd.OpenReport "Print PO", acViewPreview, , strWhere End Sub However, the same problem...

I have an access form with a command button, cmdPrint. I got some source code from another access website to display a report, which is linked to a query, and only display the report number on my form (which is also my primary key) Now when i click the cmdPrint button, it prompts me with...

No error message, it just returns no rows. For instance, i have a purchase order dated 8/23/06 with the code IM. If i run a query for dates between 8/22/06 and 8/24/06 with the IM code, it returns a blank query window.

Hi all, I'm working on a purchasing app in access. At this point i'm working on the reporting module. I want a user to be able to fill out a start date (text box), end date (text box), and select a code from a list, hit Run Query, and have it pull up a report listing the date that the selected...