Search results

i have a command button, and i need it to close not only the form but close the whole application (access)... thanks for your help

in txtReferenceID the individual id for each order is held (invoice number). in txtTotal this is a text box on the subform of the order form, which holds the Total Cost of each order line.

by the way... the box i am trying to DSum is a currency field

doesnt seem to work.....? the box still appears blank. when i go to a new record, the box then has the msg '#Error'. are there any ideas on how i can solve this problem

i seem to be having problems with a dsum which is in a subform. the layout of my database is as follows: all forms are subforms on the switchboard. each subform is located within a tab. in the order form i have a dsum formula...

can anbody help me with this form... its the order form but looks too complex. how can i make it more simple? i need all of the fields that are present and its causing me a problem as its to complex. thanks!

hi i have a fairly complex problem which probably has a really simple answer, but i cant figure it out. ok..i have a switchboard, in which there is a tab. each page in the tab has a subform. the thing i need to happen is when the user clicks a button on the switchboard, it goes to a new record...

thanks guys...works perfectly!

im creating a search form, where the user can search for customers by their ID, first name and last name. i have a option group at the moment, consisting of 3 options..Customer ID, LastName and FirstName. if CustomerID is sleected i want the systsme to search for the ID only...simelar to if the...

new problem hey thanks for the help it worked...but theres 1 more thing... how can i got to a new record in a subform? the subfrm is located in a page, this is what i have right now but it doesnt work. Private Sub cmdAddCustomer_Click() Customer.SetFocus DoCmd.GoToRecord acDataForm...

try the if is null function on the on current event of the form.. If IsNull[yourfield] Then [yourfield] = 0

hi iv built my form with a tab on it. it has several pages. but i dont know the code to go to a certain page once a button has been clicked. anyone have any ideas? thanks!

thank u very much dave...that template has helped a lot! one more thing...what would the coding be to open the splash screen when the database is opened??

hi, i was just wondering how i would go about making a splash screen for a dtabase im making... i have no idea of how to make one...the access help is no good. thanks in advance!

hi, i am adding a search form to my database. i need to be able to search for a customer--by ID or by surname, and also search for the invoice....again by invoice ID, or Customer ID. the thing is i have no idea on how to go about making the form, to make it as easy to use a possible, minimising...

hi im having problems with a subform... i have the subform in an order form for which u can add many products. each product has a stock number which must be changed when an order is added. for example order 1 product id= 1234 quantity = 2 stock = 8 because the subform can contain multiple...

i have a series of combo boxes on a form for which 2 need to be disabled.... combo 1 has to be entered in order for combo 2 to display its contents, which in turn is needed for a list box to display its contents. i need to be able to disable combo 2 until combo 1 is entered, and list 3 until...

=Sum([txtSubtotal]+[txtShippingCost])-[txtDiscount] i have entered this code as the control source of the field "GrandTotal" on my invoice form, for some reason it displays #Error. i have tried everything i can think of but cant get it to work? thanks for your help.

thanks Hayley!

i dont seem to be able to drag fields in a form onto a tab control. usually when you use a tab control it is highlighted, but i cant drag fields onto it. is there any way of doing it?? thanks in advance.