Recent content by JKB

I spent months and months and books and books and hours and hours learning A97 and VBA until I got to the point that I could write an application that was usable by my staff. Works pretty well, though I’m sure it's not perfect. Now I’ve got Win XP Pro, Access 02. Have converted my A97...

The following code on a Report works fine when I use a Cmd button on a form to Preview the report. Private Sub Report_Activate() 'If there is no "Attention" entered, then set related labels to non visible If IsNull(Me.Att_) Then Me.Label83.Visible = False End If End Sub I then close the...

Thanks Jon, But I'm about to decide that I am "out of my league" with Automation. I found the correct place to indicate the Reference and did so, and everyting in the module compiles, but the command button will not execute anything. Private Sub CmdMerge_Click MergeToWord() End Sub Me...

Carol, I got close, but apparently the software on my PC was not installed with all of the options. When I attempt to define the References you indicated (Tools--References), the References button is not on my Tools drop down list. I have a manual that shows a photo of it being just above the...

Carol, When I compile ModMergeToWord, I receive a "User-Defined Type Not Defined" error, and highlighted is your code: Dim WordObj As Word.Application When I compile the code for the command button on my form, I get the error message: "Expected line# or label, or statement or end of statement"...

Carol, The code you've posted almost solves my similar problem, however being a relative novice to VBA, please elaborate a bit more on the following: Where does the Function you wrote go? In a separate Module, or in the form? What would the code be behind the command button to reference your...

Funny, I was working on the exact same code this morning, having almost the same problem. MS says to create the passwork table field named KeyCode, using a number data type with an input mask. When you try this, you get an error stating that input masks can only be used with Text data type...

I have a split front-end back-end application that I have completed for the use of 2 other employees who share a single PC. Unfortunately, we are not on a network at this time, so I will have to make a copy of the "master application" on my PC and put it on the PC for the other employees must...

I have a typical employee table, all the usual stuff. With many employees, it results in many, maybe up to 30 possible different cities of address. I would like to create a form, on which there is a drop-down combo that displays an single, individual entry for any possible city that exists for...

After pressing Command Button CmdResearch, after making selections from 7 combo boxes, I receive a error message: Too Few Parameters; Expected 7 Private Sub CmdResearch_Click() On Error GoTo Err_CmdResearch_Click 'This command button is on frmPriceResearch. After a user makes selections_...