Search results for query: *

Well I'm afraid I'm still as lost as I was before, any other advise offered would be great. In the mean time I'm going to continue trying to work this out.

Thank you for the reply, I will try your suggestions and post back with any new info. Best regards

Thats close to what I need but it is wanting to print all the records.

Thanks for the reply, the button is on a form that calls a report to print

Greetings, I need to know how to get the printer dialog window to open when a button is pressed to print a window. Right now, when you go to print a report the default printer automatically begins printing and when I select a specific printer that will automatically begin printing as well. Any...

I am having great difficulty retrieving data from records that are selected via a drop down list. I am going to try and explain the relationships that I have in this DB. First we are talking about data in two tables 1. Order Details 2. Products Second we have two forms and two subforms Forms...

thank you for the reply I will try your suggestion

Greetings all, I have a DB that is used to process customer orders. When the user is filling out the order there is a subform with the order details. (Product being ordered) The user will select a product from the drop down list. If the user double clicks the drop down field it will open the...

John thanks for the advise I'll try it

I have a database that is used for entering customer orders. What would be the best way to have a dialog open each time the database is opened informing the user of how many open (non shipped) orders are still in process? Any suggestions would be greatly appreciated. Thank you in advance.

I changed the Modal to 'NO' I'm going to continue working on the last issue with missing orders on the report. When I figure it out I will be sure to post my solution so that others might benefit from my struggles. I greatly appreciate your help Tom have a good day! Kenn

When I prompt the report from the query itself It returns the same 3 records. I will fiddle with teh Join and see if I can't come up with anything. One other thing, after I have entered the start and end dates in the frmDateSelect form, I click on my preview button and the report opens but the...

Tom thanks for the reply the sorting issue is resolved...thank you. Here the sql for my query, and there are two tables involved here Orders and Order Detail here it is: SELECT Orders.OrderID, Orders.JobOrderNO, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.ShipDate...

Tom thank you for all your assistance, I have applied your latest recommendations and it seems to function almost were I need it to be. I say almost because of two issues. 1. If I enter in a start and end date that covers a two week period the orders are not sorting in ascending order by order...

Tom, I am still having problems getting this to work properly, I have followed each of your recommendation, however when the report open it does not initialize the form frmDateSelect. I put the following in the on open event of the report On Open: docmd.openform "frmDateSelect",,,,,acDialog...

Tom thank you for the reply I will try that out and let you know if it works. Kenn

I have a report based off of a query that shows all of the sales orders that have been processed into our system. What I would like to do is view the orders in my report by date and to only show the date I am intrested in. Right now I am using the 'BETWEEN'[beginningdate] 'AND' [enddate]...

I appreciate your timely reply although I do believe I have found an adequate solution. I sorted the column/field in the subform datasheet view and then froze the column. I have since then exited and reopened the database several times and it appears to be holding the descending order format on...

I have a subform that shows orders in a datasheet view, I would like to know how to sort those orders so that each time the user opens a the main order form, regardless of which customer it is, the subform will sort that customers orders in descending order from newest to oldest by job order...

Thank you for the replies, the zipcode in a combobox really isn't what i'm wanting to go with, I will try the argument as suggested by TheAceMan1