I install MS Access 2010 runtime  expecting to find runaccess.exe - but it's not there. How do I install runaccess.exe?

I have an old application with  a complex command line to call an Access file using runaccess.exe.

https://www.microsoft.com/en-au/download/details.aspx?id=10910

Click download, a white box appears with and X and nothing else.. Attempted with Chrome & IE

https://www.microsoft.com/en-us/download/details.aspx?id=50040

I have an ODBC connection to a Cache data to append to a table in Microsoft Access and that is working just fine. But what I would also like to do is to take that same recordset and display it in Access like an Access query using VBA. I found some examples using qrydefs but I can't seem to get it to work with an ADO connection. Is there another way of doing this using ADO?

Below is an example of my connection string that pulls the recordset I need. Any suggestions would be greatly appreciated.

Thank you in advance,

Ken


Public Sub RunLVPendingQuery()
On Error GoTo PROC_ERR
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strVar As String

    Set cnn = New ADODB.Connection
    Set rst = New ADODB.Recordset
 
  DoCmd.Hourglass False


  cnn.ConnectionString = SQCon
  cnn.Open
   
           
strVar = "SELECT DISTINCT SITE.U_DPL_View.AN, SITE.U_DPL_View.PtNumber, " & _
             "SITE.U_DPL_View.PtName, SITE.U_DPL_View.CollectDateODBC, " & _
             "SITE.U_DPL_View.CollectTimeODBC, SITE.U_DPL_View.PriorityCodes, " & _
             "SITE.U_DPL_View.BatTstCode, SITE.U_DPL_View.HID, SITE.U_DPL_View." & _
             "ReceiveDateODBC, SITE.U_DPL_View.ReceiveTimeODBC, SITE.U_DPL_View." & _
             "WorkSheetID, SITE.U_DPL_View.WkshtCode, SITE.U_DPL_View." & _
             "DeleteEvent, SITE.U_DPL_View.PtLoc, SITE.U_DPL_View.TestCode, " & _
             "SITE.U_DPL_View.CID_1, SITE.U_DPL_View.CID_2 " & _
             …

I have an Excel file that looks like the following.  I know how to use the query wizard to find dupe Company Names and how to use the query wizard to find Dupe First Names.  But how do I create a query to find records that have no dupes?  In this case, just one record.

Using Access 2013. and I.E. 11 . This does not happen when copying from Chrome, but company policy is we need to use I.E. 11
There was a recent change company wide to add a line break on email addresses using the following code on internal web pages.

function formatEmailForWrapping(string) {
      var newString = string;
      newstring = newstring.replace(/[@]/, "@<wbr />")
      newstring = newstring.replace(/[_]/g, "_<wbr />")
      return newString;
}

It is not an option to change back to the old format therefore we must fix this in Access. We need to find a way to clean the email address. it's being pasted in the form it looks fine. But when it's saved and displayed it has "? next to the "_" and the "@" along with other garbage with seems invisible. I tried a VBA replace of the "?" but that did not work.

Does anyone know the correct code to look for to clean out the line break? Or has anyone had this issue before and have a fix.

If the address being copied is   my_name_here@company.com it is saved as  my_?name_?here@?company.com

Thanks in advance

Hello, I am attempting to add vba to a command button to look at a text box and if not null, then look at a combo box. If that combo box is null, have a pop up message box and not allow the user to save the record. Since it is a continuous form and there are several records showing, it works fine on the first record, however it does not for the following records. I believe this is because I need to loop through each record. Below is the VBA I have so far. I would greatly appreciate any help regarding the loop, as I am new to VBA.

If Not IsNull(Me.Text33.Value) Then
   If IsNull(Me.Combo24.Value) Then
MsgBox "You must state if the rationale is aligned with procedures for each disputed subcategory."

Else
'do nothing
End If
End If

DoCmd.Save
DoCmd.Close
Thank  you in advance,

Susan

Hi
I have a simple database that contains a couple of tables, queries. macros and modules etc.. I'm trying to make it more users friendly, so I have designed a form that loads up and will give the user the option to select an option button then the macro will run and create the report. However what I want the form  to do is to remember the last option button that was selected when the form re-opens.

Thanks

Hi
   How to create a macro for exporting the excel data into access database. Can anyone please help me.

I have a continuous form 'Address_Pre' in my Access 2013 application.

Each line lists a subset of all of the address information for a client. (ClientName, Contact Name, address line 1, office phone, email address)

All of the text boxes are locked on form 'Address_Pre'.  

There is an 'Edit' button to the far left of each line o form 'Address_Pre'.  When this 'Edit' button is pressed the user is presented with an editable screen ('Address_Full)' containing all of the address information for the client.  Changes to any of the address fields can be made on this screen.

When the user saves the revisions on the 'Adddress_Full' it closes and they are taken back to the continuous form 'Address_Pre'.  When I come back to 'Address_Pre' I do a requery to show any information that may have been changed.

This works and the updated information is reflected on 'Address_Pre'.

The problem is that when I do the requery upon returning to 'Address_Pre', the top line of the form becomes the current line.  If the user is working there way down thru all the addresses on the form they have to arrow down to the next address they want to work on.

What I would like to have happen is:

The user presses the 'Edit' button on the twelfth (or whatever) line down from the top of the form.  They make changes and come back to 'Address_Pre'.  I want there changes to be reflected on 'Address_Pre' but I also want the twelfth (or whatever) line they were working on to be the current record …

A client changed his SQL server 2008 R2 SA Password. He doesn't remember what the old password was. Now his Access application doesn't work.

We have a good backup. Is there a set of files/ folder we can restore from backup to get the old PW back? I'd really not go through the pain of doing a complete system restore.

Thanks!

I cannot close each pdf file separately
OpenClosePdf.accdb

Hi,
 I want to upload my excel data file to access using button event. Below is my code.

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click

        Dim Conn As OleDbConnection

        Dim Cmd As OleDbCommand

        Dim Filename As String = "D:\Ayyappan\claimDump.xlsx"

 

        'Try

        Dim StrFileName As String = String.Empty

        Dim XLA As New OleDbDataAdapter

        Dim XLTable As New DataTable

        Dim StrSelect = "SELECT * FROM [{0}]"

 

        OpenFileDialog1.FileName = ""

        OpenFileDialog1.Filter = "Excel |*.xlsx|All files (*.*)|*.*"

        If OpenFileDialog1.ShowDialog() <> Windows.Forms.DialogResult.OK Then

            Exit Sub

        End If

        StrFileName = OpenFileDialog1.FileName

        Conn = DBConn()

 

        Cmd = New OleDbCommand("INSERT INTO claimDump([a],[b],[c],[d],[e],[f])  SELECT * INTO [Excel 12.0 xml;DATABASE=" & StrFileName & ";Extended Properties=Excel 8.0;]", Conn)

        Cmd.ExecuteNonQuery()

        ' Catch ex As Exception

        ' MsgBox("Some error")

 

        'End Try

 

    End Sub

While running the code I got "IErrorInfo.GetDescription failed with E_FAIL(0x80004005" this error.

 
Am checking my excel sheet the header name is same as per the insert statement like a,b ,c etc..

Can anyone help me on that.

I'm trying to work out what parts of a project that I need to tackle are feasible using MS Access. Although this question has many parts, I am really after yes/no answers and perhaps some general clarifying comments about whether it's feasible. If it turns out feasible then I will ask new, specific questions on those parts I don't know how to do.

I have a table containing details of jobs that need to be done in a geographic area and the list includes GPS coordinates. The plan is to:
1. Display the list of jobs on a MS Access form alongside a map showing ALL the  points, not just the selected one (to get a visual overview). Since I don't think I can create a single hyperlink that would display all the points I thought the easiest way would be to use a function to create a kml file and then launch that KML file in a browser control with Google Earth on the MS Access form.
     I know how to create the KML file but is it possible to display the resulting Google Earth display in a browser control on the form?

2. I would like the user to be able to select a job, assign it to a team and have Google Earth reflect the assignment by perhaps changing the color of the pin. The only way I can think of would be to re-create and re-launch the KML file after every update.
    Is that a feasible approach, or is the refresh likely to be too slow?
    Is there a better way?
    Is there a way to have Google Earth highlight the pin that corresponds to the record selected in the …