I have a problem with some basic queries that work ok on Windows 98 but not
Windows XP.  Simple functions like DatePart and Date() just are not being
recognised on the XP machine.  I am running Access 97. Any ideas?

hello, I am a newbie and I really know nothing about access.
I use access 2003 and I need to know how to minimize and then maximize a
form when another form is open.
Thanks for all the help you can give me

I am creating a new database and am doing a simple TransferText Macro to
import an Excel file.  I can import that file manually via File - Get
External Data - Import.  But when I try to do it through the macro I created,
I get the error:

I have a module that contains a function that asks for the user to enter a
text string.  This string is then assigned to a variable called 'block'.  
What I am trying to do is get this string to appear in the subject line of
the email message but don't seem to have any luck with ...

Although I can get by with SQL, I'm new to Access Macros. I want to
incorporate two macros onto a form, as follows:
[1] A macro to cut the first 11 characters from a given field in the
current record, and paste the first 10 of these into another field.

Hello all...
I have created a prorate calculator of sort that will prorate someones rent
on a 30 day basis. I need the the "calculator" to prorate based on two dates
([Prorate Period From] & [Prorate Period To]). Users will input a rent amount

I  have created a macro to open several queries in order to calculate a
complex set of operations.
The first macro command is to open a select query which selects all seller
records for a particular event.  This query then sums the quantity for each

I have an account cancellations db (access 2002) for the company. I need to
have certain fields of the dB required (not left blank). However, these
fields should only be required to be filled in when a status field is changed
to "closed" from the drop down box. Status field has ...

I want to make a macro that when it runs it exports a query into an excel
worksheet.  I have working but i want it to name it vacation( and the current
date) i tried vacaton_Date( ).xls,  but it names it exactly that.  Is there a
way to name it with the system date attached?  ...

I just converted my computer to 2003 and the macro that automatically emails
my reports out every night is now not running.  It is giving me a message:
"Program is trying to automatically send email on your behalf."  With the
options yes or no.  I tried to research on Microsofts ...

Need help again
Can an access database read information from an external source?
if I have a temp. or weigh indicator that sends information thur. the
com port, can an access form read the information and save to a table

Can anyone please help me?
Is it possible to create a table with several fields by means of code? Also
is it possible to delete a table by means of code (VBA).
Thanks.

What is the VBA code for this:
VariableName = Select Table1.Field2 From Table1 Where Table1.Field1 =
"TextValue"
I would like to set the VariableName to the value of field2 where field1 is

Hi, I am new to MS access, currently creating a database.  I have created a
form and you can search for recods on that form.  I have seen a lot of people
using the mouse wheel on access, and accidently they go through different
records and change them without any knowledge of it. ...

I'm trying to pull information from 2 tables and summarise it into one table.
I've tried a query linking the common feild, however, only the common records
appear in the new table. Is it possible to use a queery or a Macro to pull
the information from two tables together which ...