Search results for query: *

Create a form with all your required info in.... Then in form design view make sure you are using a wizard (I know!!!) and select a combo box from the Toolbox.. When the first page of the wizard appears Select the bottom option (Find a record on my form based on.....) Go through the process...

You need to compact your database.... Use menu item Tools.... Database Utilities and Compact and Repair Database. It might be adisable to make a copy of your databse first... just in case anything goes wrong Hope this helps

The way I achieve this is to use Windows Scheduled tasks... This will open your database at any time you want... All you have to do is to set a macro that runs your report when the Db is opened. Hope this helps

Would help if we new what you were writing that isnt working

Run your report from a query and enter the text Forms![Name OF FORM]![INDEX FIELD] into the criteria in the INDEX FIELD Column... This will then pick up the value from the current record in your form and open the relevant report. With your Open Report Button, use the wizard (I Know!!!) and go...

One solution would be to put the single table in a database by itself and link it into your application, that way you can copy the whole of your working databse without copying the table you dont want copied. Hope this helps

To autopopulate the date, Just put Now() as the default value for the text box. This will pick up the current system date. When you make another entry in the record the date will be set. As for the Index... That is more difficult. because you cannot increment the text... If you were doing AA1...

If you want more info in a Form view then used the value of the combo box as a filter to open a form with the appropriate record in it. i.e. Open the form with a query where you have used Forms!COMBO BOX!VALUE in the Query... The Form will then display your record. If you just want a table view...

In Menu.... Tools.. Options...Edit/Find. Use the Confirm check boxes to decide what warnings you want to see. If you want to do it by code let me know Hope this helps

You need to refresh the combo box when the value changes Use... ON Change event use the code Docmd.Requery "CONTROLNAME" You could also add this code to the Form's ONCURRENT event, this will requery the combo box on each new record Hope this helps

What you need is a Totals Query In the TOTAL: Row...Use Group By (Default) for your Category field ... and Sum for all the totals 1998($)for example.. To display your table for the sum of 1998($) in the column for that field write... 1998:1998($) .. This will change the title of your colummn...

To generate the code for your Email, define a macro using Send Object, complete all the entries then save it as a Module. This will generate the code for the Email itself. To use a Date from a Text box... you will have to decide how you want to activate the Email. You could use the OnClick...