I'm using the following code to import data into a table.  It works fine at
the moment but I would like to alter it to be able to select from a 'File
Open' dialogue box.
Just to make it a little more challenging can it default to the location

On an Access Report, I would like two controls to be visible on the page
header section only if they appear on the first page.
While the If clause in the following statement is not triggered on the first
page, it is triggered on subsequent pages, but the control is rendered

I would like to print the just last page of a power point document using OLE
from
Access VBA Code.
I am able to print a complete document with:

I want to save a report with a name that changes based on the school name. In
the OutputTo method, I have tried setting the Outputfile name
"[Forms]![Dialog - EMail AD Report]![Selection]" & " AD Report.rtf" in hopes
of getting "Arts AD Report" or "Academy AD Report" where Arts ...

The form I would like to put in a database is 25 pages printed. It features
approximately 11 entities(locations, people, specialties, etc.). This means
that I want capability for an unlimited number of line items per entity for
each form.  I would then like to publish this to the ...

Hi -
We are using a database of appoximately 10 users with about 3000+ records.  
For some reason every now and then I'll get a corrupted record.  The record
pulls up with boxes and chinese looking characters.  I checked all the users

I am trying to calculate the end date (EndDate) in a report based on a case.  
The start date (StartDate) is in another field on the report.  I know (to the
best of my ability) how to add the number of days to the StartDate using the
"Select Case" function.  However, if the ...

Good Morning,
I am a novice when it comes to VBA.   I have made a couple of applications
using the same methods of using VBA.  I am now going back and trying to make
things quicker as well as trying to clean up my code.  

I have a query that has one field with multiple records.  I would like to
create a new query that has the record values in one record with multiple
fields.
For example, I want to go from:

I have a log file (Table1) from an alarm system which produces different
alarm outputs consisting of textstrings with embedded parameters, one record
per alarm. I need to identify each record type (there about 200 of these) by
identifying some significant text element and then, ...

I'm having a problem using the ExportPicture Method of the chart object.  I
get and Error 430.  What is very strange is that there is a Microsoft
Knowledge base article KB # 824276 which is related to this problem and in
the KB article there is extensive steps for an example.  ...

Forgive me if this has been covered somewhere else, or it it's well-known.
Basic had a construct for loops: for each, next, step where "step"  was an
optional increment to the loop's iteration counter.
Does such a construct exist in VBA, and if so, must "step" be an integer, or

A couple of quick questions on Linked databases :-
1. If the Front End of a split database contains a table linked to a Back
End database, is it possible to programmatically determine the name of the
Back End database from code in the Front End database?

Hello, I am trying to build a form based off of a table. I have tried a
couple of different methods for adding a control at runtime and none have
work so far. I have tried:
Dim ctr as TextBox

I have Access 2003. I want to create an mde. I load up the database that I
want to create an mde of. However, the option to create an mde file is faded
out. Please advise.