Search results

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

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

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

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

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

Hi all, I have a form with a combobox. The combobox displays a table field. When the form opens it displays the appropriate field of the first record in the table. If, using the combobox to look up a different record all works as planned. I have a user defined close button on the form which...