in
All Tags » VBA » update (RSS)

Browse by Tags

  • Update linked tables in access using vba

    I have a database with about 50 tables linked to a SQL Server catalog. I have a catalog for each month using the following naming convention MTHYYYY. To switch between catalogs I currently update my ODBC connection pointing to a new month then update all linked tables in my Access database using the...
    Posted to Access (Forum) by microsoft on 04-19-2010

  • Access DB created with vba code/reference update?

    Hi everyone I have made a Access DB and have several forms with vba code, I have made a MDE file but wanted to know because all the refereneces (word and excel) are linked to office 2003 applications will this database work with older office 2000 or xp applications? such as excel and word? and when the...
    Posted to Access (Forum) by microsoft on 09-23-2009

  • Update Table Through VBA Code Using DoCmd RunSQL

    I built a DB that has a form used to input data. The fields on the form are not bound to any tables. I am creating code to capture the data from the form and upload it to a table. Below is an example of how I am doing that... Me!txtANS01_01_07_OTHER.SetFocus If Not Me!txtANS01_01_07_OTHER.Text = ""...
    Posted to Access (Forum) by microsoft on 08-28-2009

  • VBA - Update Command

    Can anyone tell me why this update query is not executing? TextField = "" SerialField = "" DoCmd.RunSQL "UPDATE tblEquipment SET tblEquipment." & GlobTableField & " = " & TextField & ", tblEquipment." & GlobSerialField & "...
    Posted to Access (Forum) by microsoft on 08-18-2009

  • How to commit a database update in VBA code

    How does one commit a change to the database in Access VBA code? The problem is, I have the following code: private Sub button_Click() If ([Status] = "PASSED") Then [Status] = "IDLE" End If Shell("my_program.exe", 1) End Sub and "my_program.exe" is seeing [status...
    Posted to Access Coding/Macros (Forum) by microsoft on 08-07-2009

  • VBA Macro to automatically update queries in data ranges

    I have an Excel spreadsheet that has several data ranges containing SQL queries that tie back to an access database. The queries are stored separately in ".dqy" files. Now, by right clicking on any specific range I can set behaviors such as "refresh data every XX minutes" or "refresh...
    Posted to Excel (Forum) by microsoft on 08-02-2009

  • update SQL Query in VBA Using Variables

    I am trying to use an update query but cannot get the syntax correct. Please advise. This is obviously my hardest thing to grasp (SQL Query syntax with variables). For Each varItm In Me.lstVendorPartsList.ItemsSelected varPartID = Me.lstVendorPartsList.ItemData(varItm) DoCmd.SetWarnings False Dim sqlStr...
    Posted to Access (Forum) by microsoft on 07-29-2009

  • Access Database, VBA: Need to capture last update date of Access databases

    My project is to determine the Date Modified date of several hundred Access databases. This is the date which appears in detail view of files and folders in Windows Explorer, as well as in the Database Properties window. How could I determine and capture this date to append to a table using VBA code...
    Posted to Access (Forum) by microsoft on 07-10-2009

  • Cancel Update

    Hi Experts, Let say that I have 5 fields with 'Keys'. I insert data into 3 of them. I decide that I dont want to save this record, how shall I do this in the VBA ? The fields do NOT accept Null values. How shall I cancel? Regards
    Posted to Access (Forum) by microsoft on 07-10-2009

  • Updating a chart using a Macro

    Hi, I would like to update a chart using a VBA code. More explicitely, I have a chart that refers to a dynamic range of columns as source data. Now, when the array changes, I would like the to just press a button that is linked to a Macro which enables me to update the chart. The thing is that I have...
    Posted to Excel (Forum) by microsoft on 06-30-2009
Page 1 of 2 (16 items) 1 2 Next >