Top "Ms-access-2007" questions

Microsoft Access 2007 - a rapid database application development tool

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
A select query selecting a select statement

I don't even know if I am doing this query the right way. There is a Sandwiches table that has …

sql ms-access select ms-access-2007
Determine whether a Access checkbox is checked or not

Such a simple question, but I cannot find the answer (Google, MS help, SO): How can I check by VBA …

ms-access ms-access-2007
How to refer to Excel objects in Access VBA?

What declarations I have to make in order to be able to use Excel objects and constants from my Access 2007 …

vba ms-access-2007
How do I correctly use "Not Equal" in MS Access?

Objective: The intent of this query is to select all of the distinct values in one column that don't exist …

sql ms-access ms-access-2007
Import an Excel worksheet into Access using VBA

I am attempting to import an Excel spreadsheet into Access using some simple VBA code. The issue I have run …

ms-access vba ms-access-2007
Retrieve column values of the selected row of a multicolumn Access listbox

How can I retrieve the value of specified column of the selected row in a multicolumn listbox? I populate the …

ms-access ms-access-2007 vba
C# Inserting Data from a form into an access Database

I started learning about C# and have become stuck with inserting information from textboxes into an Access database when a …

c# database winforms ms-access-2007
Use SELECT inside an UPDATE query

How can I UPDATE a field of a table with the result of a SELECT query in Microsoft Access 2007. Here's …

sql ms-access-2007 sql-update
The action or event has been blocked by Disabled Mode

I am using Microsoft Access 2007 to move and massage some data between two SQL Servers. Yesterday everything was working correctly, …

ms-access ms-access-2007