Search results

  1. B

    Adding a Decimal Point

    I have an Access 2010 table which shows Latitude and Longitude. However instead of it being in a decimal format it is displayed as 4000000000. I need to add a decimal point so that it looks like 40.00000000. If I configure the Field Properties to Decimal with a scale of eight and decimal places...
  2. B

    Run Pass through Query with VBA?

    Hello Everyone, I am trying to run a pass through query from access VBA. Private Sub Command25_Click() Dim dbs As dao.Database Dim qdf As dao.QueryDef Dim strsql As String Const c_strSQL As String = "Call updateihdinfo({p1}, {p2})" Set dbs = CurrentDb Set qdf = dbs.QueryDefs("query1")...
Back
Top Bottom