I have a table with one record which includes 2 fields--a  year (1999) and a
total number of years (any single number greater than 2)  I want to add lines
to the table where the year increases by one and the total number of years
decreases by one, and I want the number of lines ...

I keep getting an error message at the indicated at the line below:
The error message says: "Object Required"
and is located at the line of code below.
-----

I am trying to get this working from within Access VBA:
Public Function PowerpointWEBoutput()
   Dim ppApp As PowerPoint.Application
   Dim ppPres As PowerPoint.Presentation

I have a mail message coded in access but I need to setup the message send
options similar to what I have
 Dim strEmailMessage As String
   Dim strCC As String

I've got a script that pulls all the records of employees who haven't logged
into the database in the last 90 days and then sends them a reminder email.  
The script is linked to a button on my switchboard that I have to click.
Is there a way to create some sort of ODBC connection ...

Hi, I have a main form (Media) linked to a subform (Media subform) through a
MediaID primary key.
Both forms record source is tblMedia which has a recursive relationship.
The subform is set as a continuous form, and each row has a command button

I'm working on comparing a number that is being calcualting (vbCaseNumber)
with the last number in a table Attendees. If the numbers match, it should
increment by 1.
I'm using DLast but not sure if it's giving the desired result since it's

i recently purchased "sql demystified" to start familiarizing myself with
sql... www.osborne.com has a  sample database available for download for use
with the book, however it is simply a text file with all of the sql to create
the database.  how do you go about running the ...

On a form that is tied to a table, the user changes a field called "status".  
When that field is changed, a few related records in the same table also need
to change.  In the AfterUpdate event, I inserted a procedure that created a
recordset on the table which found the related ...

My app has Access 2003 for the FE and SQL 2005 for the backend.  I am trying
to run the following update query from Access.
"UPDATE tblSources SET ImportID = 1, LastUpdate = #" & Now() & "# WHERE ID =
1"

I am trying to parse a text file into recordsets and then into access tables.
The text file is a file rescued from a crashed proprietary database program
and may contain corruptions.  It does contain many empty fields between
delimiters.  However, it is quite large and until I ...

Using ACC2003 and exporting a query as a xml file. When I do this, the file
looks like this:
--------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>

Hi what code do I write when I want a macro or code should run when I
maximize my access database?

I can't seem to get this figured out:  All I need is to save a text file that
is created by my code, and I would like to give the user the dialogbox that
pops up and lets them choose a folder.  My code then knows what path they
chose, and saves the text file there.  My text file ...

I have a problem getting orderby to sort on a column's string text and not
the underlying Primary key.  I did the following:  1) Took the standard
Northwinds database and created a form called sortTest using a datasheet form
and the entire Orders Table.   2) after defining an ...