I have a acess project 2003 on desktop and Sql 2000 on the server
I'm using Windows NT Integrated Security
I want to capture Network User Name in a text box.
I use the funtion FOSUserName() and User() and WNetGetUser() and the message

I am running Microsoft XP professional and Access 2003 and that a character.  
I am modifying an Access program I used last year which contains several
forms.  I am now getting the strangest error message was one of the forms.
Whenever I attempt to open the form, I get the ...

I am trying to print a dynaset obtained from a Filter by Form.  The
OpenReport fails if the resulting recordset is too big.  The where clause is
being passed a comma separated list of the IDs of each record in the filtered
set thus exceeding the 32768 character limit.  I would ...

I want to copy a shortcut to the desktop (Access application) and therefore
I want to find the 'msaccess.exe' on the computer.
Is there a way to get the path to the msaccess.exe file?
And second, how do I address the users desktop like %system%my documents...

I have two fields that need to be validated on the form, check # an
registration type.  It it is a check the user adds a check # and th
registration type is 'C' if it is a deposit it defaults to 0 and th
registration type is 'D'

I have a table of user id, password & name.  I have a form that in order to
modify it you must have a password.  This is captured in my password
routine.
1.  I need to capture the userid and name at the password sign-in level.  

Hi - This is quite difficult!
How can I go about Linking (not-importing) docs with drag and drop.  Also,
is there a way to change the stored folder of the docs to a new predetermined
folder when the file is linked?  One more, is there a way to rename the file

Is it possible to use wildcards in specifying table names when refreshing
links to external databases?
I wish to link all tables beginning with "Home" (such as HomeAssessments,
HomeGoals, etc.) to one external database, and all other linked tables to

I want to be able to do some logic as soon as a Form Opens but before a user
has the ability to do anything yet.
I tried putting the logic I want in the Form_Load Event, but this Event is
triggered before the Form actaully Opens & is shown on the screen.

MS Access 2000, Windows XP
======================
Hi,
I have a form for person information (names) and a subform for the Cars

Hi guys/girls
I have a form with a subform.  The  main form is based on tblContact
and the subform is based on tblMeeting.  Linked by Contact ID.  On
Contact can have many meetings associated with it

background:
I have a form that builds a filtering string based on date range and a
Subject code.
that are saved as public variables. When opening the target form I see the

I have a problem, I am trying to create a new record with some of the
information from the previous record except for one item.  The Charge
Sequence number needs to increment, but it first needs to see the highest
number for that case and defendant that already exists.  I used a ...

I am using Access XP and have ran into a really annoying problem with this
whole conditional formatting limitation.  Hopefully someone has managed to
get around this. I have tried several of the VBA recommendations found on
Microsofts site and it still doesn't seem to get around ...

I've got a problem with some code on a continuous form and I'd appreciate
some help with a solution, as I'm completely stuck!
On the last control of the continuous form (txtPN) there's an after update
event that runs some code and sets the value of a hidden field (me.chkNewPN)