I have created 2 forms in Access 2003. The main form contains data that is
mainly product details such as order numbers, product descriptions etc. The
main form also has the name of the supplier, the original equipment
manufacturer and the transporter. The sub-form contains the ...

I have a combo box that displays an employees first and last name. When a
name is selected, im trying to get the Firstname to populate txtbox_firstname
and the Lastname to populate txtbox_lastname. Can someone please help.
The recordsource in the cmbo_names (combo box) =

Sorry for cross-posting but there was no respond in
microsoft.public.windowsxp.general. :-(
Sometimes I need to open three or more A2002 projects at once. So I have 3
or more items in taskbar menu for main projects. When I open any object

I am using Access 2007 and have a rich text field in a subform. When
the subform is opened directly the toolbars for formatting function
correctly when the field has focus, however when the form is opened in
a subform the toolbars remain disabled. The fields display correctly

Hello all, i have added a button to a form and used the button wizard to add
the duplicate record command.
When i click the button i get the following error " the command or action
'recordsgotonew' isnt available now.

I am having a problem with a database that i'm creating for a college.
The boys can enter for any grade which is called A, B, C, D, E and they can
enter the college at the begining of any of the 4 terms
I have a field on the application form of class they want to enter and of

Hi, I'm using Access 2003
I'm running a qry as part of a form which I want to use external data with
the WHERE clause, which would be gathered from a selection on a combo box on
the same form, this would then use the qry to populate a list box.  I'm

I want to add the Insert hyperlink function to a command button on a form, at
present I have a field on a form that requires a different hyperlink for each
record so the user, click ito the field then selects the insert hyperlink
button on the tooldbar, but i want to remove this ...

I want to be able to apply some security to my database but do not want to
have to go the resource kit direction. I know I can go to view and remove the
tool bars but how do I keep the user from being able to go back to view and
show the tool bars. For instance, I want to set up ...

I am trying to populate a field on a form with the following line of code:
Me.LASTNAME.Value = DLookup("[LNAME]", "[TEST]", "[SLNUM] = " & MSL)
I get the error:  Runtime error 2001  You canceled the previous operation.
Any ideas?  

I am trying to copy a table out to a dbf which works fine.  The thing I am
having a little problem with is make the file name a variable.  Here's what
I'm using:
Function COPYtoSVR()

Hi, hope someone can help with a question I am having with a form.  I
have a form where the user wants the previous entry automatically
entered in the new record but can change the field's record when
needed; the entry is based on a combo box.

I am working on an attendence database. The students are suppose to sign in
using a bar code. The problem is that they can close the system down using
the sizing button tool bar. They just close down the whole thing so nobody
can sign in.

HELP! Back in July someone wrote the following to help someone to delete
duplicate records.  Could soneone please explain in furhter detain how to do
this so I can try it?  See below.
"lgalumbres@gmail.com" wrote:

The message appears when i try to open my switchboard:
Run Time Error 2465
Microsoft Office Access can't find the field 'Option2' referred to in you
expression