Search results

I have turned off the standard navigation buttons so i can produce my own custom nav. bar out of command buttons. The problem i have is that when you turn the nav. buttons off you have no way of scrolling through results from a form filter. The number of records within the form is also no longer...

thanks for your help Alex

I need the all of my dates to be entered in the format . dd/mm/yyyy, and be displayed in Medium date format. However whenever i set the date format to Medium i can only enter the day in mm-dd-yyyy format. Is it possible to change this. (I have tried to use an input mask of dd-mm-yyyy but it...

why is it not recommended mate?

I have a text box which is bound to an underlying table. I used code written in vba to make this box fill from the data of one in a subform within the main. The answer is shown correctly in the text box and correctly updates the underlying table but only after you click in the text box and then...

you could try using a validation rule (with the same perameter as the input mask) as well as the input mask and then typing the error message you want to appear in the validation text. (Table in design view - select item row - general tab at bottom of screen)

try a search at www.download.com for BIG CURSOR might help? Alex

Try checking out the indexes in the underlying table for your subform. Open the table Select design view From the top menu bar select View, Indexes Here will be a list of all Sort details for your data. If you have millions of indexes you may have a problem. Alex

when you create the form using the form wizard the second screen you are presented with asks 'How do you want to view your data?' If you look to the bottom right corner of the window you will see two dot. buttons (Form with subform(s) and Linked forms) Select linked forms and the finished form...

You might want to try altering the type of query. The default query type is a select query which will view the underlying data but not allow you to change it. Try selecting an update query or an append qery and see if you have better results.

I have also created a sales order page which is used to record all the information from the order. It is in the format of Main Form - Client Details (Address & Delivery Address etc.) Subform1 - Orders (Invoice Number, sales person etc.) Subform2 - Order Details (Ind. product details i.e...

I have created a text box on a form which sums a contract value from the values in a subform. It all works correctly and me the right answer. However i need this figure to be then stored in the underlying table for use in related queiries and forms. Is this possible? Please Help Alex

I have the problem of needing to hide a text box if it contains no value but appear if the control source equation creates a value to put in it. How would i go about doing this. Thanks Alex

Hello again my friends more problems i am afraid. Is it possible to have a yes/no type switch in my main order form which when changed will alter the type of equation used in the subform datasheet. If this is possible how do i go about doing it?. Thanks for all your help Alex

I need to create a section which ammends underlying stock levels in my product table when and order is placed in my order form. I am currently using a Main form (client details) and 2 subforms (orders & order details) as my order form. Is this possible or am i asking too much from access...

Hi, I have just started writing with ms access and i have come up against a couple of probs, Firstly, how do you total a column in a subform? i.e. all the line totals added together to produce a grand total. Secondly, i know it is possible to use a combo box to lookup a row of results from a...