Search results

Hello, I am trying to use a dlookup to find information based on specific criteria but, every time I use it I receive an error "syntax error in date in query expression". however, I am not using any date format and I am confused as to why this is not working. Private Sub Quick_Look_Click()...

Hi I am trying to use an SQL statement to input data into another table but I constantly receive a "invalid procedure call or argument" I have tried several different things to attempt remedying the problem, but nothing seems to solve the issue. I assume that there is something that I am just...

Hello, I would like to make it so that if that last record inputted with the same ID was inputted within the past 5 minutes then it will not input the new record into the database. Im not sure how to code that time frame, but more importantly how to tell access to not do anything if the...

Hi I have been using the dlast function to look up the last record matching the inputted employee ID. I am trying to make it so that after looking up the last record access applies the opposite field to the [InOut] field however, it doesnt do anything and constantly applies a 0 (false) to the...

Hello, I am not sure how to do this. I have a database with a table with [Time IN] and [Time OUT] as two seperate fields along with other fields (Employee ID and Employee Name). I would like it so that if I input an Employee ID Access would search for the last record with the same Employee ID...

Hello, First of all, thank you for taking the time to look at my post. Anyway, I am currently an IT at a small animal shelter and while I do not know much about coding I am very willing to learn. Because no one else around the workplace knows how to work with access (aside from the end user...