Search results

I have an invoice report that contains 3 subreports (time, materials, detail). In the footer of the report I have a the invoice summary which contains a field that calculates expenses based on the subreport. It has a control box in it with the following: =[InvoiceSubReport].[Report]![Text19]...

Worked like a charm! THANKS SOOO MUCH!

How do you do that without having to re-key in all the 2000+ records in there and reformatting payroll, etc? Actually, I created a report with 4 subreports and it seems to work okay as a work-a-round except....if the subs have 4 records, the report repeats 4 times,, if it has 14 records, it...

Hmmm...lemme try to explain it a little better. I have columns, vacation, holiday, sick and other, etc. I need the query to show me a report of ANY of those fields that is greater than 0 (the default value). When I type "is not null" it looks for records in which they are all not null but...

I have a query with sick hours, vacation hours, bereavement hours and other hours. I need it to pull up any of those entries IF they are >0. If I put >0 under each column then nothing comes up because they are not ALL populated. Do I need an expression in the query??? I'm learning ALOT but...

The attachment with the db snippet is in the previous post. Somedate should be the workdate from the time card table. I'm a little confused as to how to pull it together in a form. Should the #somedate# be workdate? Should the form be based on a query?

Hmmm...maybe something I need to look into

I'm just curious. Which type of menu do you Access guru's prefer to use? A custom Menubar or a Switchboard?

Does this help?

I am still playing around trying to make this work. My form needs to have the multi-select box from the employees table and the work date field from the Time Card table right? The Code goes in the update button and when clicked it will make a new time card and time card hours entry for the...

But is still isn't working...UGH!!!!! Not putting anything in the VacHrsAvailable now. Do I put a text box on the form and give it that name or do I use it from the field list from the employees table?

WHOOPS I thought that was the hire date! Sorry for being retarded!

Are you teaching me things the hard way? hehehehe Here ya go.... http://users2.ev1.net/~dls4967/VACATION.zip

I wish but I think it's like 15mg or so...is there any way to delete all of the info in all the tables really quick?

1983

I just got the error to go away...I mean JUST now...I had DAO3.0 checked and I changed it to 3.6. No more error as far as that but I'm getting an 0 in the vacation field and it's putting that into the employee table too on everyone. Dates are calculating just fine though as far as the 40, 80...

Not any more lost than I am being a virtual Access virgin and all....lol Lemme check... Yup and I took them out....same error. Double Ugh

Ugh! done...same error...type 13 mismatch...when I click debug it keeps going to Set db = CurrentDb() and highlighting it :(

Hmmm...I have... Private Sub Form_Load() Dim db As DAO.Database ' DAO Dim rs As DAO.Recordset ' DAO Dim datHireDate As Integer Dim dat40 As Integer Dim dat80 As Integer Dim dat120 As Integer Dim strStartDate As String Set db = CurrentDb() Set rec = db.OpenRecordset("EMPLOYEES") Do Until...

Thanks! I think I fixed that. I am using 2003 but now when I go to open the form I get a "run-time error "13". Type mismatch.... When I click debug it goes to: Set db = CurrentDb() ???? This one is gonna make me pull my hair out isn't it? How come the code worked fine in his sample db and...