Search results

Sorry I put this in the wrong forum It should have went to the VBA forum, please review the VBA forum.

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...

VBA Code Travis, Thanks for the code, you are a big help, just one more thing. Where do I save it to? On open form? This will have to run each day to keep track of pay because of the variables. Again thanks for all the help. The program is coming right along.

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...

Thank you GHudson, Thank you, it worked like a charm :-) Lynsey2, Thank you for replying to post. All I find this site to be the best and thank all the people you have posted information or replied to post. Jbatey

Thank you GHudson,

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]...

Thank you Pat Pat, Thank you for all the help.

Travis, Thank you for all your help.

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 am trying to take the system date - start date and come up with total number of days: System 6/17/02 Start Date 9/30/01 260 days Then take the number of days (260) divided by the every 6th day. Days 260 divided by 6 Days by leave...

It's changing numbers that I don't want to change. Can this be inserted somewhere in the statement? >=0.1 and <=0.4 then +0.5 0.5 leave alone >=0.6 and <=0.9 then +1.0 0.0 leave alone

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<=)=...

Thanks Ally & Harry (rounding) Ally & Harry, Thank you both, you two were a life saver

Harry, I cut and pasted Ally case joining directly from the message. I went back and looked at it again. So I cut and pasted what is in the query below...

Ally, Thank you for your help. I am getting a error message saying: "The expression you entered has a function containing the wrong number of arguments." So I deleted the ")"'s that were highlighted and still getting another error message: "The expression you entered is missing a...