Recent content by vividor

Thank Sambo, this is exactly what I need.. but where do I put the code?

I have a report that is going to present some information related to vacations days. I am using a check box, I want the check box to check marked itself if the day requested is the same as todays day. in other words, If ([day req]) = Now() then check box will check marked itself.. Is any way...

Neileg, How does the Nz function works? can you make an example for me? Can I put that function on the report or queries?

I am creating a report that list my days off from work. In this report I want to show a column for my "Day Request(01/20/2003)", "Day Recorded (check box)". I want the Day Recorded to check itself if the day is equal to "Day Request" using, Now(). It will look something like this: Day...

For some reason I am getting an #ERROR If I have do not have a record on (INI COMP), also (HOURS EARN) is duplicating the value, for example, I enter (5 hours earned) on the report it shows 10 hours earned

I have a report and I created a field name "available COMP TIME"(in hours).. the formula should be something like this, (total hours earn + Ini comp) - (total hours req) I was doing something like this "=(sum([hours earn])+([ini comp]))-sum([hours req]) , but is not right.. can some one...

Hey guys, I am building a data base where I can calculate my days off at work I want to have a data entry form with these fields: Date Day Requested Days available How can I make the "Days available" to update immediately after I punsh in the data on "Days Requested"... I want to be able to...

Surjer, thank you This is exactly what I need.

Hey guys, I have two Forms one is like a intro Form and the second Form is the Main Menu. When a user click on this data base, I want the Intro Form to open for few seconds and close then the Main Menu will open. Is there any way to do that using the Timer Interval? I am not to familiar with...

Schof, you are a good, just like Einstein.. this is exactly what I need. Thank You

Schof, you are correct. I will create a report with the users that has completed their report. Now, can you elaborate more on the instrution you gave me.. i already added a check box "RptCompleted", I conected column "RptCompleted" to the Row Source. What else? Where I put this...

Schof, you suggestions is really close to my issue.. Let me give you more detail about this form. The check box will be invisible to the user so the user do not need to check on it , also this field will be the last field on the form before jumping to the command button "Record Save" but I...

I have a Form and at the bottom there is a command button to save the record and close the form. What I want to do is to create a field on my table called "RptCompleted (Yes/No)", so when the user click on the command button it will trigger the field "RptCompleted" to switch to "yes". You see...

A flag is a good idea.. but How can I do that? I already created a query and I added an extra field in my main table named "RptCompleted". How I can make the command button "Save Record" to flag "yes" the field "RptCompleted" ?

I have a Form and when the user finish the form I want the user to click on a command button name "Report Completed". This command button will save the record but at the same time will take the information from 3 fields in a table, copy the information to another table name "Reports...