Search results

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”.

I have a form with 6 fields where the user logs the weight of 6 bags (bag 1, bag 2, etc). I have another field that calculates the average weight once the bag weights are entered. I want access to highlight the bag closet to the value in the average weight field. This will help the user identify...

Thank you for the replies. Very helpful tips. The one to one relationship was not appropriate for this scenario for sure. Thank you for highlighting this :p I found the issue. I was missing the SetValue macro Item = [Forms]![Samplefrm]![SampleID] Expression = [SampleID] Again, thank you for...

I need help on something that is beyond my Ms access knowledge. I have two tables; one is a Sampletbl and the other is a Test Resultstbl. The tables are one-to-one via SampleID. When I am on my Sample Form, I would like to click a button that moves me to my Test Results form to enter the results...

Arnelgp, this worked great thank you. TheDBguy, you were right in that it does not work in a calculated field. I had to put it in a OnClick event in a save button. This did the trick. Thanks y'all

Hello I need help. I have a drop-down field[SUB size] on my form that shows different size bags (Small, Medium, Large). I test these bags to determine the force before they rip. The larger the bag the larger the force before it rips. I have a calculated field [average pull strength] that...