Search results

I am sorry, by "total" i meant the totals toolbar button

Hi, I have a query which uses the "Total" in its row. using that i find the sum of cetain fields. now if there are no records to return for the query I would like to get a blank record to be returned. I know when "total" is used it doesn't return blank record. how can I get it done? Sudha

hi all, Thank you very much. I used the dlookup and it is working fine. thanks again.

Hi, I have a query which needs to find the value of GeneratorKVA. I have two other fields in the query, total elec load in kVA and required kVA. Required kVA is calculated as Required kVA:[total elec load in kVA]/.8 if Required kVA = 0, then Generator kVA=0 if Required kVA>0 and <=20 then...

Hi, How do I round values to the next multiple of 5, but if the value is a multiple of 5 then it should return the same value.

Hi, I have a form for a table which is used for data entry. the default value for some of the fields on the form are set to ="" because highlighting the"0.00'' every time and entering values were difficult for the user . now if the user doesn't enter any value in these columns I need to get zero...

Hi, I have a form for a table which is used for data entry. the default value for some of the fields on the form are set to ="" because highlighting the"0.00'' every time and entering values were difficult for the user . now if the user doesn't enter any value in these columns I need to get zero...

Hi, I have a form for a table which is used for data entry. the default value for some of the fields on the form are set to ="" because highlighting the"0.00'' every time and entering values was difficult for the user . now if the user doesn't enter any value in these columns I need to get zero...

Thank you!

Hi, I have a form where the user uses a combo box to make a selection and the corresponding details are displayed. While creating the combo box I chose the third option i.e "find a record on my form based on the value I selected in my combo box''. I am using this form for an Edit button. here...

Thank you.

Hi, I have a form with a combo box where the user selects the required Project. I have a Report button on the form. how do I get the report based on the selection in the combo box. currently my report shows all the Projects. I want a report only for the project which is selected.

Hi, I have a table with room details, i.e length and width for various room like UPS room, equipment room, guard room etc. I have a form for this table where the user has to fill in the length and width. Each time I open the form to add a new record, the first record is displayed. I want a blank...

Hi, I have a switchboard with the first button for open form in add mode. I want the switchboard form to close also when the button is pressed. How do i do it?

Thank you very much.

Hi, How do I use a combo box on a form(for a query). the combo box must have the values from a field called 'Project'. the form must then display the record selected in the combo box

select tools, references and then check 'microsoft DAO 3.6 Library'. This can be done only in code builder. sudha

hi, how can i cancel an update on both the main form and subform? I have a cancel button on my main form. using this how can i cancel the updates on both the forms? if i give cancel = true, with msgbox, in the before update of the main form only the mainform's changes gets cancelled.if i give...

hi, how can i save/cancel the changes made on a record both the main form and the subform? sudha

I don't that is the one.I want the row total, not column total. Suppose I have fields Name,Jan,Feb upto Dec, and I enter the name and no. of hours worked by a person under these fields, then I want the total no. of hours worked by each person for the year. Sudha