Recent content by AccessProgram

This is actually not a project but only as a desktop security of my computer. You are right banana, any user can unplug the computer but I have my the application run first before logging in the computer. This is aside from the login procedure of windows. Anyway, I have found a way that will...

what is the right vbkey for ALT ?

Thanks but I really needed that somehow done with keydown event. What could be the vbkey for ALT in the keyboard?

ok. but regardless where I am going to use it, may I know what should be the keycode that will disable ctrl+alt+delete and alt+tab?

I want to know how to do it on the entire form and on a text box also.

I have found the code below to disable some keys. Is there a combination of keycode that will disable ctrl+alt+delete and alt+tab? Code: Public Function DisableKeys(KeyCode As Integer) Select Case KeyCode Case vbKeyF1 'F1 Key KeyCode = 0 'Makes it so that if user...

assistance for above please!

To connect to mysql server, first I will create a DNS thru vba, second use below connection string *To connect to a local database (using MySQL ODBC 3.51 Driver) oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _ "Server=myServerName;" & _ "Port=3306;" & _...

That was very helpful. I have a follow up question, how can I now link the tables from mysql to Access after having created a connection?

Good day to all. I want to ask how can I connect Access to Mysql Server using VBA. Thanks!

I have no idea on this. I was also thinking about recordsets but I dont know how to construct it. Can you give me an example how to use the recordset for my purpose stated above wherein I use one query as record source for another query?

I created a query statement in a module. How can use that query as a record source of another query in the same module? Should I use this like: dim a,b as querydef a=select * from tablename; b=select * from a;

I just gone through reading this past week and tried something on the command-line client of MySQL. Somehow I learned using the command-line client in doing some of DDL, some of DML. I also learned how to create .sql file for the backup file and restore. My questions are, can I do a backup...

Any assistance here guys?

Hello guys, On the course of my self-study, how does mysql do synchronization of database or tables? What should be the command for it? :) I intended to update the mysql database from one computer to another. What should I use, replication or synchronization? Whats the difference?