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!

  • Congratulations Rhinorhino 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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.
  5. 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]...
  6. 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...
  7. dragonmanUSMC

    Searching by Zipcode

    I have a form that allows us to view all of our customers in our customer database, (one customer at a time) is there a way to create a form that ask the user to input the zipcode of the company they want to see and then open the customer form that will go to that customer?
  8. dragonmanUSMC

    Problem with Find/Search Script in Data Access Page

    Hello, I have a script that will allow the user to search our database from a data access page for a company. (search is by CompanyName) I orginally posted this problem in the MS Access Other Topics forum but I haven't rec'd a response yet. Here is the problem: The script only works after you...
  9. dragonmanUSMC

    Problem with FIND/SEARCHING script in Data Access Page

    Hello, I have a script that will allow the user to search our database from a data access page for a company. (search is by CompanyName) Here is the problem: The script only works after you have created a new company entry in the database. If you try to run the FIND script without entering new...
  10. dragonmanUSMC

    Bound Column Question?

    OK I hope I can properly explain this: I have a form that has a subform that is viewed as a data sheet. The user will select a product from a drop down list on the subform, it will automatically input the base price as recorded in the inventory control, they will then input the quantity ordered...
  11. dragonmanUSMC

    Truncation?

    Greetings, I have a form that has a few checkboxes,when checked, will show several fields, when not checked, will hide those fields. My problem is I would like to truncate the form so that if the fields are not being shown there aren't any gaps in my form and ofcourse when the fields are...
  12. dragonmanUSMC

    Confirming a calculated value is within range

    I have a form that my co-workers will input design data on, there is a field that will calculate the rim speed based off of the data they provide. (I know it's not a good idea to perform calculated fields on a form, but this is the only instance this number will be needed. The control source...
  13. dragonmanUSMC

    Default Search Options

    Good Day, is it possible to have the "Match" field in the search/find option in access to default to "Any part of field" rather than "Whole field"? This is more of a convenience than a necessity. Thanks for any input

Part and Inventory Search

Back
Top