Recent content by algecan

The reason I had left it blank is because if you do, you get prompted for a save location. This error messages occurs after a save location has been selected and your see the window coming up to say that it is outputting page 1 of 1. I do see your point though and it's problems to explicitly...

I have stepped through and it errors on the outputto line. As I have mentioned I have done a bit of testing to narrow it down and the one thing that stands out is the outputto as a PDF fails, put if I view the access report and then try and print this as a PDF using the Microsoft to PDF printer...

any ideas anyone?

I did think about the naming convention but it doesn't seem to be the case as far as i can see. As I don't specify one in the outputto, it's up to the user to decide that in the save as box that appears. it defaults to rptJCS, which is fine but again no matter what I change the name to I get...

I'll get the error regardless of whether I'm trying to overwrite a PDF that already exists or If i'm outputting a new one - if I have understood your question correctly?

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 plog, thanks for the response. The timesheet element was set up as above as time sheets are done on a weekly basis. Hence why tblTime_Card has just the week commensing date and employee ID, that way tblTimeSheet will show all the jobs that an employee has coded time to for that week. It...

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

Ah sorry, I thought it meant I could specify how I want to format and use the date. I've just changed it around to the below which seems to sort the issue out. strWhere = "[Holiday] >= #" & Format(startDate, "mm/dd/yyyy") _ & "# AND [Holiday] <= #" & Format(endDate, "mm/dd/yyyy") &...

OK. The code I use is Public Function Workdays(ByRef startDate As Date, _ ByRef endDate As Date, _ Optional ByRef strHolidays As String = "Holidays" _ ) As Integer ' Returns the number of workdays between startDate ' and endDate inclusive. Workdays excludes weekends and...

I have considered that and messed around with the dates as much as I can. The dates in the holiday table are stored as dd/mm/yyyy and i also use the DateValue function to ensure the dates being used are in the correct format. Not sure if I can do any more than that though.

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

I did try that but it produces 'Object doesn't support this property or method. Have aldo tried putting it in a with statement so... With wdDoc.tables(t) Cell(1, 2).Select Selection.TypeText objHead .Cell(2, 2).Select Selection.TypeText ObjNar...