I have a MS access database into which I need to import a text file
that is oriented vertically (fields are listed from top to bottom with
the value for each field appearing to the right of the field name (with
a "|" as a delimiter)).  The text file will only have 1 record's data.

I have two forms A and B, both opened. In form A, I programmatically
change the Date of Birth field of the current record of form B. I
noticed that form B automatically displays the new data correctly.
However, when I tried trapping the After Update, On Dirty, On Change,

I have a button containing the VB command Me.Notes = Me.Notes &
Format(Date, "dd-mm-yyyy") to have a date filled in a field. I want it
automatically jump to the next field, after the date is inserted. How?
By the way, more nicer is that when I start a new record, the date is

I'm a fledgling developer and am just starting to get my app out to specific
clients.  
I have been asked to bid on a project because my app already does over 90% of
what the client wants.  My question is with regards to pricing of the

Below is a snippet I found and am trying to experiment
with. Unfortunately, there's a compile time error in A97
complaining that "Response" (in line #1) is an undefined
variable. I'm unsure what is intended, so I can go no further.

Hi,
This is probably very simple to do so if anyone can point me to the
right place for reading, it would be much appreciated.
I just want to build a very basic search form where i can enter a name

I'm facing a strange problem in access 2003 i dont know how to solve it
i have a code in VB which give an autonumber but in finanical new year
it reset to 1 on new year it works in one form but the same code doesnt
work in other form in run time it's going to skip if satatement of ...

I have a table used to enter the last date a project was updated.
When updating via a form, I need to compare the new date against the
last date in the record.  If the difference is greater than 14, I need
to display a message box alerting the user.  Secondly, they must then

Looking for a tool, or code that does the following.
Edit [partial field data] in TBL1, if [partial field data] meets criteria in
TBL2, COL1.  TBL2, COL2 has the REPLACE WITH information.
Not sure if this edited data can be written directly to the TBL1, or needs

It would be great if we could all suggest variations of this caluse
that we feel is reasonable to be included in the newsgroup FAQ.
Hopefully we can come up with a version that we all, including the
silent majority, feel leads to improving out collective experiences in

I am running an external application's script file, which is of the
extension ".avsauto" (Avaya application) . I want Access to run this
script file every half hour, so that the script can integrate with the
application to export data into excel sheets. When Access calls for

I'm really not sure how to go about this in Access. What I've created
is a table for each location. Those tables are identical in format but
different in information.
The tables are named after key points such as the store number and the

I'm trying to get the "Carry data over to new record"
code to work from Allen Browne's site:
http://allenbrowne.com/ser-24.html
I follwed the instruction explicitly and somethings not working... any

Is there some sort of formula that anyone knows of that it if provied
it was a date it will tell me was the date was a number of days before
it.
Ex.. Say i put in a 12/29/2005 as a starting point and I want to know

I am trying to learn how to develop using Access to front end a MS SQL
back database. I am new to this so please bear with me.
1. I have a lookup table for Saluation, where I hv an ID which for each
salution type and a cloumn to store the Salutation itself for example