Recent content by darnelleF

so i should but a labels on the form which will have the start date and end date cause im looking for something like [datefield] between 2017/02/02 12:00:00 AM and 2017/02/02 4:45:56 PM and each day it updates itself

So i am trying to write a function that will get the number of records between todays date and now, but its been failing Dim dbs As DAO.Database Dim rstBlock As DAO.Recordset Set dbs = CurrentDb Set rstBlock = dbs.OpenRecordset("select * from Customers where " & _ "AddedBy...

awesome i was now able to pin point the error! ODBC Error 1062 [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]Duplicate entry '\\******\****\******\****\289\0421B289_526-2015.pdf' for key 'indPath' the table its trying to update has a column called Path ( not indPath) i had to censor the...

now i'm relatively new to this access and vba but i got a spectacular error vba 3146. let me tell you the basics | THERE ARE FOUR MACHINES CONNECTED TO THE SERVER VIA FILE DSN four users enter information via access 2007 to a MYSQL DATABASE out of these four users, one user cant use one form...