Search results

One last question, is there a record timestamp on the SQL imported actions?

So let's say intCountedNames contains the number of counted names and that you created an array to store the inStr locations of the names and called it NameLocation. (Don't forget to remove the semicolons when done using the Replace function) The array would look something like...

Do the names coming from the SQL Server exactly match the names in your tblEmployees with zero duplicates?

It always good to break down the problem. First, you'd have to define what you exactly mean by perfect attendance. Is that 9 hours/day x 5 days x 4 weeks = 180 hours/month? If it's that simple, then you can sum the attended hours and compare it with 180. If you want to account for public...

You'd have to start off by counting the names by basically counting the number of semicolons in that column. Once done, you will repeat the (INSERT INTO) SQL statement based on the number of names you counted using a simple For..Next loop.

First, it wouldn't hurt to have a one-many relationship between tblEmployee and tblActions with EmployeeID being the connection. Then, you can use SQL's INSERT INTO (Currentdb.execute method) everytime you want to record an action.

You can have a Scheduled Task in windows to open your access DB every month. Once your DB opens, you can have it run a certain query/module depending on your exact needs.

Can you give us a bigger picture of what you're trying to do? Involving windows APIs is not the easiest thing to work with.

Yeah it would be a lot easier to store the values in a table and look them up using the life saving dlookup() function.

He's referring to the folder which the DB is stored in. Right click on the folder and view permissions. Has nothing to do with access.

You can change the control source of that textbox to something like =[forms]![myform]![MyPassedValue] I'm assuming that value is copied straight from a form? Or did I misunderstand?

Bienvenue Jacques! You will definitely find this forum very helpful. I know I do.

Funny you mention that, I am currently developing a DB solution for a beauty salon. They're still doing things like my grandfather did in his grocery store back in the 50's: super large book (they must have a name for them) and a drawer with crumbled bank notes. Share that .exe perhaps we can...

I don't see any changes to be honest, did you re-upload the same file :p

Haha thanks, that would save me a few hours of stress and a few beers :p

I am very impressed! There's a lot to learn from the file you posted, I've never worked with class modules before so this should get interesting. And yes, it worked like a charm :) Just need to apply that to a color chooser now

Thank you I'm not interested in using ActiveX controls as I plan on distributing my database to very non IT-savvy people, last thing I want to deal with is missing controls or installation files.

Any help would be appreciated

Sorry for not getting back to you earlier, it's a dialog box (color chooser) from the MS Common Dialog

Share the knowledge mate :)