I have a subform that contains a datasheet of imported Excel Data.  When a
user selects a column, I want to store the name of the selected column/field
in a variable. Is this possible or if not, how else could I achieve this.
The purpose is to allow users to import a spreadsheet ...

I am having trouble editing and deleting records.  Right now all the database
has a feature where I can add records.  I want to edit records by having the
user search by the primary key.  Once they find the primary key the rest of
the record pops up and from there they can edit ...

dear friends, i am using ms access 2003.
i wanted to export data from access table to excel table.
so i have followed this
Dim db As Database

I have a form that has 2 fields on it; one for begin date and the other for
end date.  The users want both of these fields to default to the first day
and last day of the previous month.  (ex:  we are in June so the defaults
would be 5/1/2007 and 5/31/2007).  I am at a lost on ...

I am hoping somebody may be able to help. I have a very simple code in a
combo box.  The code is below.  The proble is that I keep on getting a Data
Type Mismatch error when ever I try to run it.  Just FYI the PC_Tag_Number is
a text field composed of numbers.    

I am encountering this error when trying to assign a piece of equipment to a
patient record within our database. When I click on "debug", it takes me to a
highlighted yellow line within the code process: Me.Assignee_ID =
iNewAssigneeID

I have a form that has on it a cboFileLetter(textfield), txtFileNo
(numberfield) and a button (there are other controls but not relevent for
this posting).  When the button is clicked I need to have txtFileNo fill in
with the next incremental number for the letter that has been ...

I need to get the following information about a file in a folder:
file name
file datetime
file owner (the name of the owner as it appears in the file explorer).

Good afternoon,
Is it possible to have a checking on the computer name and user name when
certain a database is being accessed. i.e. I only want the work done by
certain person and on certain machine.

Have a table designed as follows
equip1          text
equip2          text
equip3          text

I'm busy with an assett database to record all IT eqioment. I now have the
following problem..
I have aa field called "speed" in which I type the speen of the CPU ie
"2.4GHz"

I'm trying to expand on a filter that I previously created. My filter is
created from a combo box where the user would select a fieldname and then a
corresponding value combo box would show those items - that works great if
all the fields are from the same table

Could you pls take a look at the code below. The If IsUserInGroup part is
solid because I use it in other parts of my app and it works just fine. It's
the hide the form part that's not working. It still shows up for users other
than admins. I'm not sure why.

I have looked on this forum for this error, and the solutions haven't worked
for me (guessing my code is a bit different).
Basically, i want to load the values of a table into a combo box for
selection, which did work before, but now i have exceeded the 2000 character

Hi,  I have a continuous form to search for employees.  Edits are also
permitted from this form.   What I would like to do is update the login id
for the user who updates a record on the form.  
I have done the following: