Search results

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

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

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

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

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

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

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

I am not really a beginner on access but I have a little problem on a data base that i am working on, I am trying to set a default value on a text field. I have a text box field where the user supposse to type in the quarter and the year ( ex. Second Quarter 2002) in words just like the...

Hi guys!! I am not really a beginner on access but I do have a little problem on setting a default value on a text box. I have a text box where the user supposse to type the quarter and the year( ex. Second Quarter 2002) but I would like for this field to fill itself. I tried the...

Hey guys, I am kind of loss with all those instructions... My Problem is more simple than the comments I read in the forum. I got a check box named "New Page" and belog that a field text "Comments". I want to enable the text field "comments" when I click on the check box "New Page, in the mean...

I have a text field that I would like to be enable when a certain check box is checked and unenable when the box is not checked. Any help would be appreciated. Thanks.

I am building a data base where I can to track the up dates on a web page. one of the fields that I want to include has to do with dates, How can I create a field on a form that can show me that date of the last update... can some one help me?

Hi!! guys, I do not know if this is posibble but any suggestions will be appreciated. I have a field on a form where I want it to be able to select the Driver (C, D, E, F, etc...) and type or select the name of the file. Also, I want to be able to go into the table itself and make the whole...

I have a data entry form but I want all the fields clear as soon the form is open? How can I do that..