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...

I would like the text stored in a memo field to be formatted as Calibri 10. But whenever I paste from the clipboard to the control on my form, the text that...

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...

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. ...

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...

I’ve created a subroutine that looks like this: Private Sub GrayMeOut(ComponentName As String) Me.Controls(ComponentName).ForeColor = &HD8D8D8 ...

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...

I'm writing a sub to duplicate records in my database. I'm writing it myself because I've found that the built in duplicate button in access is insufficient...

In VBA, how do you clear a multivalued combo box? Simply setting it to Null doesn't work. Thanks in advance, John

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...

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...

Thought I’d share this with the group. I had asked the question earlier in another forum and didn't receive a response. What I was wondering is can you add...

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...

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...

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....

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...

Hi Jeff Thanks for the help - whats the best way of passing you my 'good' email address. Many Thanks John Jenkins "Jeff Conrad" ...

I cannot remember how to add a button in an Access form that will open an Excel spreadsheet for editing and review.

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...

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...