Recent content by jessabridge

1. I assume [mmax] isn't a field in [t Current Year PP Exception Hours], but is you're attempt to reference the [mmax] value in the query you are currently trying to execute. You can't do that. That value doesn't exist until you run the query, at which time it's too late to use it in that...

I have two FY in my table. 2014 & 2015. 2014 has 26 PP's. 2015 has 5 as of right now but it changes. I want the SMax column to equal 31 so I can use that number to average the LWOP hours in the report. Next PP it will have to be 32 and so on. I was trying to use the Dlookup to say when it...

I have a simple query. I made a IIf statement that includes a Dlookup. Before I added the Dlookup, all was fine. I added it in & it works! Wonderful! But when I hit Run, I get the attached error message. I click OK and it goes away. It even gives me the correct data. I have Access 2010 since...

That is what I ended up doing. I made all of the headers grey scale. My pretty blue is gone. :-( LOL Thanks for your help! Jessa

One goes in the report header and the other goes in your page header.

Same machine. But it is at the convert level to pdf, not to a paper form, The first pdf will have light blue & the second pdf will have color in the header row. Both reports have the same formatting, meaning that both reports have light blue in access for their herder rows. I can not put...

That might work too. My only complaint is the amount of reports this happens with. It will be very time consuming but if it is just a glitch in the machine....I don't have much choice. LOL

Nope, exact same formatting. I even checked all the properties numbers & it all matches...

I have two separate reports. They have identical formatting. When I click on Adobe: Convert to PDF, this is what happens. Report 1 will convert with light blue in the column headers. Report 2 will convert with grey scale in the column headers. I have no clue as to how to make them both...

I have a very strange question. Last week I had a Adobe PDF selection at the top of my Access database. It is gone. I still have it in my excel selection, so I know I did not delete the program. I need it back. When I Print to Adobe it is missing lines. This did not happen I I would click...

I actually just built my first macro to reopen the form and edit another day. :-) I used openform and set it to edit with the filter on the query. The command openform button did not work. I do not know why it was not working, but I figured something out. Thanks for your help! jessa

This is my query the form is built from: SELECT [Bus Off Timesheets].NamesTable, [Bus Off Timesheets].TimesheetDateTable, [Bus Off Timesheets].TimeInTable, [Bus Off Timesheets].TimeOutTable, [Bus Off Timesheets].HolidayTable, [Bus Off Timesheets].SickDayTable, [Bus Off...

I have a simple query that can edit the main table. I built a form around that simple query. When you open the form: it asks for a name & then a date to be edited. All works. I have a save command button and a close command button. All is good. I would like a “red explanation point” command...

OMG!!!! That worked! Just what I needed! If you can, but no problem if you can't, can you explain the input mask so I can learn? I tried and failed my input mask experiments. 00:00;0;_ I know that the first part is Medium time. What is the second half? Jessa

I can't get into the database. I only have 2003. At Jdraw@ Current time would not work. They enter the time in and out on other days and sometimes earlier. That would be excellent if they used the database like a time punch. Jessa