I need to set the data type of a field in a Access 2000 Table directly form
VB code, in order to make it automatic when i run a macro.
The table is created from a query and a field is Numeric and i need it to be
text (8 characters) in order to make a link to another table.

I need my databases to generate a reminder email automatically, based on
date. The program that I would be sending the email to would be MSOutlook. Is
there a way to do this?

I have converted from access97 to 2003, and received this error.
What is it telling me.

Can anyone help me with setting a recordset in a subform?
I've this code where i use the connection method to connect to a sql server
database. I can use it to set the recordset in a form and a subform, but
when i go the next record in the main form the subform's recordset stays the

//i use the following code on a module to create a 'replace' function:
Function Replace(ByVal Valuein As String, ByVal WhatToReplace As _
                      String, ByVal Replacevalue As String) As String
        Dim Temp as String, P As Long

I have designed a Parent form called Daily Dispatch Log.  However I rarely
enter vehicle information so I wanted to use a command button to open a
subform to enter vehicle information when I need to.  The subform opens to
record 1 instead of the current record that the parent is ...

I am new to this board. I have been searching around for an answer but,
didn't find one. I greatly appreciate for any help.
I don't know what have changed my access, I cannot debug my VB code any
more. I cannot step into vb code, watch, step over, even I set a breakpoint

I have a query that compares the OrderDate field from tables Temp and
Quantity.  If they are the same, then I want to update the Qty field from
Temp table to Quantity table.  
The problem is: I am getting a syntax error on referencing the two fields

may you please I think that it is not fair that taechers can and kids can't.

What is more efficient to use for performing more complex calculations SQL
(queries) or VBA (recordsets)?  We are automating a spreadsheet process for a
client in Access.  Our consultant has built a series of calculations using
queries that basically build onto each other.  Our ...

I am having a prblem with this script. the itemselected returns what appears
to me t
as the position of the item in the listbox i.e. 1,2,3 opposed to the values
i need although the display correctly in the listbox.

Is there any way to get the individaual steps of an access macro from code
using the Script container object? If not, is there any other way to do it?
I'm writing a program in VB6 to loop through all *.MDB files in a specified
directory and determine what buttons on what forms ...

I have the following code. The YesNo messagebox is on top of the open querry.
My problem is: I want to check the querry before I decide on Yes or No.
In this code, the querry is displayed in part and I have to make a decsion
before I can review the transactions.

I’m trying to have the last selected item from a combo box be the default
value for the next new record.  
I have the AfterUpdate event routine for the combo box assign the selected
combo item to the default value.  The default value is updated, and new

I've designed an updating application to deliver object updates to clients
using my databases. The application gets launched it does the following:
Verifies file locations
Verifies version numbers