Access 2007 - Combo Box selection is putting record into edit mode
Mon, 8 Dec 2008 10:17:01 -0800
Hi,
I have a combo box on a form that is set up to find a record based on what's
selected from the combo box. That works, however, after retrieving the
record, it keeps putting my data into edit mode (the pencil appears).
I want to make a selection from the combo box and view the record, not have
the comb ...
|
True/False calculation converted to checkbox?
Mon, 8 Dec 2008 10:08:15 -0800
Hello,
MS ACCESS 2003 on XP PRO.
I have a query that calculates whether or not something is present in a
table, and returns a True or a False.
Then a form reads this results (through an additional query) and display it
for that record. (the form is columnar).
I want the form to display the data as a ...
|
Datasheet-view form opens as single view
Mon, 8 Dec 2008 09:09:01 -0800
I have a button on the SwitchBoard wich opens MyForm with code:
DoCmd.OpenForm "MyForm"
MyForm has datasheet-view. But when opened from the button, it appears in
single-view.
Is the button code responsible or somethig else? ...
|
Display Forms in Access as Winodws Instead of Tabs
Mon, 8 Dec 2008 07:57:55 -0800 (PST)
In Access 2003, the forms all displayed as little windows that you
could resize. Now, they display as tabs. since the forms still show up
as windows when you convert 2003 Access databases to 2007, I'm
guessing that there's some setting that you can change to make them
display this way. However, I can't figure it ...
|
Primary Key format
Mon, 8 Dec 2008 06:39:01 -0800
Hi
I am using Access 2007
I have an installation form which has an autonumber Primary Key
[InstallationID]
I have set the fields format property to 00000 so it displays as a 5 digit
number with leading zeros.
I also have an [installation Code] field on this form (This is a 2 charecter
Prefix eg:AC) ...
|
Controls sohws #deleted
Mon, 8 Dec 2008 01:45:01 -0800
Hello -
Vista, Access 2003.
I'm using form A to find a record and open its full details in form B.
In Form A - there is a sub-form (datasheet) with the table info (example -
contacts).
I have a button that opens Form B according to the record selected in the
sub-form in form A.
After form A "calls" form B ...
|
Display an ampersand '&' as normal text in a label
Sun, 7 Dec 2008 23:25:00 -0800
In Access an Ampersand is displayed as a line, I need to display the symbol
'&' in text boxes.
For example "Total number of North & South Sales."
Thank you ...
|
|
|
Disable Paste in Form Record Selector
Sun, 7 Dec 2008 23:22:01 -0800
I would like to disable or prevent pasting a whole record with a form Record
Selector. Can it be done?
The user can add a record in a new line. The Record Selector is used in that
form to select records to delete them or to do summation of records for a
certain field. So I do not want to disable the Record ...
|
Form Wizard Error
Sun, 7 Dec 2008 20:55:00 -0800
I am receiving the following message:
"The wizard is unable to open your form in Form view or Design view,
possibly because another user has a source table open in exclusive mode.
Your form will be opened in Design view."
I am the only one working on this database, and the only person who has the
option ...
|
Enable code in 2007?
Sun, 7 Dec 2008 15:28:13 -0800
I've been using Access for a number of years and have been writing simple
VBA code successfully for a number of those years with much help from this
forum. I just started using the 2007 version and have encountered an issue
I've never come across before. None of the controls I add to forms are
functioning pr ...
|
