When you open the Access 97 wrkgadm.exe, should it show the workgroup
that you are currently using? When I join a workgroup, then close and
reopen the workgroup administrator, it always displays system.mdw.
Thanks.

I need a code in the Before Update event procedure, which prevents to
enter duplicate record in a form.
I have the main formX, which takes values from the table named tblX and
a subformY, which takes values form the table named tblY. Both forms

We split our Access database as suggested with a front end applicatio
on local machines and back end tables on a data server.  We need t
add a field to one of the tables but it looks as if splitting th
database prevents us from making changes to the structure of th

Help,
probably a simple mistake. Trying to take a text field containing
numbers in a query for a combobox. The number is 9 characters and I
wish to display only the last 4. Using help and the net I have found:

im having trouble workin out how to make a hyperlink automatically become
an email address in a form as the database is for collegues with very very
limited knowledge of access and they need to imput information and email
address is one and the link is tryin to connect to a website ...

I had in the past the most ridiculous erection in the world,4in.I'm not
poor and then,I used all the supposed "miraculous products" to
rectify.Vainly.Until one of my friends,who experimented it
himself,advise me to use an african grass,in the way of tea.As long as

I have a large table in Access 2003 that I ran a query on.  I'm looking
at the results of the query in a tabular "datasheet view".  I'd like to
convert the query results into a new table.  After a lot of poking
around, I haven't found an easy way to do this.  Surely I'm missing

I'm trying to paste the following sub into an A97 global module.
Code lines failing to compile show up in red immediately. The 3
lines referencing "Array" are the one's failing. Sorry for the news
reader wrapping in the first line...

We secured an Access MDB for a client, using the Access 2000 (or above -
still trying to find that out) security wizard. I trust the developer who
did this, and the screendumps of the process don't give any indication he
missed a step, or got an error, etc.

OK, I just got a weird question.  Can MS Access make a Gantt chart?
Has anyone ever done that?  How did you do that?
Thanks in advance,
Laura

I've got to let end users (really just one person) load billing batch
files into a third party app table. They need to specify the billing
cycle name, the batch name, and the input file name and then I can use
these values to execute a SQL Server stored procedure to load them

Can someone tell me what I'm doing wrong in this query?
UPDATE tblEventsSituationsIncidents SET
tblEventsSituationsIncidents.ES01 = [ES01]+1;
I'm trying to update the value in table field [ES01]

I have been using this on Access2K on Windows2K fine:
Public Declare Function IsUserAnAdmin Lib "shell32" () As Long
But running it on Access 2003 on WindowsXP I get this error:
"Can't find DLL entry point in IsUserAnAdmin in Shell32"

Hello, i have the following problem:
I have a form linked to a table, lets say tableActual.
Now, a user types in his values and saves the table in the following way:
DoCmd.TransferText acExportdelim, , "tableActual", "tableActual.txt", -1

I have an Access form which is used in a multiple-user environment.
Could someone please help me with this. I want to put a CLEAR, or ADD
NEW RECORD button which should ignore all the alerts and validation
warnings that the form is currently giving..