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

    Adding Blank LInes to a Report

    I am working on a report that will print out the Army hand recipt (DA Form 2062). The form itselt can consist of one page or multiple pages. The first page of the form has room for 16 lines of data, and each page after has room for 21 lines of data. In order for the form to be deemed "legal"...
  2. whjwilson

    Using Check Boxes to Select items to Print

    I currently have a form I am using to input data into my database. The form itself has a subform on it. The main form itself lists the information on the person, teh subform list all the equipment assigned to this particular person. I've added a new column on the subform in which users will...
  3. whjwilson

    Access Database Form Lookup

    I am fairly new to Access and have a question about a process I would like to do. I am working on a project tracker (form) that contains several tabs. The first tab contains all of the information of the project. The second tab contains the information of the person assigned to the project...
  4. whjwilson

    Storing Data from Form in Table

    I don't know if I am doing this right or not, but I have set up a conditional formula for a cell on my Form, but the value generated from the Formula in the Form does not store on the table associated with the form, the information only stays in the forms. This is the formula I am using...
  5. whjwilson

    Date Range Field

    I am trying to format my date range field. Is it possible to have a field display a default entry of INDEF for a date that won't expire and a date can be put in the same field if needed? Example: Name Valid Until Wilson INDEF Jones 08-Jan-08 Johnson...
  6. whjwilson

    Print Help

    I am trying to set up a button to print report that is currently open, this is what I have set for the click command code: DoCmd.OpenReport "Weapons Cards", acViewNormal, , "Name = " & Forms!Main!Name Whenever I click the button to print I get an error: syntax error (missing operator)in...
  7. whjwilson

    Report using two tables

    Is it possilbe to build a report in Access pulling information from two tables? How can I do this or make it happen? Thanks.
  8. whjwilson

    Print Access Report

    I am working on a database, and have a report built that I am trying to print using a Forms Page. I added a Command button to the page and have it set up to print, but when I print it prints all records. Is there a way to set it up to only print the current record using a Command Button? Thanks.
  9. whjwilson

    Query Not Working

    I am running a query on one of my tables in my database but it is not pulling the information I am asking it too. Here is what I have so far. Pass Issued by Date Issued Jones Friday, March 10,2006 Franks Thursday, March 9, 2006 The date is formated to give me the...
  10. whjwilson

    Auto Numbering Help

    Access newbie needs alot of help. I need help trying to get the Autonumbering feature to work right for what I need it to do. I don't know if it is not working because I have letters included in the numbering or what. But this is what I am trying to do, I want the field to automatically go up...
  11. whjwilson

    Query Help

    I am trying to run a query where I can pull entries that have a certain field. For instance my database tracks companys that are inspected and who conducted the inspection. I want to be able to go in and pull the list of inspections conducted an individual. Company Inspected By A Co...
  12. whjwilson

    Need assistance in setting up query

    I am trying to set up a query and report using access, but am unsure how to proceed. What I want to do is set up a database listing units and company's I inspect, and in turn set up access to give me a list of units or company's that are due their annual inspections. For istance my main table...

Part and Inventory Search

Back
Top