n my function listed below i get compile error in the following line :
adb.OpenCurrentDatabase (strDbName,,strPassword)
can you help ?
Private Function KillObject(strDbName As String, acObjectType As Long,

I want to write a function looking into a query :
SELECT Customers.afid, orders1.customerid
FROM Customers INNER JOIN orders1 ON Customers.Customerid = orders1.
customerid;

Hi - Please help
I use Access 2000 mdb with VBA learning from the help files, I started a few
months ago for office applications located on a server.
All went well until multiple users updated the same "production" tables.

dear sir.
,
i would like to have in this way is this possible
dim exl as excel.application

My desktop has several shortcuts for secured Access databases.  The target
for one of them is:  "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"N:\Common\ACCT\branch analysis.mdb" /wrkgrp"N:\COMMON\FED.MDW"
That is for Access 2000.  I would like to use a universal ...

I have a form with a combo box (named Combo1) and a command button.  The
purpose of the form is to make a new table based on the combo box value after
clicking the command button.  Can someone help me with the proper syntax?
The recordset should look like:

Since switching to 2007 I am having no end of trouble with the running of my
code.  The latest is a piece designed to create an email.
Sub SendEmail(strExcelFile, strEmailAddress)
   Dim myItem As Outlook.MailItem

I've just migrated to 2007 and code that used to work is giving errors.  The
code is generic,
   Dim myItem As Outlook.MailItem
   Dim myRecipient As Outlook.Recipient

I've just upgraded to Access 2007 from 2003 version.  I have many, many
modules with balloons for the users to make choices which in most cases
populate variables.
In references I have chosen Microsoft Access and Office 12.0 Object

To refer to the value of a control on a form that does not have the focus I
can use the following code:  Me.ControlOnFormWithFocus =
Forms!frmPull!txtControl1
How can I use a variable in this line of code in place of txtControl1?  I've

I am new to VBA programming.  I think I am doing this right but keep getting
the below error when typing in my TransferSpreadsheet Command. I am trying to
write code so my query after being opened and run via form exports the
results into Excel.  My queries name is Subcycle Data ...

I wish to list the already defined Public Variables from VBA, just like I
list my existing tables. Is there a kind of "VariableDefs", like "TableDefs"
I could use ?
Thank you already for any help.

use of * caracter in rst.Open strSQL
try: strSQL = "SELECT * FROM QrycustomersReport WHERE [cuscompanyName] like
"*test*"
You can use the strSQL to change the recordsource of a form, returns all

I've got a command button that creates an outlook email.  I then use
fields from the form to fill in places in the subject and body of the
email.  I use so much space in the body of the email that the VBA code
tries to wrap and then it turns red and doesn't work.  Is there a way

I have a question that has been fraustrating me for some time. how do i force
users out of my database to perform maintenance? short of literally forcing
them out that is i'd like to be able to close the application so that i can
make updates etc. folks leave at the end of the ...