Recent content by roseyo

I am trying to unhide my tables & queries. I opened my Access file and all my objects disappeared. In the Navigation Options, when I click “Show Hidden Objects” I see my hidden objects. Now, all my tables/queries in a light grey. I looked at Table Property attributes: hidden is...

I did and it still doesn't work. At first page of #4 position name, it had Page 2 of 2 several times and then page 1 of 1 when the total pages should be 4. I may have to do w/o the total pages of each position name and use Page 1, Page 2, Page 3, etc. Frustrating!

Speaker 86...thanks for all your help. I see that it's working for the first 3-4 positions but then the rest of the group page numbering isn't working. I will play w/it to see if I can get it to work. It seems everyone who had tried this code, it's not working for them either. Wish I can get...

:( I still couldn't get it to work even though I corrected the format, deleted Else, and moved the Me! line. Can you please correct the code in my file and send it back? I would like to run the report and see what you are getting because my page number has #Name?. Thanks.

Depending on what you are trying to capture but these are the two tables you need to create with the following fields: Table 1 StudentID - AutoNumber(Primary Key) First Name - text Last Name - text Table 2 StudentID - Number Date - Date/Time...General tab - format as short date Time In -...

Thanks for your help! I greatly appreciate it.:)

It doesn't work. When I cleared the text box control source property, the text box becomes unbound and no page numbering will show. I need it to print "Page 1 of 3 - Accounts Payable" and "Page 2 of 3 - Accounts Payable", etc.

Thanks, Speakers_86, for your advice but I'm not sure what I'm not supposed to enter in the property of the control. Can you please take a look at the attached file and provide detail step what I need to do? I'm not too familar w/VB codes.:confused:

I need my report to print total page numbers for groups of records, not the overall total pages for a report (i.e. "Page 1 of 5" for group 1, "Page 1 of 3" for group 2, etc. I used this code below that I found on the internet but can't get it to work. I replaced "Salesperson" w/my group...