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"...
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...
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...
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...
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...
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...
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.
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.