Recent content by jbotts

Using the following code the Word document does not appear on top but rather shows up in the task tray. I have tried inserting DoEvents as well as .Activate and nothing seems to work. Here is the code: Dim objWD2 As Word.Application Dim oDoc As Word.Document Dim oSec As...

Using Microsoft Office 2007, and Windows XP. In Access 2007 a Word document is created, text is added, and Word closed with VBA. Then unable to open the document because it is 'locked by user'. ***********Code********************* Dim wo As Word.Application Dim path As String Set wo =...

Thanks for the help. I had never used an alias for a field name, and that has solved the problem. ( P.FundingSource AS PFundingSource ) and finally Me.PFundingSource = Me.FundingSource worked. Thanks again, jbotts

I have a form bound to the following query: SELECT P.*, A.* FROM tblPatientInformation AS P, tblAdmissions AS A WHERE P.PatientID = A.PatientID Both tables have a field named FundingSource. When I write the following assignment: Me.P.FundingSource = Me.A.FundingSource I get the following...

Thanks, vbaInet. That is the solution! jbotts

When closing a form, I am trying to have the user enter a value in the text box that is not the default value. The following code will work if called in a command button click event. With GoTo PROC_EXIT the cursor will be in the designated control when the sub below is called. I am trying to...

I have the following code: Private Sub ExitCheck() On Error GoTo PROC_ERR If Me.txtbox.Value = "Enter here" Then Me.txtbox.SetFocus End If If Me.txtbox2.Value = "Enter here" Then Me.txtbox2.SetFocus End If PROC_EXIT: Exit Sub PROC_ERR: MsgBox Err.Description Resume PROC_EXIT End Sub...

vbInet: The code you suggested does change the Canlendar Control value property, but when the code is placed in the form's Load event code, it does not change the dates displayed in the form. Any suggestions as to how to change the displayed date in the Calendar Control?

I am trying to write VBA code to set the displayed date of a Calendar Control 11.0. When I write the code, the Calendar Control shows up in the intellisense, but Day, Month, and Year properties do not show up. I would like to programatically set the displayed date of the Calendar Control. Dim...

The conflicts must be manually resolved. Microsoft has a very helpful Article ID: 883870. It may be located by searching Google with Microsoft Article ID: 883870.

Thanks NoDictator for letting me know. I am not losing any sleep over his comment.

Thanks for the constructive criticism. The fact that I am "not very savvy" was really helpful. I have identified the problem and solution.

The message says there are none. Where are they usually located?

I am running MS Access 2003 using replications. Each time I initiate the Master or a replica of my application I get a message that there are conflicts, and asking if I want to resolve the conflicts. Upon clicking yes the screen says there are no conflict tables. How do I prevent the conflict...

Merianne, I solved the problem. The combobox was bound via a control source property. Once I cleared the property, the problem was solved. Thanks for your help. Jim Botts