I can't seem to get the Syntax right on IF, ELSE , End If.   HELP........
Command Button 'Finished'
If frmUpdateAcctList.Desc Is <> "" Then
MsgBox "The Account List is Updated"

I have a query that counts the number of items in a table.  On a form I have
a txtbox to display that number.  In the Control Source of the txtbox I have
the following code:  =qryOffSitesActive!NumberOfOffSitesActive.  I get the
#name.  What am I missing??

I have a data input form that I would like to have the end users print for a
quick and dirty copy. I can have them go to print and select current
record(s) but would much rather have them be able to just press a button. I
know how to create a report to print the information but ...

This code works ok, but I need to filter it down to the user who opens this
form up.  Just where do run the filter or........
Option Compare Database ' SYSTEM ENTRY FORM MODULE
Dim db As Database

I'm working with an Access project and I'm trying to have a combo box that
will allow you to go to a record by selecting it from the box. I keep getting
this error:
Run-time error '438':

I need to code something in response to File -> Exit in a custom menubar I
created.  Where and how do I go about doing this?
Any help will be greatly appreciated!

I have a subform (frmProducts) on a form (frmFollow). On frmProducts, there
is an option group called Frame289 (at the moment).
Based on the selection in this group, is it possible to disable the
remainder of frmProducts or all the other controls?

I'm looking for a similar thing to those counters you get on web pages,
showing the number of times a page has been accessed. I want this to be
displayed on the form that displays at startup each time the access database
in question is opened.

The table <name> is already opened exclusively by another user, or it is
already open through the user interface and cannot be manipulated
programmatically. (Error 3008)
table is not already opened exclusively

I have a form based on a table(Products). One of the fields in that table is
a lookup field that looks up an autonumber field from another table
(materials).The materials table contains a field called "specific gravity".
On the form for Products there is a button that when pushed ...

I have a main form and a subform.  The main form executes a parameter query
against a table that contains order number, name, office, date, and a primary
key.  The subform is bound to a table on a SQL server and has a parent child
link by primary key to the main form.  This ...

Hi Could anybody help me?
I am quite new to Access programming  and I was wondering if anybody could
tell me where I am going wrong?
I am currently trying to develop a database in Access and originally thought

Hello -
I have an application that uses a form and some buttons to open Microsoft
Excel. I am currently using functions from the Microsoft Excel 11.0 Object
Library.

Can anyone give me any pointers on how to get the clipboard working using
VBA for a FlexGrid?  I want to be able to copy things from a flexgrid and to
a flexgrid.
I can only find information on doing it in VB6 and nothing for VBA?

I have two forms in my database and one of them is causing me problems
as follows in parts of my code.  Easier with an example:-
If I run this:-
Debug.Print "type = " & TypeName(Form_View_Projects_Actions(2))