I have been using Application.GetOpenFilename and it has been working fine,
but for some reason it does work anymore.... The error I get is 'method or
data member not found'.
Can anyone help me?

I am working on updates to a training registration system. Once a day, client
wants to send out confirmation e-mail messages (Outlook 2003) to each
employee that was registered for a class. Message would include details of
the training course. Additionally, they also want the ...

I've used forms/subforms, but never by coding ADO connections and the
associated SQL. Is there a source for some code examples on how to do this?

In an effort to provide more accurate metrics on work production, I am trying
to create and integrate a production database (which will show production on
several different areas for different production types).  At the moment I
have some dummy data in a single table so that I ...

I have an adp project connected to a SQL Server 2005 database.
I have been trying to execute a very simple stored procedure that simply
clears two tables:
  DELETE FROM tbl1

I have several databases that perform updates on excel files or another
databases. The problem is that some colleagues of mine, leave the
files/databases opened when they leave work.
Is there any way to check if the file/database is opened by someone else and

How can one automatically set the field descriptions of a table in an Access
2003 .mdb database?
Simple enough question, right?

I have run into a problem trying to set a report recordset from a form.  
Basically, you can select multiple items into a listbox which builds a query
string:
select * from vwData where Thing='List1' or Thing='List2' or Thing='List3'

Is there a way to pause my module and then resume (as part of the
subroutine itself)?
I want to stop the code and get the user's input via a combo list box
on a form, then resume the code where it left off once the user clicks

Im having difficulty ending an excel process, when everything is run, the
process is still running in task manager. I think its got something to do
with me adding charts in my code as it ends the process before this point.
Can anyone help

I created a form to function as a filter to run a report.  One of the
criteria is a yes/no check box.  I don't know how to write a if/then
statement like a text box below.
If Not IsNull(Me.txtBox) Then

I need to rename a .dat file to a .csv file so I can work with it in Access
2003. The following code does not work... any ideas what I should do?
Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Function ChangeFile()

I have designed a pretty nifty form which has a subform embedded within it.  
In taking the advice suggested on this forum and others, I have handwritten
the vba that drives the parent form and need to pass the value of the
Openargs parameter used to load the parent form to do the ...

Is it possible to manipulate ms access name. for example after opening access
the name title is "Microsoft Access". how can i change it to "My Own Tile"
Thanks
Ernie

I am trying to create a field that will automatically calculate the date 6
months in advance of another date.  I have used two methods and neither seem
to be working forme.  
=DateSerial(year([StartDate]), month([StartDate])+6, day([StartDate]))