Search results

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

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

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

Hi I need to do a report showing a schedule for a whole week. Each day's schedule is calculated in the same and so I thought of creating a subreport and calling it 7 times from the main report. I have include 7 subreport controls in the main report and called them SR1, SR2,.....SR7. I am...

HI I am working on a report based on a query that displays data between 2 different dates. The query is based on a table that includes one column with Inspection dates, and in the query I added a Criteria 'Between [Start_Date] and [End_Date]'. I also created two parameters in the Query...

I am new here.. working on a DB using data on sharepoint and offerring a scheduling, reporting and other forms through access.