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: merv805
  • Content: Threads
  • Order by date
  1. merv805

    Calculated Field inside a Subform??

    I have a purchase order database that has a subform with many products. I have already placed a "sub-total" control that is =[Quantity]*[Price] The problem is that I can't seem to figure out how to use that control "sub-total" and calculate a grand-total within the...
  2. merv805

    Printing a Report Directly from the Data Entry Form

    I have a purchase order database. I have an autonumber field (Purchase Order ID#) that gets generated when the user inputs data. I would like to insert a command button into this form that grabs that Purchase Order ID # and brings me to a report that displays the same information, with out all...
  3. merv805

    Combo Box based on a look up table query

    I have a form that has a combo box that queries its contents from a table. If a user were to type in something other than what's inside the combobox list, is there a way to automatically update the table. So that I would not have to type the record inside the look-up table manually. Hopefully...
  4. merv805

    Subform calculations using a control source value....?

    I have a purchase order database that has a subform with many products. I have already placed a "sub-total" control that is =[Quantity]*[Price] The problem is that I can't seem to figure out how to use that control "sub-total" and calculate a grand-total within the...
  5. merv805

    How to import an Autonumber field in to a textbox in a VB form??

    I am trying to display the data from a table with the property value as a "autonumber" into a label box on a form inside VB. Do I have to make any necessary conversions of data types to insert this "autonumber" into my label's caption. I also had another had another...
  6. merv805

    Converting files into .TXT format inside Access???

    I have several folders with text documents with the extension .DAT. I need to import those files into Access, and I heard that you may be able to change file exetensions to .TXT within the Access program rather than in the Command Prompt. I was wondering if there was a way to do so, because a...
  7. merv805

    Trouble Importing data from .DAT file

    Im trying to import a text file with the extension .DAT. This text file was created by a scanning documenting system. These system files will be needed to be imported Access on a regular basis. I have tried to import using the "Get External Data" menu and went through the entire...
  8. merv805

    How to filter reports based on user input?

    I am creating a purchase order system. I have created a welcome screen that has a command button that should be able to print out the purchase order report. The question is how do I restrict that report to only display the report based on the purchase order # the user wants? Is there a way to...

Part and Inventory Search

Back
Top