Can anyone see why when I select a 'second' person with the same
lastname...why the form below doesn't change...however it does when I select
a different lastname.
Private Sub Combo73_AfterUpdate()

I need some help here.  I have the following field:
MD - combobox
FE - Yes/No field
FV - Yes/No Field

Have tried variations on this, but keep getting Error 2428.  Anyone know
what's wrong with these lines of code, and why I get error 2428?
I'm trying to compare the password for a UserID (stored in TblUsers) to a
text string they enter in field [text4].

I am an Access developer and do much SQL backend and Access frontend work.  
Current project is a form that is bound to table that has been populated by a
pass thru query from SQL.  This table has approx 60+ fields to input, each
record is tied to a unique ID taken again from the ...

I have an Access application which creates an Excel workbook with data from
an Access database.
When this Excel file is created, we want to be able to add a button to the
toolbar and have it execute an Excel macro.

In my clinical research application, I am attempting to have users fill in a
'Patient Info.' form with 8 total fields.  The first 3 fields (ID, intials,
site) are stored in one table that can be added to.  There are 3 more fields
on the 'Patient Info.' form that are populated by ...

I have the below code, which was in a link, thanks for that gentleman who
gave it to me
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _
   "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

I need some guidance in how I can find a record from a table and to be able
to edit values.
My scenario is that I want to use a combo box to find the desired record. On
selection, it will go to that record, display the information in a form and

My primary key in one of my tables is defined as an autonumber. However, in a
Findrecord I need this object text. What command should I use to convert
autonumber to text?

I am inserting a new record into a table and I want to get the primary
key value from the newly created record.
The table design is:
Field Name             Type

Hi, I am trying to programmatically capture the Table name value (that a user
would designate) from the Linked Spreadsheet Wizard.  I have a project that
(via code) makes use of this built-in wizard to link to external
spreadsheets; however, I cant seem to find the object that would ...

I hope I can explain this clearly.
I have a DB that records details of properties.  A master table
(tbl_SRMASTER) records the Portfolio certificate (PK = SRIDX) and a secondary
table (tbl_SRDETAILS) records the detailed information regarding each

I have a form which prompts the user to enter criteria to generate a report
(which is based off a query).  If I close the form without entering any
criteria a box appears to "Enter Parameter Value".  If I decide I don't want
to generate the report, how can I close/exit the form ...

Hi,
I have a textbox on a form used  to capture the start date used as a
parameter for a query.  I want to validate that the date is valid. For
example, Feb 29, 2005 is invalid, and currently it breaks the sql code. Is

Hello,
I need to insert a hyphen into a text field (Field1) in a table.
For example, the data for Field1 = "1234567". I want to insert a hyphen
after the 3rd character, so Field1 = "123-4567". Is there a built-in function