Search results for query: *

Thanks Pudda & Linney. Both suggestions were viable, however I have already tried both to no avail.

I am connecting to our server from a remote office. I want to print from the server, which is running WIN03 sm Bus Serv. all client computers run XP Pro sp2. I have ensured that the printer box in the local resource tab is checked. RDP port 3389 is open on both ends. Drivers are installed. There...

I am pulling POS sales data into a query. I want to display this data by date ranges, however the timestamp is getting in the way. In my query I tried the following code, but it returns multiple years and does not recognize zeros? ie. I ask for date range 11/01/2006 - 11/15/2006 returns data...

Thank you gents, I was finally able to get it to run the way it is coded. I was forgetting to add the start and end date criteria to the query. So now it's all tied to my switchboard and running smooth, I appreciate all the feedback from those of you who posted. Thanks again, I am sure I will be...

PVH, Is there a way to get the code to work for a form. i have changed everything that references "Report" to Query. In the last staement after acViewPreview I keep getting a compile error, it does not like the "strWhere". If I remove it I get a return from the query of all data in the Db, not...

[Dim strQuery as string] [strQuery= "qryDateRange1"] I pulled the code form another site, and it said it could be used for a query or a report. I have tried the code both ways, neither gives results.

thanks Randy I appreciate the reply. Unfortunately the suggestion weilded no results.

I am trying to set up a form, in which the user can input specific date ranges to call data from a query. The form is set, and accepts the date inputs however it is not returning any data from the query. Here is the code I used to build the form: [Dim strReport As String 'Name of report to...