Search results

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

Hey guys, can some one help me on understanding how to make a search form. I have one big table named(BSA-Report) and a data entry form named(Quartely Report). I would like for the user to have the option to finish typing the report later, so I added a buttom at the bottom of the form for the...

Hey guys, I have a form which is my data ntry form but for some reason when I move the round click on my mouse, previous records will show up. you know!! the kind of mouse I am talking about, right!!! is the one, I think made by Microsoft, right click, left click and the one on the middle...

TO be honest, I tried to make a Search Form base on a query before but it did not work for me.. I think I am not doing something right, can some one explaing to me How to do that search form.

I have a table and a form name "BSA Report Form" to enter the data. I would like to create a search form with 3 text box fields (Quarter, Location and Business Unit) in order to get a specific record. I want to do that because the users are managers that sometimes do not have time to...

Antomack, thanks a lot... definetly this will give me something to think about it... I was thinking something more like.. If 4 then print"Four Quarter" and then the year.. but I will work something around this... If any body else has another suggestion, I would appreciate the input..