Search results

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...

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

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...

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?

I am puzzled on what database to trust? Is it the FE database or the BE database that needs to be created a trusted location?

Guys thanks for helping me out with your inputs on my other post. Can you help me again on this one. I have this code researched that will add vba reference. code: Function FixUpRefs() Dim loRef As Access.Reference Dim intCount As Integer Dim intX As Integer Dim blnBroke As...

I am using filelen, LOF and FileSystemObject to get the size of the access database. They get similar result however, for example my database in the windows explorer says 4864 kb, the function will give result as 4,980,736 which is 4981 kb. There is the difference of 117. What is the right...

Good day guys, Does anybody know what is the difference between Access 2007 and 2010 in terms of password security?

Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim ws As DAO.Workspace Dim rst As DAO.Recordset Set ws = DBEngine.Workspaces(0) Set db = ws.OpenDatabase(CurrentProject.Path & "\container\config.accdb", False, False, "MS Access;PWD=""") Set rst =...

Hello guys, I am asking again for your help on my problem. I have this subform which is on continousformview. On one combobox, you are to input ItemID. One ItemID is related to one AccountingID. If I have 5 itemid in the subform, when I click the Journal Button, it would suppose to lookup the...

What perhaps could be the possible after sales services, support or product can be done or offered when a program is sold?

Hi everybody, I have this code to determine if the table or query object is open and close it if open status: CODE: Option Compare Database Public globalobjstate As Boolean ' booleans are initialized to false Public Function objstate(Optional objname As Variant, Optional objtype As...

Good day everybody. I would like to restate my previous question/post. I don't want the users to have access to the objects window? (the list of all the tables, queries, forms etc) especially to tables and queries. How could I possibly do that using VBA?

Thank God I found a forum such as this, I never thought there would exist a forum like this. Good day everybody, I am not new to access programming but I have questions regarding it. Please help me out here guys. Basically I am looking if there is such a code that will only allow users to...