Recent content by rkaptu

Dear Pat. Thanks for that. I have created a completely new accdb and copied the modules from the old one to the new one, decompiled and recompiled, and compacted&repaired it. Now I want to see whether the error reoccurs or not... it might take some days. I like the idea of replacing the FE...

So after 2 weeks from the decompile and recompile the error showed up once. But this is no news, I have had instances in the past were up to 3 weeks passed in between errors and then the same error would maybe show up once, or maybe 3 times in 1 day and then disappear again. So it is completely...

No.It just reduced the file size and compiled without any issues.

Done. Now I'll see if the problem re-occurs or not. I forgot to mention that the applications on the user's pc are all accde's.

Yes. As I explained I have a data file (with various tables) on a server and the users have an application on their PC which contains no data but links to the data file. The VBA code is all in this local application. I do not use macros but only VBA code.

Hi all I have the Access DB which has now been running for 6 months. It consists of a data file with various tables which is saved on a server and local-based access-vba code which links to the data tables and performs the necessary data operations. The system has between 3-4 users at the same...

HI I have programmed a number of Access/VBA applications using the OpenObject/CreateObject methods to link to Excel Spreadsheets or Word Documents and transfer data etc. Now these are not working and returning an "Error 70 - Permission Denied". From research it seems that this is due to some...

Hi I am developing a Document Management System using data on sharepoint and MS Access as a front end. Part of this needs to scan documents and save them in a fixed repository. I am experimenting with WIA to use my Canon DR-C230 scanner. I have managed to operate the scanner with the ADF and...

as I said when I change something in a sharepoint list and I then open the query from the navigation pane manually, the data in the query is not updated yet... unless some minutes have passed. So it seems like there is some lag from the time the list in sharepoint is updated and when those...

No that's ok. I am rerunning the code and that is not an issue. But before I rerun the code I need to rerun the query itself. Opening the query does the job but I would prefer if I do not need to open it. Anyway if I open it I then need the Docmd.close ("form name") to close it?

Thanks Minty That works, but opens the query behind the form. And I do not want/need that. Is there a way of forcing it to open without being seen, or to recalculate the query without opening it at all? I am using VBA code to populate the listbox items since I am only putting some of the...

Hi thanks. IN fact I usually use the refresh list from drop down menu for the tables of the navigation pane when I change any structure of any lists. However I still have not found a way of running the query through VBA. When I open the query from the navigation pane it does not automatically...

Hi I am working on a DB which has various tables linked to sharepoint. The DB has queries using data in these tables, which queries I then use to provide data for list boxes in different forms. DB is used by various users, so it can be the case that the data in sharepoint changes, and a user...

Thanks Minty and MarkK I do not like the standard listbox options since I do not find them so user friendly when using a long list and needing to have a clear indication of what is chosen and what is not. As to the Listview I have used a code I found around to populate the listview: "...

Hi all I feel like I am missing out something. I want to create a control on a form listing a number of options (taken from a query) with checkboxes next to each item so use can select which is needed (then will be used to populate a new form used later on for something else). I have managed...