I have an Access table that is linked to an external text file (customer
sends me this each week)
I then do a MakeTable Query to another database that is then published to
the web and used by a FrontPage DBWizard page.

Thanks for everyones help on the first question I had yesterday with RWOP
Queries and setting all my current ones to the right property through VBA
code.  It worked great.  The second question which I guess I didn't really
explain correctly was is there a way to make sql ...

In XP I want to make a copy of a record, in DAO, with a new Autonumber key.
I know how to do this on a field by field basis, but wonder if there is any
way to just copy the entire record without doing field by field. This is a
lot of fields, and I also need to do it for a bunch of ...

As part of a data import process, I must, from within VBA in my Access
application:
1. Poll an FTP site periodically (Form_Timer probably) for existence of a
tag file in a remote FTP folder (its existence will indicate that a couple of

I linked up two tables - one is students fees table and another one is
receipts table. I want to update the student ID fees by entering fees
collected. I have taken the fields -  receipt id, date, stu.id, stu.name,
amt.paid, bal.amount, tot.amount (stu.id being the foreign key in ...

       From a word macro in VBA, I am trying to create a report in
access DB. The report is based on a query with a parameter.  I am using
Set rpt = Application.CreateReport
rpt.RecordSource = <<Query_Name>>

Could use some help on this one...
Have a fairly large, previously working Access 2K database running on XP Pro
machine.  Recently made minor change to one of the forms, added two named
queries, and added three new fields to two tables.  Afterward, when I run one

How do I create a check box on my data access page that will hide a reord if
checked? I dont want the record to be deleted but I dont want the record to
show on my page.

Using Access2003.  I have data sets with a 6 digit string embedded as such:
ACME INC 290452 447-DOE, JANE
WIDGETS CO & SONS 262378 897-SMITH, JOHN
etc etc

I am running a VBA subroutine in a database which executes a series of
queries in a loop.  After a time, the db size becomes a bit unwieldy.  I am
trying to use Tsisoon90 to programmically compact the database when it hits a
size limit and then relaunch the data base with a ...

Have a table of landowners, could be 2, could be 6. Report text box needs to
recognize number of landowners and put an "and" between only 2 owners, or
commas between the 1st, 2nd, 3rd, then an "and" before the last name.  I've
been trying to write expressions for this.  Tried a ...

When using the on mouse move event, is it possible ti return the name of the
object the mouse is over??
Many Thanks in advance
Gary

Can anyone help to get this function to run.
Input day comes from a Qureie and has format Short Date (2006-01-27).
The field [Date] islinked from an exceltable and has same format.
The function runs correct in this case: =DayNo(Date())

I am working on implementing security into a database that is going to go
from a single user to a shared system and I going through the process of
setting up the security correctly (using the FAQ as my quide).  From what I
have read about securing the tables properly I need to ...

Is it possible to capture the end of a "docmd.transferdatabase import ...."
action?
Thanks.
Luis