Recent content by Desafinada

Hello Namliam, On using Startdate and Enddate: I've decided to go for the only startdate variety because it reduces the risk of error during a query. I shudder to think what would happen if there are missing periods inside the reporting period, on which my query depends. For me, the...

Hello Dave, sorry for responding late, I was on leave. Thank you for the clarification and I believe you are right. To everyone: another related problem bothers me, and I hope The_Doc_Man could reply as well. Remember my table Salary: Salary ID, Personal ID, Date Valid From, Amount It is...

Well, there's not much to change in the transferspreadsheet method, so in your place I would sort the table according to office number, copy all data and write the code to sort them out afterwards. I don't see any possibility for shortcuts.

Hi Dave, I didn't mention it in the original question, bu I need to produce financial reports for the company's productivity, so all the relevant data for me are past data. Among other things, the amount of salary paid to each employee for any particular month is of interest. Therefore I need...

Thank you, The_Doc_Man, for a very good response. Now that you've said it, naturally a three-column keys has a high overhead, especially for indexing I guess. I always thought artificial keys only create additional, useless data but now I know better.

What a badly formulated question from my side. Thank you namliam, it's not that I didn't know how to set a more than one attributes to be key. I only thought I wouldn't need to any write validation code if I could somehow define the time range & EmployeeID to be PK together.

I agree with Hightechcoach. For one, if one client has more than one bill type to pay, you'll have more than one entry in the tblclients for the same person. I'll assume one client can have more than 1 types of bill and that you care to differentiate between different bill types instead of...

Hello everyone, I have a table Salary which contains the following fields: EmployeeID, DateValidFrom, DateValidTo and SalaryAmount. Right now the table has uses Autovalue SalaryID as key, but only because I don't know how to define the range spanned by the DateValidFrom and DatevalidTo to be...

I had a similar problem transferring spreadsheet but my error message at that time was "Error 3048, no more databases could be started" and I know that's because I have too many queries running. Try changing the data types and please let me know how it goes, maybe it's just an overload problem.

Since I can't see your queries, I suggest that you check those queries again to see if they return any error. Maybe you could run them one by one and can then pinpoint which exact query/ies cause the problem.

Ist zach a table or a query? The error makes it sound like it's a query with 0 division. If it's a table, sorry, I run out of ideas.

What about evaluating each checkbox like this (just a pseudo code) The idea is to divide the sql string into three parts and manipulate each part accordingly. For the where clause part you can iterate all the check boxes and prolongs the clause with "AND column1 = true" for each checkbox...

Hello, I think the second parameter "102 might be the problem. According to this, http://msdn.microsoft.com/en-us/library/aa193071(office.10).aspx there is no 10 under the possible values

Hello fellow Access programmers, I came across a strange behavior from Access today. My task is to export an Access report into an Excel table. The report looks approximately like this: Person / Hours / Days Anita / 20 / 25 Bobby / 23 / 1 Clara / 1 / 17 Dennis / 30 / 24 When I export it from...