Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dragonmanUSMC

  1. dragonmanUSMC

    Assistance Needed Retrieving Record Data

    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.
  2. dragonmanUSMC

    Assistance Needed Retrieving Record Data

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

    Printer Dialog in Access

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

    Printer Dialog in Access

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

    Printer Dialog in Access

    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...
  6. dragonmanUSMC

    Assistance Needed Retrieving Record Data

    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...
  7. dragonmanUSMC

    Finding a specific Record in Inventory

    thank you for the reply I will try your suggestion
  8. dragonmanUSMC

    Finding a specific Record in Inventory

    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...
  9. dragonmanUSMC

    Orders Reminder

    John thanks for the advise I'll try it
  10. dragonmanUSMC

    Orders Reminder

    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.
  11. dragonmanUSMC

    Sorting/Viewing by a specific Date

    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
  12. dragonmanUSMC

    Sorting/Viewing by a specific Date

    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...
  13. dragonmanUSMC

    Sorting/Viewing by a specific Date

    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...
  14. dragonmanUSMC

    Sorting/Viewing by a specific Date

    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...
  15. dragonmanUSMC

    Sorting/Viewing by a specific Date

    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...
See more

Part and Inventory Search

Back
Top