Search results

  1. R

    Updating a recordset in Access 2010 with an Excel 2010 userform

    Hi CJohnson, I think it would be easier if you put a form in the access db and do updates from there instead of excel As for the top 3 problems: 1. What do you mean when you write [Technician_name]Id = '38'...Is it rowId? 2. Try opening the db before you update (Connection.open) 3. replace...
  2. R

    Loop through table and export to excell

    Hi MJ8, If you want to go through a table, this is how i would write it Dim strSQL as string strSql = "Select [Field1], [field2], [field3] From tableName" Set Objrs =objdb.openrecordset(strSql) With objrs Do while not .eof --Add your coder here --Use .fields(0).value for field1 (dot...
  3. R

    Import from Excel

    When you open an attachment, a copy is put under the temporary internet files in a hidden OLK folder
  4. R

    Import .txt files with file name

    Try removing the second end sub at the buttom
  5. R

    Read Excel value into an Access variable

    HI Flag, can you please explain more
  6. R

    Need to update occurrences of a character in a field - name field

    Hi Keith, I Suggest you use an IIF statement try something along the line of: 'Subtract len of field before and after you take out the \ to find how many slashes IIF(Len(Field)-Len(replace(Field, "\","")) = 3, 'If it is three use the InstrRev to find the last \ and replace with space around...
  7. R

    Converting text date to number date

    Hi Tony, Try Format( '2011-01-12 11:00', "dd-mm-yyyy")
  8. R

    Command button to clear existing table and import new data from excel file

    Hi Jakobal, i think first you need to create a table with the exact same columns as the excel file On a form create a text box (say text1), a browse button, and an import button. Then try the code behind the Import button Private Sub ButtonName_Click() Dim db as database Dim strFileName as...
  9. R

    Path Not found Error

    Hi mdlueck, This is only part of the code i got, this is full code: Dim db As Database Dim ObjSource As Object Dim fso As Object Dim fso2 As Object Dim rs As Recordset Dim ssql As String Dim iSize As Integer Set db = CurrentDb() Set fso = CreateObject("Scripting.FileSystemObject") Set fso2...
  10. R

    Command button to clear existing table and import new data from excel file

    Hi Jakobal, Are the excel files in the same format every week?
  11. R

    Path Not found Error

    Hi all, i am trying to get folder size on a network drive and coming up with a Path not found error, please see below code: Set fso = CreateObject("Scripting.FileSystemObject") Set fso2 = CreateObject("Scripting.FileSystemObject") sql = "Select [Server Name] from Table " set rs =...
Back
Top Bottom