Search results for query: *

Here is a copy of the database I have been working with. For some reason it still will not insert the blank lines into the report. The second page should have 15 blank lines. http://www.mediafire.com/?a3rcevxg0u3ch3r

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"...

MajP - Thanks for the quick reply. I put your code into my database, but now get an error: Run-time error '3163': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. When I Debug the error shows at this line of code: recordCount =...

MajP - I am working on a similar issue with the DA Form 2062 and came accross your thread. I see your post and sample database you provided but could not download it. I tried going about the issue in a different manner: I ended up cutting up the DA Form 2062 and breaking it up into several...

The name of the new column is "Selected", it was not in the record source of the report but I added it, and changed the code to: Dim strWhere As String strWhere = "[Name] = '" & Forms!Main_Table!Name & "' AND [Selected] = -1" DoCmd.OpenReport "Main_Table", acPreview, , strWhere When I run it...

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...

Never thought of that, let me give that a try.

I am looking for a way to be able to generate a report using the date from this cell as part of that report. Is there a way to bring up the information in this cell in a generated report?

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...

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

lespaul thanks for the help, I kept putting in the wrong field name when I was trying it earlier.

I have input the above code in, and it is still printing all records. I may be doing something wrong with the "ID = " above. Form I am trying to print is titled Full_Pass_Print so I modified what you have above to: DoCmd.OpenReport "Full_Pass_Print", acViewNormal, ,"ID = " &...

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.

Thanks Golom, worked perfectly.

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...

PH, thanks code worked great.