Search results

Hi Shutzy, I can copy my tables & remove the data [and the forms] however I am not sure how to upload these? We are wanting to process on a given day each month however sometimes this day is missed due to excessive work load. Hence my need for the pop-up to ask me if I want to re-schedule the...

I would like to create a pop-up reminder whenever I mark an record Billable ([Yes/No Field]) in my WorkDetail table. In the pop-up I want to enter a date for the next Billing date [for clients who are charged a monthly management fee so that this cannot be overlooked each and every month]. I...

I have tried Field Value "less than or equal to and less than" 00:00:00 and 0.00 [latter being how the value looks in the report field]. Also tried Expression Is with above time format and got an error message about Invalid Syntax with both attempts..

Hi Paul, Thanks for your reply. I have the format in the back end table as 00:00:00 and then in the report this expression to convert total minutes to hours : =[TotalMinutes]\60 & Format([TotalMinutes] Mod 60,"\:00") I have managed to get the conditional formatting to work on all other time...

I have tried to change the colour of the text in time fields with no a value of 0:00 by using conditional formatting - to no avail. Is there anyone who can help with this?

Hi I am new to this forum and introducing myself as an amateur Access user. However I have been creating Access databases since 2006! With no programming training I am limited but have found Access to be an amazing tool for everyday business processes.