Search results

You can use a third-party form rescaling module or add-in to do this for you, or write the code yourself (because of the complexity, this is not recommended). A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site...

First create your table, then use the form wizard to create your form. Access will bind the table to the form so that data changes are saved automatically. To cancel a saved record, you have to navigate to the record (i.e.: find it), then delete it. Hope this helps, Peter De Baets Peter's...

I'm going to re-iterate what Pat said above. My suggestion is to just use autonumber, and do not rely on the value of the autonumber field to be anything meaningful. Good design would require that you just let your primary key field be a primary key, and that's it. If you want an ascending...

Don't do it! Sorry for the non-reply, but I must advise you to take a different approach. Don't put the calculated field in your table or your form. Instead, create a query based on your table. Then add your calculation as a new field in the query. Then use this query as the recordsource for...

This could be a memory/disk swapping issue. How much memory does your computer have? You can speed things up by creating an .mde file out of your database. Are you using Windows 2000 SP1? I've heard about a few performance issues with it related to Access 2000. I'm sure there are more things...

I'm guessing that your first form is maximized, then when your second form is closed, the first form is restored (not maximized)? If you want your first form to always be maximized, there a few things you can do. One good one is to put a "docmd.maximize" statement in your form's OnActivate...

Another form rescaling module (which I wrote) is called ShrinkerStretcher. A shareware/demo is available for download from: http://www.peterssoftware.com/ss.htm Thanks, Peter De Baets http://www.peterssoftware.com

We have a module that will do this for you. It's called ShrinkerStretcher and you can download a shareware/demo from: http://www.peterssoftware.com/ss.htm