Search results

Can anyone tell me what is wrong with the ExportXML command in the following code. It returns the error: Run time error ’2467’: The expression you entered refers to an object that is closed or does not exist. vba Code: Private Sub cmdSave_Export_Click() Dim intID As Long Dim strQuery As...

Hi All, How would I open up a connection to an Access mdb from within VB.NET to allow getting data from tables.

Can anyone tell me what is wrong with this SQL Satement when used in a MS Access 2007 CurrentDB.OpenRecordset command. ("SELECT tStatusChanged.AddressNumber, tStatusChanged.StatusNumber, tStatusChanged.StatusChangedDate" _ & " FROM tStatusChanged" _ & " WHERE tStatusChanged.StatusChangedDate...

I am having a problem with this line of code: If (rstDates!fldValidFromDate <= Format(Now(), "mm/dd/yyyy")) And (rstDates!fldValidToDate >= Format(Now(), "mm/dd/yyyy")) Then It works most of the time but not when one of the fldValid dates is exactly equal to Format(Now()...

How do I connect to an Access 2003 or 2007 database from Visual Studio 2008. I found the following code on a website and have tried it but get 1 error to do with the connection string: protected void Button1_Click(object sender, EventArgs e) { OleDbConnection con; OleDbCommand cmd...

I have the following situation. MS Vista Home Premium on a Desktop PC & Laptop which are networked with a network share for public documents. MS Access 2007 is installed on both machines. The database is split and the front end (Queries, Forms, Reports, etc) is installed on both machines with...

Where can you get the MS Office 2007 Icons from for use with MS Access?

I am trying to refresh a cmbbox's list after opening another form and adding a value that should appear in the list, and returning to the original form. i.e. cmbClient_Name and I add a Client Name and details to the Names table on a pop up form then close it returning to the original...

I am having a problem checking for null values when a form is opening. I have multiple combo boxes on a form and depending on the value of each of these combo boxes associated text boxes display information. i.e. Depending on the value of cmbClient when the form opens associated clinet...

I am trying to access an existing .jpg file with the following procedure: Public Sub Check_For_Files(Filespec As String) Dim fs, f, s Dim Filespec_2 As String Set fs = CreateObject("Scripting.FileSystemObject") Filespec_2 = Filespec & ".jpg" Set f = fs.GetFile(Filespec_2)...

I am attempting to use the DatDiff function to get the difference in hours between two type DATE variables, one is a Short Time and the other is just a standard date. Time_1 = DateDiff("h", "rstJobs_1.Time", "Time_Off_Job") I don't get the expected result. e.g. If rstJobs_1.Time = 11.-00am...

I am trying to use the MkDir function to make a new subfolder of an existing folder path: Public Sub Create_Folder(Job_Name As String) Dim Folder_Path as String Folder_Path = "C:\Dean\Documents\Work\" & Job_Name MkDir (Folder_Path) end Sub where "C:\Dean\Documents\Work" is an existing...

I am trying to use the MkDir function to make a new subfolder of an existing folder path: Public Sub Create_Folder(Job_Name As String) Dim Folder_Path as String Folder_Path = "C:\Dean\Documents\Work\" & Job_Name MkDir (Folder_Path) end Sub where...

How do you gain access to the value of a text box on a page of a TabCtrl. I have tried variations of something like this and can't get it to work: text box: txtTextBox TabCtrl: TabCtl1 text box is on Page 0. Form: Form1 TextBoxValue = Forms![Form1].TabCtl1.Page(0).txtTextBox