Search results

I seem to get an intermittent problem when trying to output access reports to PDF, resulting in the error 2501. This has been covered numerous times on the internet but the fault usually seems to lie with either characters in the file name such as brackets and colons or permissions, neither of...

Hi all, I've done some research into this but can't really find a definitive answer. This questions spans the Table topic and Queries Topic so I'm hoping I can get an answer here. I have a database where I need to store a time duration. I understand it's not best practice to store...

Hi All, I’m hoping you can help me. I’ve got to incorporate an excel spreadsheet we currently use to record employee time into our existing database. The way the spreadsheet works is that each day is obviously on its own row. Then the employee records their start time, finish time and when...

Hi All, I’m hoping you can help me with a problem. I created a database for work a few years ago, that amongst other things, is used for storing details of jobs and also the time spent against these jobs. For these functions I used three table: tblJob Job_Ref PK EmployeeID FK Job_Year Time...

I have a database where I need to calculate the business days taken between the start date and finish date of jobs. This calculation also needs to incorporate holidays. To get started I implemented the modules from...

Hi all, I am just in the middle of writting a little bit of code that will go through each record in a query and export it into a word table. It's in the early stages but all was working yesterday. I've come to it this morning and ran it and now I get an error message; Run Time error 91...

Hi All, I have just started to develop a database that will export data directly into a word template. I have used Word automation quite a lot but I'm new to trying to automate Word from Access. It's going OK at the moment, I have got the db to open up the template, write data and then...

Ive started to get this message quite a lot on my database (2003 SP3). It is split between a FE and BE and has one main form that has several tabed forms and sub forms on them, including a couple of reports that run. Ive read quite a bit on this but cant seem to find a definative answer. I...

Hey, Im in the process of adapting the audit trail that was posted on here a few years back now by 'ghudson'. the problem that i have with it is that i get an error message when i change the values of combo boxes - "'Operation is not supported for this type of object." I did abit of digging on...