I am having trouble automating the import of a fixed width txt file.  I have
tried the schema.ini file but  access did not let me put it in the
specification name box.  Any help would be great.

To create a weekly report I use:
"items" - this value changes every week
"Cost of item" - this value changes 2-3 times a year
"week No" - needed to create the weekly report based on "items" and "Cost

I'm working on the finishing touches of my Access project and want the user
to be able to search the database with the use of a simple single field form
and than have the results presented in another more detailed form with many
more fields with all the details. Right now, I only ...

how do I set up macro in access to run a query at a specific time everyday?

I generate a UserFrom in VisualBasic Editor and want to use it in Excel file.
How can I do it?

This is probably too simple a question but I seriously haven't been able to
find an answer in forums or MSDN.
I've created a macro in Access which uses TransferText to import a text
datafile, and also alters the data using a set of specifications. I want to

Our Access database at work was developed before I got there. There is a
button on a form that prints the contents of the form that is currently
displayed. New employees made some changes to the intranet/server, but
didn't make any changes specifically to this particular database we ...

If in a form, there is a date field, and I would like the user to type "t"
and  today's date will populate or a "y" and yesterday's date will
populate-can i do this just using a macro? If so, what commands should I use?
If not, what do you recommend?

I have a macro that will send out a number of emails with attachements using
the sendobject action. The problem is that after three emails have been sent
it seems to bypass the remaining emails. I have stepped through the macro and
everything seems fine. Is there some limit to ...

I have a macro with conditions that vary the action depending on the number
of records in a subform.
Using a =Count([FieldName]) formula in the Subform field I have got this to
work but running the macro "on current" in the form, runs it before

A colleague was programming our Access database before I was asked to make a
few changes on it because we changed PCs.  On loading, it tries to locate
the .mdb & graphic files on a particular drive - \\mdb-filesrv\goodguys.
"mdb-filesrv" was the network name of the former PC which ...

I am writing a macro that will create tables using information from a remote
ODBC database. I am using the TransferDatabase method.  To set this up to
work, you need to enter arguments for the ODBC link name, server name.
database name, password and login. I can hardcode these ...

How do I test a Yes/No field in a Macro?
If I type:  [fieldname] = "Yes"    in the condition field, I get a type
mismatch.

We have a battery of queries that generate some calculations and do some
quality control on data; they are too complex to run as a single query, and
we've moved to a situation where we run a cluster of make-table queries via a
macro to do the calcs and QC, and then we build and ...

Using Access 2000 - trying to export table from one database to another with
a macro. From: r:\shared\revenue.mdb (table name is revenue) to
c:\company\revenue.mdb
Macro looks like it is working, however after a while task manager shows