Search results

found it, putting out the autorefresh in the excel sheet did the trick Data > Connections > Properties > (uncheck) enable background refresh

hey all, the code below is working but i got an issue with it, maybe someone can help me out. so it opens an excel file, refreshes the data in it and closes it again. i had to put a timer because i kept getting a notification saying 'By completing this action the refresh will be cancelled and...

the moment you said null fields in your previous post i was thinking NZ() hummm so yeah wurth a try, ill implement it tomorrow and let you know thank you for thinking with me so far :)

Hey, they actually do have emty fields they can be ".", " - ", "08:15 - 17:15" (example time), or empty its a plansystem with daypartblocks like for example 08:15 - 10:00 , 10:15 - 12:30 where each block got his backgroundcolor light up when he is within his working hours i am allready...

I have a subform (continious form) with 7 fields that have 2 conditional formats, when i enter these formats the db start randomly crashing, like 3 times it open well 4 the time it crashes etc .. it once crashed that hard that all my files in the db got deleted. what am i doing wrong ...

Hi, so the problem was i have 3 togglebuttons and it has to remember witch one was last clicked, so even if you close down the db, on opening it has to toggle down the right button, how do i do this i stored the output of the clicked box in a table field witch i linked to the form it is on in...

Hi, I have a main page, on that main page there is a field called 'sel_naam_dropdown' the data in that field comes from a subform when you click on the line in the subform it gets the naam of the person in that line '=[Form]![Sub1].[Form]![Naam]' works perfectly on that subform i have a...