Search results

Hi, I have been using the audit trail below, which seems to work fine for adding new records. I am trying to set up a form which will allow me to use a Find and Replace Command button to filter to the specific record I need to change. Once I have completed the change and try and log out of the...

I am having an odd issue with an audit trail I hope someone can help me with. I am using the module below that I got off this website. It seems to work perfectly fine with my forms that have subforms, but on a normal form the audit trail is kinda screwy. I can see it on the form, but it does...

HI, I performed a search to find some code to track when a user logs in and out of the database. This is what I have been able to find. The problem with it is when I try and run the code the debugger comes up and has a problem with the Line: Dim strUserName As String, db As Database, r As...

:chomp: I am trying to get fields highlighted when they are due. In my report I have dates listed by month they have been on stability. I need to highlight the date when the month/year is current. Example in the report the 12 Month column is all due in Oct of 2005, I would like for it to be...

In my report I have date fields that span over 5 years with different pull dates ex. 3, 6, 9,12,24,36,48 and 60 months. I have successfully formatted these fields using the conditional format by: Expression Is Date()<[9 Month] and Date()>[6 Month] for the 9 month field and so forth for each...

I want my fields on the report to show up if there is data to show and to disappear if no data is avaliable. Also, will the fields format together or will they still stay apart? I need them closer together for the report. Here we go. In the report are months 1, 2 and 3 as well as the label box...

Hi, I am in need of help to sort out some records. I have tow existing queries I would like to combine and get one final set of records out of. They go like this: Query 1. (unique #) Lot Protocol Sample # 1 mth 2 mth 3 mth X ABC 1...

I am needing help with the code to select different queries based on different conditions. The database is to be set up so that I can pull studies at different time points based on if they are under long term, accelerated or stressed conditions. When this condition is selected there are only...