Recent content by Sigma248

Hi, I have made the changes suggested but still get the same error. Code: Private Sub cmdSave_Export_Click() Dim intID As Long Dim strQuery As String Dim myQueryDef As QueryDef Dim strOutputPath As String Dim strFileName As String Dim strFileNameAndPath As String DoCmd.Save Set...

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.

Thanks everyone, got it working, the >= is correct. :D

I get unexpected results. An empty recordset when I should get a recordset with some records.

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

I have made some progress with the code it is now: protected void Button1_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\\Swantrax_2003.mdb; Persist Security Info=False;"); con.Open(); OleDbCommand cmd = new...

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?

Thankyou both, what you said works perfectly.

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

Thanks for that, the IsNull function works perfectly. i.e. If not IsNull(cmbClient.Value) then Call cmbClient_AfterUpdate end if If cmbClient.Value is Null no action is taken.

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