Search results for query: *

Kobe1, That is what the Report Footer is for. It can total the amounts in any fields in Detail sections or Group Header/Footer sections. In one of your Group Footers place the "Sub-Total", in the Report Footer place the "Total Amount". The cool part of this is you can have...

Korngeek, No you don't have to disconnect any linked tables but forms etc. that are connected must be closed. The routine I use doesn't explicitly check for success of the compact process (it doesn't open the compacted db before renaming it as the original). My routine compacts datafile into a...

Backend compact, You must disconnect the Front-end completely from the back-end, no forms or tables etc running. You can still run the code from your Front-end. All you have to do is point to the back-end datafile and compact it "DBEngine.CompactDatabase". If the back-end file is...

Hi Fred, You need to analyze what you are trying to accomplish! I think you need to re-design your form not the combo-box. aflat

Hi Tom, Try using the duplicate record constant "3022". In the save icon on your form, place the following type of code in the error event. Err_cmdSaveRecord_Click: If Err.Number = 3022 Then Beep MsgBox "You are trying to add a record that matches a...

Hi Paul, This is a known quirk with Access subforms. If you look and check closely you will find that Access sets the focus to the subform field that last had focus the last time that the subform had focus. Try it, click in the second tab order field in subform, then click back to main form and...

If your table is named "Vehicles" and the field you suggested is named, "DATE BOUGHT". Your sql query should look like this: SELECT Vehicles.[DATE BOUGHT], DateDiff("yyyy",[DATE BOUGHT],Date()) AS Over10Years FROM Vehicles WHERE (((DateDiff("yyyy",[DATE...

Yes there is something to be done to any Form that you have already used the combo-box on. Because you have made changes to a look-up in your Table design, after placing controls on one or more forms, any controls on these forms based on your old Table design will not reflect the "new&quot...

To be informative and gracefull, notify user that they have changed data on the form and may not Close form until saving or rejecting changes. Your Save button saves the data and allows record validation, force your users to use it! Close button should only close when you want it to! Do a Close...

A possible limitation or bug I encountered in my application. When exporting data from an MS Access 2000 App through code to an Excel (8) file, (a query or table, doesn't seem to matter) via transferspreadsheet command, there seems to be a limit on the character length of the file name for the...