I am not understanding how to copy the code that Dev wrote getting the
current user ID into Visual Basic and then calling it from my Access
form.
I copy the code. I insert a new module. I paste the code. I go to a

I have a table called Patient Data that contains Social Security Numbers. –
the field is called SSN    I do not want duplicate SSN’s in the database,  
On my input form, I have the following event procedure on the Before Update
line

Through a query that uses grouping, I am gathering info from a City table.
The table has two fields, the key field and the field City name. Sometimes,
the query outputs two or more records.
I would like to show the output of the query in a form, not as three

I have a collection and add the items in the loop.
I would like to check if the item exists, if yes, I will concatenate with
original and new information, f not I just need add new one.
My code is like following, but it works only null string,

Why this code Not Show  the dialog box ShowColor
=============================
Public Function colors()
Dim cdl As CommonDlg

Thank youI'm using Office Access 2003Why this code not work?And this message
box appear to me?'''''''''''''''''''''''''''''''''''''''''''''''''''Runtime
error '91'Object variable or with block variable not set
''''''''''''''''''''''''''''''''''''''''''''''''''''' Include ...

The following code works fine when executed as a double-click event.  When I change it to
a click event I get run-time error 2115 when in BannerUpdate (last routine in the code
snippit). The text displays in the banner and I get the error.
comboQuads is a combo box which is ...

I have one break point in my VBA form module, even I toggle it to not break
point, but the program still break at that point, no matter what.
Any idea about this?
I set the break ponit for testing, but I can not reset it.

what is the code to set a field value to the logged in user's initials?
(the one I'm looking for is something stored in MS windows as part of the
user's account -I think; not one associated with Access)
thanks in advance,

Hi everyone! Using A02 on XP.  I have a table [UnclaimedTable] with lots of
records that need to be matched up, if possible, to records in another table
[DistribTable].  So I have a main form with [UnclaimedTable] records and a
sub form with [DistribTable] records.  

I have a form where I want to populate a control [txtbusinessnamea] based on
the content of either of two other controls [txtmemnbr] and
[txtempmemnumbera]. If neither of the latter controls have data, then I want
the first control to be blank. So a series of lookup statments may ...

I have a simple SQL string that is run from a form when a field is updated:
strSQL = "UPDATE tblDesign " & _
       "SET " & strFieldNameForUpdate & " = '" & strDM & "' " & _
       "WHERE DesignName = '" & strName & "' ;"

I have a form that displays one record displaying information about a piece
of equipment.  Each similar piece of equipment is marked with a "use order"
which indicates what order they will be installed on the machine.  When the
user changes the status from "inventory" to "on ...

I have a continuous form bound to a UNION query, that displays information
from 2 different queries. This displays the records in the form fine but I
want the user to have the ability to delete the records individually if
required with a check box. I can't do this with a bound ...

Need a way other than using Sendkeys in the Form_Activate event. To display a
certain ribbon tab with a particular form.
Using the keyboard Alt key shows the keyboard shortcut to click individual
ribbon tabs.