Recent content by Olav

Sorry for digging up old threads, but I had some problems with this function too. However, I found out that the reason why Access crashed was that the spreadsheet was locked by another application. I found this link: http://support.microsoft.com/kb/209189 and wrapped the...

BUMP - Still not solved. The Sendkeys action seems to fail on users with multicore processors. I do not know if this is the reason for the function to fail. I only need help with vba code to replace the sendkeys function. Scenario: One user running multiple instances of Access 2007 User...

I believe the program collects the username and password before checking if they are correct. This way, the program is unable to know if the username has a password or not. I believe the program has a user database, and asks you to enter username and password, and checks to see if there exist...

Hi David, SQL servers are secure servers. This means that you need a username and password to log in. Try to log in with the username root and no password. If you are using this server on a network, you should set a password, and create more users. For details, see...

Hi David, I once was adviced to KISS (Keep It Simple Stupid). The way I create my Access applications is to create many querys, and use macros as far as possible. And only use VBA where macros cannot do the job. This makes it much more simple to fix errors on an Access app that is a few years...

Hi ddskorupski, I would create a Update query that tests if the date is approved, either by checking the approval signature, or better, adding a Yes/no field. See the SQL code below: UPDATE table SET table.date1 = table.date2, table.date3 = table.date4 WHERE ((table.Approved) Is Not Null)...

My favourite tutorial site is w3schools. (I am a new user, so I cannot post the link, just add com to the name.) This is mainly a web-programmers tutorial site, but the SQL-"classroom" is relevant to access also. This site provides a nice step-by-step approach with a comfortable learning curve...

Yes, this works for some users, but not all. when I use the the command sendkeys "^(o)U:\app\startup.mdb%(o)", some computers stops after "^(o)" and ignores the rest. ^(o) = Ctrl + o, %(o) = Alt + o Does there exist a function that will do the same as the key sequence: Ctrl + o (open file...

Hi, I have a system based on 25 different mdb databases where most of the data is located on a SQL server. The main database is a protected database with a login dialog. After the login dialog, the user is asked to select a sub-system. Each sub system is a stand-alone database, some are...