Top "Ms-access" questions

Is there an equivalent to Thread.Sleep() in VBA

Is there an equivalent to Thread.Sleep() in Access VBA?

vba ms-access sleep

How to disable access security notice "A Potential security concern has been identified"

i have a shared access application, i created an accde file for 32-bit machine, when user open the application he/…

vba security ms-access ms-access-2010 ms-access-2007

Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect

I'm trying to connect various VBA projects to an Oracle 10g back end using ADO (2.8) and no TNS. After various …

excel vba oracle ms-access ado

Textbox null problem

I have a textbox and a button on my Access form. In the click event of the button i want …

ms-access vba

How to access values in a recordset

Take for example this code: sSQL = "select CtyMarket from Market where Country = '" & Country.Value & "'" Set rec = …

ms-access recordset

How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access

I use the following code in Python (with pyodbc for a MS-Access base). cursor.execute("select a from tbl where …

python sql ms-access pyodbc

Access-SQL: Inner Join with multiple tables

i have multiple tables in a database: tblOjt ID studentid courseid companyid addresseeid dateadded datestarted dateended ojthours 1 3 1 1 1 9/25/2013 500 tblStudent ID lastname …

sql ms-access vb6 ado

How do I write a full outer join query in access

Original query: SELECT * FROM AA FULL OUTERJOIN BB on (AA.C_ID = BB.C_ID); How do I convert the …

sql ms-access

SQL multiple join statement

When I had only one inner join in my SQL statement, it worked perfectly. I tried joining a second table, …

sql ms-access

How to populate a ComboBox with a Recordset using VBA

There is some literature available at expert's exchange and at teck republic about using the combobox.recordset property to populate …

ms-access vba combobox adodb recordset