Search results

  1. F

    Second run of VBA not working (error 91)

    Then it wont run at all Tried an other syntax wich works With xlWS For i = 0 To aantal_rijen .Rows("9:9").Insert Shift:=xlDown Next i End With
  2. F

    Second run of VBA not working (error 91)

    I have a button that exports some data to an excel file and works fine the first time Second time i want to do this i get an error 91 on the line Selection.Insert Shift:=xlDown I think i forget to close or finish something after the first time but can not figured it out...
  3. F

    recordset of query not read data

    Solved. My mistake i didn't use google before. I thought i did something wrong in the query. Solved it with a 'querydef'
  4. F

    Access tables to sharepoint lists

    For 3. I can say that when sharepoint connection is lost you still can work offline. Next time you open DB and sharepoint is avaible you get a yellow bar to sync data. This do a sync without the need to go development part. My DB is also sharepoint related so some users can lookup some...
  5. F

    recordset of query not read data

    in attachment the database and necessary files. Extract to C: drive to let it work
  6. F

    recordset of query not read data

    Hi all, I have a query wich is filtered by a listbox on a form. When i open the query it shows me the results i need. If a open de query from VBA i get error 3061 and the query not shows data. The main use of this is to put some data in an excel sheet so we can send to other...
  7. F

    Hi Everyone

    My name is Filip and I'm from Belgium My main job is about building managment system so do a lot of PLC programming and etc ... Access if a hobby for me and i start to develop an access application at my work wich stills expands and it under construction. Main i go this way that there...
Back
Top Bottom