Search results

The tblMonth have the raw stats, say Apple sold by employee at $1.10, this is pulled to the report and formulas applied to show cost 40%, ($1.10 x .4)= $.44, profit = 1.10-.44=$0.66. What is save on the tblYTD is the data $0.44 and $0.66, then report goes to the next employee, do again until...

Four to five down far back I showed that's what I did, it's good for one employee data. If all direct reports are pulled for a supervisor, the loop won't work because the source is different from the destination table. The rst refer to the destination table, therefore rst.MoveNext follow by a...

What do you think of this, I know it will work on a single pass. The situation is while the report is open there are multiple reports by employee, to use the rst.MoveNext, I have to run set.rst=rstOpenRecordset(. tblMonth. . . ) while the opened report is running the same. Will this work...

What do you think of this, I know it will work on a single pass. The situation is while the report is open there are multiple reports by employee, to use the rst.MoveNext, I have to run set.rst=rstOpenRecordset(. tblMonth. . . ) while the opened report is running the same. Will this work...

I think I have to break down what I am doing. I am pulling the data from a report query by supervisor (many staff) from the tblMonth. On the report module I have the ff. Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tblYTD", dbOpenDynaset) <<<===== tblYTD rst.MoveFirst Do Until rst.EOF With...

I must be doing something not right. I tried different ways, it either I get all except the first or get the first and then message already exist. I added rst.MoveFirst before the Do statement. By the way, I placed this code on the Close Event Procedure. Does it matter what user report on the...

namliam, IT WORKS! Thanks. One more item. Since the supervisor will pull and print all his/her staff at one time, when the data is save to tblYTD the data, empId, supvId are save correctly but the data of the second staff is the same as the first even it is different. This is what I did and I...

Thanks, some piece is missing, I generate a calcsheet report, on this report it shows all the user's activities, rolled-up for the month and it shows if they meet the task standard. Every activity functions gets UPH (vol/time) vs standard. If the standard for the function is, 20 uph ( tiers...

Hi namliam, I didn't want to elaborate my problem to create confusions but this is the situations. Data is input on the database table daily, I'll called tbl_Daily and monthly performance report is pulled for all staff. A report rollup the daily data to a monthly with formulas to compute unit...

I have a monthly report that query a table for stats for various users with calculations and print results. I would like to capture those data to another table for year-to-date performance ratings. I created a module that contains a public type Final Results variables. On the report module...

CyberLynx, you're on the right path, many thanks, that's where I started and it's been working since. boblarson, my problem is and was, I have to shift key to open my master copy for changes but it happened on few occasion that I was not trying to run the master but another database. As I...

Thank you, you're very close. I have couple of back up on the same folder "Copy (1) of Master xxxxfile.mde". I was in a rush, when I press the Shift key and double click the original Master copy, all the files in that folder was highlighted, start opening and then it deleted itself when it...

Hello, Can you provide me the link for the code to prevent deletion when updating the front-end mde file. I accidentally ran my master copy and deleted it. Thanks

KeithG, I tried diff. ways but I am getting variables not defined. it can't recognized the Hwnd; hmenu; SC_Close. I tried declaring a Dim, didn't work. I copied it exactly as posted. RuralGuy, since the issue is the same maybe I my missing the user32? I don't know that. Thank you.

This is a continuation of my thread posted 2/21/08, solved by Rolaaus. Reference: Log In and Log Out Information Save. The Log Out is now working, saving the posted date-time information only when the exit button on the main menu is selected. On the main menu form properties, the Close Button...

Rolaaus :)Kudos to you! It took me many days working hours here and there, until I acknowledged I needed help. I appreciate it!

It's able to hold and retrieved information from memory, I followed your suggestion to: me.form.visible = false (frmLogon form). In this case, I could have reference the data directly from the password textbox on the frmLogon form, so that makes my Public User-type declaration on the module...

It able to hold and retrieved information from memory, I followed your suggestion to: me.form.visible = false (frmLogon form). In this case, I could have reference the data directly from the password textbox on the frmLogon form, so that's makes my Public User-type declaration on the module...

With User2 <== this is working .ID = UserID.Value .PASS = PASS4 End With Yes, the PASS4.value is transferred to "PASS" and it works. I check the table Userlog and it records the Id, date, and time. I was in the impression that after the information was pass through above Public Type...

With User2 <== this is working .ID = UserID.Value .PASS = PASS4 End With Yes, the PASS4.value is pass to rst.PASS and it works. I check the table Userlog and it records the Id, date, and time. I was in the impression that after the information was pass through above Public Type declaration, the...