Search results

Can anybody please give me a link to where I can download the Access Shortcut (right-click) Tool by Dale Fye

EDITED How do you arrive at the values you have in the "From" and "To" columns of the second diagram

Instead of copying the code, what happens if you Call the buttons Click event.

Try: <CInt([How many months?])

can you post a copy of the db with a few fictitious records to illustrate the problem

can you post a copy of the db

you get that when you try to create the accde file. Open any code module, click Debug and try to compile the code

My guess would be that your code won't compile. Try to compile it and see if it shows some faults

Ebs solution works. See attached file

I don't know what you can do. Have you tried to attach a video file/

Have you tried creating a new db and importing the relevant form, query and table. Delete all records in the new db and then create a couple of fictitious records. Compact, zip and post the file.

From post #12 Can you be more specific

I would be surprised if you could apply conditional formatting to a field at the table level, after all, tables are for storing data, not for viewing.

Hi Rocky. Welcome to the forum :)

Try Is Not Null

Can't you share it with us? :(

In plain words, can you explain what criteria you want to apply?

Good. Always glad to help if I can ;)

In that case, I would use the following expressions as calculated fields in the query: startOfDay: DateValue(Now()) endOfDay: DateAdd("s",-1,DateAdd("d",1,[startOfDay]))

Where do you want to use it? In a query, you could use each line as an expression to create a calculated field for each value. On a form, you could use: = GetCurrentDayDates()(0) and = GetCurrentDayDates()(1) as the Control Source properties of two unbound textboxes.