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

    Questions on forms with a subform

    Im creating a form with a subform in a table format. What Im trying to do is specify what records I want to show using a combo box. So if I want just all records from CA to pop out, I will pick this from my combo box and the subform will just display the record that have CA. How do I do this...
  2. jeprox

    Making certain fields "invisible" in Queries

    I have created a query for my Shipping Log. In the standard order forms in Access, the Bill TO is usually the Ship To unless you enter a specific Ship To when entering the order. From my query , I have both the Bill To and Ship To fields available. In my actual report, I dont want the Bill...
  3. jeprox

    Query Commands

    I am trying to create a Query. It is based on a table of Customers. If the command for specifying dates is " Between [Beginning Date] And [End Date] ", what would the command be for specifying other fields so I can sort it by state , classification etc.? Any answer is greatly...
  4. jeprox

    Question on Generic Databases

    In Acess, there is a generic database for Contact Management. Lets say I created this and named it Contact A (all belonging to a certain Category). Now I need to create a new category so I created another one of these generic db's and named it Contact B. My problem is this: When I try to import...
  5. jeprox

    Command for a query

    I just created a query with data from a table.One of the fields in the table is Invoice No. When I open this Query, all the record appear. I need to have only a specific record based on a criteria to show up, in this case, I want to pull up a specific Invoice No. My Invoice Nos are formatted...
  6. jeprox

    Question on subforms

    I have just created a form with 3 subforms. However, when displayed in the form, each subform still has the gray vertical bar on the left side with the little triangle icon on top,Also the bar on the bottom of the subforms that shows the record number and directional arrows also shows. Is there...
  7. jeprox

    Creating a Date Range for a report

    I'm fairly new with Microsoft Access so please bear with me. I have created a report based on a table. However, evrytime I preview this report, it will open all the data from that particular table. What I need to do is create a button that will ask for a date range. Subsequently, the report must...

Part and Inventory Search

Back
Top