Top "Ms-access" questions

Microsoft Access, also known as Microsoft Office Access, is an application development and database development tool from Microsoft.

How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into …

sql ms-access
How to SUM two fields within an SQL query

I need to get the total of two fields which are within the same row and input that number in …

sql ms-access
Code to loop through all records in MS Access

I need a code to loop through all the records in a table so I can extract some data. In …

ms-access vba
Get length of array?

I'm trying to get the length of an array, yet I keep getting this error: Object required Am I doing …

excel vba ms-access
Microsoft.ACE.OLEDB.12.0 provider is not registered

I have a Visual Studio 2008 solution with two projects (a Word-Template project and a VB.Net console application for testing). …

visual-studio ms-access ado.net oledb
How to add default signature in Outlook

I am writing a VBA script in Access that creates and auto-populates a few dozen emails. It's been smooth coding …

vba ms-access outlook
delete all from table

what's faster? DELETE FROM table_name; or DELETE FROM table_name where 1=1; why? does truncate table work in access?

sql mysql ms-access optimization performance
Access VBA | How to replace parts of a string with another string

I am trying to create a piece of code that replaces one word with another. Example: Replace Avenue with Ave …

ms-access vba
Now() function with time trim

So the function =Now()....is there a way I can use this and only get the date, not the time? …

ms-access ms-access-2007 vba ms-access-2003
How to I say Is Not Null in VBA

Hi I have the following expression. I'm trying to say "if the second field Is Not Null". Can you help. …

ms-access null vba