I currently have a field named QuoteNumber in a table named Quotes.
The field is set as autonumber and is used to assign sequential numbers
as users enter information in the table through a form.  This number is
mainly used later as reference when a customer calls our office with

I have a table that I am appending 3 seperate tables into.  My main problem
is that each time I append the data, it simply adds to the data already there.
That might sound ok, except that if I append the data 3 times in succession,
it copies the same data over 3x.  Now I have copies ...

I'm writing you from Alajuela, Costa Rica.  It's 4:30 in the morning
here and I'm reaching a point of pure desperation as I've been
searching the internet all night for a solution.  I am not an access
wizard.  I just started looking at it actually because I'm trying to

I'm using Access 2003. I seem to have suddenly lost the ability to set
the Back Style property of tab controls to "Transparent." Or rather, I
can set the property value as "Transparent" but nothing happens; the
control looks the same as if the property were set to "Normal."

By default mdb etc files are not searched by Indexing Service.
The default can be changed in Windows XP Pro using Group Policy.
I can find no suggested way to make the change in the Windows XO Home.
I decided to try adding this Registry Key:

i am building a movie database in microsoft access.   I have a field
for actors last name and a field for actors first name as well as field
for actors fullname.   I want the full name field to automatically
populate with the information from the first name and last name fields.

Dear reader,
I can't repair this with Tools>>Database utilities>>Compact and repair
database....
And another way around:  after creating a new database and start import all

Hi, I have created a combo box with "", Yes,No  so that if user
select any other option except Yes the  text box should become
disabled. For this I have written code in the exit event of the combo
box it is working . But the problem is that, after reopening the form,

No, not a cross-post. I posted to the wrong group first up.
Hi all,
Using Len(Dir$(txtFileName)) to check if a file exists, can anyone
suggest an additional step to check the Read-Only status of the same

Can anyone point me to VB/VBA code that will control a TWAIN-compliant
scanner?

In:
http://groups.google.com/group/microsoft.public.access/msg/cf857b8e3aa9c6b0
I offered a way to convert elapsed days into elapsed years/months/days
and happened to notice that I used DateAdd with the 'd' argument

I have got the following query which I try to run:
UPDATE Qry_temp INNER JOIN Tbl_TEMP ON Qry_temp.Maaned = Tbl_TEMP.Maaned SET
" _
           & "Tbl_TEMP.Reklamationer = [Qry_temp]![Antal]

Any advice on a function to convert a given week number to a date?
Ideally I'd like the first day of that week.
I'm using this to compare year to year....using the week number as the
common factor.

I have "Spilt" my database and the "lookup" and "seek" methods that
previously worked, no longer do.  I have learnd from reviewing the
posts that the "lookup" and "Seek" methods cannot be used on linked
tables and that you cannot set an "index" for a linked table.

I have a new job where I spend all days making phone calls :-(, I would
like to program access to recognize if an answer machine picks up, if
the phone is disconnected, out of service, etc.  Is this possible at
all?.  Anybody ever done something like that? is there a third party