how can a person access a database if the shift key has been coded out,
disabled ?

Using access 2007, How do i append a record from one table to another?
I have created an Append query but get an error message.  "An INSERT INTO
query cannot contain a multi-valued field"
The record obviously has relationships.

Is there a trick to allowing the user to type something in a text box,
and then press the Enter key to start an Event process?
If I use Sub textbox_Enter(), it works, but then just clicking in the
textbox executes that code, too (for some reason), when I don't want

Good afternoon,  I am very rusty at Access and did do  lot of reseach before
asking this question.  I have a table that stores details of companies called
companies.  The Primary index of the table is an autonumber called Company_Id
and stored within the table is information such ...

I have a combobox that looks up a matching value in the form recordset when
you pick a row item. That's easy and MS does the coding for you. My problem
startes when the data is refreshed. The highlighted combo item is still in
showingbut now the form does not recognize it as in ...

My tool box does not expand or light up when moved into design view.  No
orange colors.  What to do?

Hi. In the switchboad I have two buttons to open my FormA.
From Form A can open FormB.
Those two buttons in switchboard. has different methods to open FormA.
Button1 opens the form in Add mode.

The Access application works well.  Now we want to take it on the road, where
a laptop won't work.  Palm Treos (Windows OS) are within our budget.
Can we put the application (or most of it) on the Palm?  If we do, how does
the secretary transfer the data into the main form when we ...

Is there any way to do this?  A mix of gray and blue forms in one app
looks awful, and since not all of the target machines are running 2k7
switching the entire app to the new color scheme doesn't really make
sense either.

I'm using code to email from access with outlook. When it's sending I always
get a prompt from Outlook "A program is trying to automatically send e-mail
on your behalf" and I have to press OK.
How can I eliminate this message?

Is there a possibility in Access 2003 to easily edit a form? In Visual Basic
you can even use a texteditor to edit the forms and modify properties of
objects. This is far more faster and easier than in Access.
Thanks

I have a form that acts like a switchboard called frm_Forms_Switchboard.  The
first combo box lets you select a user, and then it should automatically open
the user form (frm_user_projects) only pulling the selected users records.
Here is the background:

I'm must be missing something very simple but...
I have an option box in the footer of a continous form. I'll use the option
box to set the filter property on the continous form. The problem is the
first radio buttton in the group is selected when the form opens and I'm not

I have a subform (Person) which is nested within another subform
(PersonalAssistant). Everything works fine except the foreign key in the
PersonalAssistant subform. I have used the Link Child and Master Fields
property to establish this link. In this case the primary key for the ...