Hi, I wish to run the following query in VBA and get the its value into a
variable:
SELECT Count(TBL_Students.students) AS CountOfStudents
FROM TBL_Students;

I have a main form (Exhibitors) and subform (ExhibitorsBooths) when I add
a booth for an exhibitor that is going to the current show I get the
following error
"Syntax Error or Access Violation"  The booth DOES get added and the column

I have an input box which queries users on how they want to display some
information.  A datasheet on screen, or printed report.  My code expects the
user to press "D" or "P".   Anything else is ignored.  The inputbox has OK
and Cancel buttons, I assume by default.  My problem is ...

I have created a function (Function is below) that can open multiple
instances of the same form and this function is working fine. I created this
new collection to hold the forms:
Public mcolFormInstances As New Collection

I have code that loops through the querydefs collection to delete each
querydef. The problem seems to be that it deletes every other one, as if a
pointer gets thrown off with each deletion. Suggestions?

Access03/WinXP
On a form there is a Start Date and End Date, both form fields formatted as
Short Date.  In the query, the field DatePaid has criteria >=
forms!frmPaymentsSummary.txtStartDate AND <=

I try to change the backcolor of a subForm details section ,hesder and footer
from the main Form.
I tried this but recieved an error:
"F_problem_open_subform" name of the sub form.

               Am working on a project which as the following VB.NET code:
Sub OpenAccess()
Dim oAccess As Access.Application
     dbPath = txtPath.Text

I used vb to pull meeting details from an access table and send a meeting
request to some people. Problem is, now I need to add several people to these
meetings. I've linked my outlook calendar to my access database and am hoping
there's a way for me to loop through the meetings ...

From a table with data in the following format:
Name          Data
CB1             xxx
CB2             yyy

I tried the following code (which I got from a previous post).  It works,
however I was curious where it should be called from.  I have tried the
OnOpen; OnLoad; Autoexec Macro.  I wanted to display a message to the current
user if file was locked or not.

Is there a way to increase the size of a a MS Access database column by using
the ALTER TABLE SQL statement?  I need to programatically increase the size
of a text column by executing a SQL statement.  If not, does anyone have any
suggestions on doing this?  I could add a new ...

Dear all,
I have a snippet of code which keeps falling over on the Auto Open macro
part - can someone pls help?  (I've cut out the non-relevant stuff below).  n
is an integer which just loops through an array of workbooks.

Does anyone know how to make a copy of a table with a primary key(Temp1).  
I've use the following code and this does not copy the primary key to the new
table(Temp2).
DoCmd.CopyObject "Temp2", acTable, "Temp1"

I have an application that is running on several different machines. On one
of them, whenever a report is viewed it appears as it would when you click on
a report to make it smaller. As a result you always have to click on the
report after it is displayed to enlarge it. I ...