Search results

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

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...

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

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...

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

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...

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...