Recent content by EdwardsC

I can set up a parameter query to filter between dates but is there a way to filter between dates & times I.e 06/26/22 08:00:00 AM to 06/27/22 08:00:00 PM?

In a separate table, define what user levels has access to your forms using a yes no field. The employee can simply login and the employee ID can be saved as a temporary variable. Each form can have a DLookup to that looks for the employee and whether that particular employee has access to the...

Thank you for all of the suggestions. I took arnelgp’s suggestion to open the form in dialog window and it’s working the way I want it too. The field clears!

theDBguy I tried dimensioning a variable and assigned Text8 and the same thing occurs. When I run the code like this, the field Text8 field goes Null. It's not ideal and requires an extra step but it works if there are any other suggestions? Private Sub Timeclockbtn_Click() DoCmd.OpenForm...

Private Sub Timeclockbtn_Click() DoCmd.OpenForm "TimeclockF", , , "EmployeeID=" & Text8 & " AND " & _ "IsNull (TimeOut)" Me.Text8 = Null End If End Sub

I am at a loss in my code and need help identifying where I am going wrong. Basically, I am working between two forms (main and time clock). The employee puts their EmployeeID (Primary) in Text8 Text field on the main form which opens to the associated record in the time clock form. When the...

There’s not enough context to understand whether or not MS access is the proper solution. If you decide to invest time in learning and developing, you will also save a lot of time through automation. If WiFi access is an issue and IT approves you can order a Mobile hotspot device.

Maybe get a TOUGHBOOK for the auditor / person collecting data. The data collected on the toughbook can be exported or shared on a main desktop DB via bluetooth. The file can be imported to the main computer DB so both are synced. I work in quality manufacturing and this was a good solution to...

Self identifying ones ethnicity is acceptable apparently. Some whites are identifying as black and getting melatonin treatment to match their inner identity. Search Nuka Zeus as an example.

Do you have attachments in your database? This would also impact the speed by bloating your database.

The pandemic has definitely created an aversion to living the big city life. I’ve lost the desire to even visit a large city. Where folks are in constant contact with each other in crowded spaces like buildings, public transport, and parks. I am sure the pandemic will change the way urban...

@arnelgp after trial and error I got the function to work. The after update event wouldn’t fire because of a calculated field. Thank you for your help! This really improved the db

value*

Thank you for the help and the functions in the demo make the form behave the way I want it too. The problem now is I am getting an error message “can’t assign a clue to this object”.