Search results

I have a form that has a field called "SumOfTotal Days", it is populated by counting the number of days taken as leave. It rolls it up to one number. If a person does not take any leave then I want it to put a zero "0" in the SumOfTotal Days box. It is working fine when there is a value but not...

I have a form that has a field called "SumOfTotal Days", it is populated by counting the number of days taken as leave. It rolls it up to one number. If a person does not take any leave then I want it to put a zero "0" in the SumOfTotal Days box. It is working fine when there is a value but...

I have a zip file attached to try to make this a little easier to explain. What I have is a couple of variables; I need assistance in determining how it should be written. I have a rate chart table (2002DailyRate) and depending on the Grade (id) and the number of year (salary##), populate the...

Need help in assigning the NT USERID. In Office 97 I wrote the program this way: Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. ' Move to the switchboard page that is marked as the default. Me.Filter = "[ItemNumber] = 0 AND [Argument]...

Can anyone assist me in saving the information that is showing on my form to a different table. The table that I want to save it to is called Leave Control Log. The system locks up on the first line (DIM DB As Database). Can any see where I messed up. Thank you for your help. Dim DB As...

This is a follow on to another message, I want to put this value in the table and form. It show in the form but the table still shows the rounding error. Right now I just have it as a Form Load but would like it to perform the calulation for the whole query and not just the form. Thank you...

I am using VBA to do a calulation and would like the value to be save in the form as will as the table. The Project Days value is not updating after the stop date is entered. It is not putting the value shown but the none rounding amount is kept. I also have one more that I will post separate...

Need a little help: Table: 1. I have a table where I store name's and ssan's 2. Another table with other data; ie dates, amounts, etc. with the above table info. Query: 1. Made one query using both tables. Sql: SELECT [Copy of Leave Control Log a].[Leave Number], [Copy of Leave...

I have three Iif statement that I would like a module for: They are: A. (0)zero = Balance2:IIf([Leave]-Fix([Leave])=0.0,Fix([Leave]),Fix([Leave])+0.0) B. (>=1-5<=)= Balance :IIf([Leave]-Fix([Leave])>0.5,Fix([Leave]),Fix([Leave])+0.5) C. (>=6-9<=)=...

I am trying to write a query to round the calculation to(0.0) or (0.5). I have read all the help menu but can not figure it out. Query: Round(((DateDiff("y",[Startdate],Date()))/6*0.5),1) QUERY Item System Date 6/12/02 Start Date...