Search results

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

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

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?

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

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

Hi, How do I calculate the sum of certain fields in a row on the form Sudha

I have two subforms(not nested) on a main form. Both the subforms have a total field(=sum[(fieldname)]). Now I want the sum of these two totals on my main form. Please help. Sudha

Hi, I have a table with details of week no and the hours worked during that week. On a form I have two combo Boxes that are used to select the "Start Week" and "End Week".Suppose the user selects 46 and 52 then I want the all the weeks from 46 to 52 to be displayed as headings, and the hours...

Hi, I have a table with details of week no and the hours worked during that week. On a form I have two combo Boxes that are used to select the "Start Week" and "End Week".Suppose the user selects 46 and 52 then I want the all the weeks from 46 to 52 to be displayed as headings, and the hours...

I have created a form for a query. Now I want the input from the form to be the parameter criteria for the query and then display the result in the same form.