Recent content by tempk

Hey, thanks for the reply. Good to know what others are doing to circumvent the problem!

Hi all, I seem to have encountered a strange problem at work. I declared a public variable for user department. The user selects his department from a Log On form and if the password is correct, he opens another form with the department variable passed on in openargs. All of this works fine...

Okay. Thanks for the advice, Pat!

Question though, new staff would be appended on to the current staff table and half a corresponding record in the transaction table, am I right? How about transferring departments? How should I indicate which department the particular staff is being transferred to? I came out with the different...

yep, i already have lookup tables for departments and also rates. so i should have only one table with all the people's information inside and another table linked to it which is for storing the transactions? okay, i get understand what i need to do: using the transaction table, there is a...

I managed to normalise my initial table into 4 tables each for reclass, new adds, transfer in and transfer out (each linked to my StaffTable by fkStaffID). e.g.TrOutID fkID TrOutMonth TrOutStaff(number of staff transferred out) tblStaff structure: PkID Dept JobDescription CorporateLevel...

Hi Pat, you are always enlighten those of us who are lost. :) I guess the whole design had flaws to begin with. I just kept going and going and finally ended with a huge crazy pain in the ***. Haha. Perhaps I have to relook at the whole thing and redesign it.

Hello everybody, I am over my head with this problem. I have a table that has details of staff at my workplace. I am using access to calculate the impact of staff movement on our budgeted salary. Thus, I have set up a system in which managers can use some forms to transfer, reclassify or add...

Hey..thanks for the reply. The idea to do all this in vb was because I did not want to create more queries. The [variable] is coined because some tables contain all the fields I require while some only have some I need. The number of sql string might increase because there might be more...

Hi all, Still new to VBA and I am trying to create a function that runs an append query like this: Dim strSQL_1, strSQL_2, strSQL_3 As String strSQL_1 = "INSERT INTO tblConsolidate([variable]) SELECT [variable] FROM qryResults" strSQL_2 = "......FROM qryOtherResults" ...so on and so forth...

Good morning, it worked. You may be right that Sum() implicitly converts a string to a double. Thanks a lot!

alright, will try it out at work tomorrow. thanks for sharing. weird that I couldn't find that in access help. Something surprising everyday..

What function is that?

yeah..i know. Yet I am able to sum up the column? Just don't understand why though.

Hello everyone, I have noticed something strange in my report. I have a few reports based on single queries where I use text boxes to calculate the sum of a column and a record. For column [Amount], I used =Sum([Amount]) so on and so forth. For a row, I use =[Amount]+[Expenses] to calculate the...