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

...be doing something wrong: Public Function getnumberofBlanks() As Integer Dim recordCount As Integer Dim N As Integer recordCount = DCount("*", Me.OC) If recordCount <= 16 Then getnumberofBlanks = 16 - recordCount Else N = 1 Do while N * 21 + 16 <= recordCount N =...

...'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 = DCount("*", Me.RecordSource) Not sure what I am doing wrong. The field size are all set to the max of 255.

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.

...formated to give me the Long date. I want to run a query to see for instance only passes issued on a Friday day. I have this for my SQL: SELECT * FROM Main WHERE (((Main.Date_Issued) Like '*Friday*')); Main is the title of my main table. The query will not run as I thought it would and...

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.