|
|
Open .chm Help when on subform? by
John G
Access 2003 on Windows XP. I converted a .hlp help file to .chm and now I'm
calling it with the code shown below. This code works fine when the focus is
on a...
|
January 23rd, 2008 02:14 AM
by John G
|
0 |
96 |
|
|
|
|
3 |
112 |
|
|
Next number based on current record by
John H.
I maintain and update a database where I record Alphanumeric tags. Different
sets of tags are used at any given time. When I enter a new record, I...
|
March 30th, 2007 12:50 PM
by BruceM
|
8 |
221 |
|
|
duplicating records that contain subforms by
John Harrington
In my database, it is convenient to occasionally duplicate a record
and modify it.
The button wizard in Access helpfully has a "Duplicate record"
option. ...
|
|
2 |
135 |
|
|
Labels that /look/ bold but aren't by
John Harrington
Why is it that sometimes labels look "bold" (when they are not bold)
while other labels on the same form have a normal font weight? I can
see no difference in...
|
|
1 |
139 |
|
|
Restoring default control properties by
John Harrington
I’ve created a subroutine that looks like this:
Private Sub GrayMeOut(ComponentName As String)
Me.Controls(ComponentName).ForeColor = &HD8D8D8
...
|
|
1 |
114 |
|
|
Subform opens blank by
John Harrington
When I first open my form, the subform has the correct number of
records in it, but the records (consisting of a combo box and a couple
of text boxes) are...
|
|
0 |
192 |
|
|
|
|
1 |
95 |
|
|
Clearing a multivalued combo box by
John Harrington
In VBA, how do you clear a multivalued combo box?
Simply setting it to Null doesn't work.
Thanks in advance,
John
|
|
9 |
174 |
|
|
Tab control "bleed through" by
John Harrington
In Access 2007, I had a form that had two sections of controls.
Today, I added a third section and thought "oh hell, this is getting
unwieldy. I'll just make...
|
|
5 |
170 |
|
|
Open a subform by ID by
John Harrington
If I want to make a button on MyOpenForm that opens a form with a
table record source to a specific ID (e.g., 2) in the table, I write
the following in the...
|
August 5th, 2009 11:31 PM
by Klatuu
|
1 |
104 |
|
|
|
|
0 |
62 |
|
|
Create complex data entry form by
John Hawker
I need help designing/creating a complex data entry form. I am developing a
training db to capture individual training attendance. The problem is
recording...
|
|
7 |
115 |
|
|
Axtivex error by
John Hofstra
In Office 2000 using Access in Windows XP: Axtivex-error!
When I start a MS database, I get the message:
Axtivex-part can't create object and OpenForm has been...
|
|
0 |
87 |
|
|
transfer to other computers by
John Holte
I have several (stand alone) computers in my house. I want to create a project on one of the computers (using Access 2007), and put the code on the others....
|
October 22nd, 2009 02:47 PM
by Klatuu
|
1 |
212 |
|
|
ListBox default value by
John Ingato
I have a combobox on a customer form called LocationChooser which list the
properties this customer own.
When the form opens, the CB is empty (no default...
|
June 9th, 2008 05:33 PM
by Klatuu
|
6 |
122 |
|
|
Login forms by
John Jenkins
Hi Jeff
Thanks for the help - whats the best way of passing you my 'good' email address.
Many Thanks
John Jenkins
"Jeff Conrad" ...
|
|
5 |
423 |
|
|
Excel Spreadsheet by
John Jensen
I cannot remember how to add a button in an Access form
that will open an Excel spreadsheet for editing and review.
|
|
1 |
86 |
|
|
Pivot table print background wrong by
John Joyner
When I print a form containing a pivot chart to a color printer, there is a
large rectangular area, within the page background area, that contains the...
|
|
0 |
52 |
|
|
Date input mask by
John K
I have a form that has several date input mask: 99/99/0000;0;_ . I have them
auto tab to the next field. Lately after putting in all my data I copy and...
|
|
1 |
69 |