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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dragonmanUSMC
  • Order by date
  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...
  16. dragonmanUSMC

    Sorting/Viewing by a specific Date

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

    Sorting/Viewing by a specific Date

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

    Subform Sort

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

    Subform Sort

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

    Searching by Zipcode

    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

Part and Inventory Search

Back
Top