Recent content by JSD

Thanks Guys -- Works Great

Hello I am working with a db on a network with multiple users. There are four different computers using it. I am running this code after update of a 'wc' control: If DCount("[wc_code]", "dbo_rtemastr", "[wc_code]='" & Me!wc & "'") > 0 Then 'Do nothing Else MsgBox "This is not a...

Thanks guys

Hello, I am working with a query that has a calculated field that subtracts two date fields to get its value. I want the sum of this value in a chart with 'date' as a baseline. However, I am having trouble getting msaccess to do anything but count the records for the calculated field. I get...

Hello, I am working with a query that has a calculated field that subtracts two date fields to get its value. I want the sum of this value in a chart with 'date' as a baseline. However, I am having trouble getting msaccess to do anything but count the records for the calculated field. I get...

Mike, Thanks for your time and knowledge. Jeremy

Hello I am working with a query that tracks log in times and log out times of employees. When the users log in, they are either logging in to run time, set-up time, or down time. They can specify set-up or down time by checking a box for either. All in one query, I want to have calculated...

Hello I am working with a query that tracks log in times and log out times of employees. When the users log in, they are either logging in to run time, set-up time, or down time. They can specify set-up or down time by checking a box for either. All in one query, I want to have calculated...

SteveR77, Hello. I have two date/time fields that I subtract in a calculated field to get the 'act hrs' value, which is numeric. I would need to subtract one half hour from the 'act hrs' value, If the value is greater than 6 hrs. Thanks for your time Jeremy

Hello I am working with a db that employees use to clock in and out of jobs for production/ efficiency tracking. I don't want them to have to take time to clock out for lunch. Is there a way to maybe create a calculated field that subtracts one half hour from another field called 'act hrs' if...

Hello, I am working with a db that I just recently split manually. Now the forms in my front end take forever to open. Could someone possibly share some pointers on how to improve this performance? Many thanks as always. Thanks Jeremy

Hello, I am working with a db that has a switchboard with various command buttons I would like to hide if user login name is 'shopfloor.' Can this be done? Thanks Jeremy

Hello, I am workin with a db that has a form and a subform. The subform has a couple of controls on it that have If IsNull functions, then msg box. The only problem is that when the user clicks ok after an IsNull msg, The bogus value is still there. In fact, once I set focus away and back to...

Hello, I am workin with a db that has a form and a subform. The subform has a couple of controls on it that have If IsNull functions, then msg box. The only problem is that when the user clicks ok after an IsNull msg, The bogus value is still there. In fact, once I set focus away and back to...

Hello again, Thanks for your time and expertise. I hace tried what you suggested. Now I get the error 'the object you have referenced in the Visual Basic Procedure as an OLE object isn/t an OLE object.' What does this mean? Is there a way around this? Thanks, Jeremy