Search results

how do i cant the number of rows/ records in a table and display it as a number in the report?

is it possible to add a mask to the input? how do i display a error message if no records are found?

my report is based on a query i was just wondering how do i get it to prompt

How do i make a report prompt a start date and finish date based on a table field to which it should pull data/rows from?

i forgot about the option group! cheers m8 it worked fine :)

what do you mean bound? all ive got atm are tick boxes on a form. Depending on which tick box they check i want it to take a value from a textfield and copy it to another. Whats the code to clear a tickbox and set it to empty? Also how do i group together say 6 tick boxes so only 1 of them...

How do i reset tick boxes on forms when you go to the next record? Also in VBA whats the code to checking if a tic box has been ticked or not? can i use the If tickbox is Null ? Or do i use tickbox = true (or false?)

=IIf([priceBoxDifference1]=0,"0%",[priceBoxDifference1]/[NettValue]) Figured it out so it now displays 0% :)

doesnt work still displaying same error :/

Is there a way to hide #Div/0! error when no data has been entered for the calc to work out? i rather just have nothing appear and then a figure when numbers are entered.

nvm i figured it out, you have to change the record source on the form for it to store :)

it seems to work for combo boxes, i generate a list of items and store it in a field. MS Access asks me where i want to store the selected value, was wondering if there was something similar for form fields?

i need the data to generate reports of, some calculations cannot be worked out on the form because they require user input/ choices

How do i store form fields into a table? on my form i have text boxes which work out calculations but i dont know how to store them. Does anyone have any ideas?

Where does access store the values and please can u look at my Dlookup?

the dlookup command will work

Hmm another problem is how do i store the values in the drop down box?

=DLookUp("[PPP]","[tblTerm]","tblTerm!Term=[cboTerm]") All i want is the PPP of the term selected in the box above, only problem is there are many levels of combo boxes :/

my code i think is wrong =DLookUp([PPP],[tblTerm],[tboPPP]=[cboTerm]) so it looks up PPP from table Term and makes the text box PPP = PPP in table Term based on the combo box Term. ?

Is it possible to do a lookup on the last level of a combo box? at the moment i have 3 levels, the last level displays a range of dates (terms) and i want it to look up all the values for that one term (in other words all the data from that one row). Is it possible? the term used in the combo...