Reset Access To Factory Defaults?

Is there a way to reset access to the out-of-the-box defaults?

View Replies


Right Click > New > Access DB Defaults To 00 Format In 03 - Version: 2003 (11.0)

Hi All,

From the desktop or a file explorer screen, if I right click and select "New">"Microsoft Office Access Application" it creates the new database in 2000 format. Yet in Access, when I go to "Tools">"Options">"Advanced">"Default File Format" it says "Access 2002-2003" Is there any way to force the right click behavior by default to create a Access 2003 format database?

Thanks, Colin.

Edited by: colinnwn on Thu Jun 8 13:04:28 EDT 2006.

View Replies View Related


Here you have the db for Access 97, it resets the autokeys just execute the module

View Replies View Related

Project: Factory Work Order ... Sub-Reports? - Version: Any Version

* See the attachment for a Work Order (WO) sample, it is a web page version of a Word doc (Prototype).
* The WO is for a (purchased) ERP system, uses SQL Server database. Cost for the vendor to modify the WO is prohibitive - we believe we can do it for less.

I'm trying to figure out a solution to use Access to print the WO. It's not going to be as easy as I first thought. Unless there is some functionality I don't know about, I don't see a way to manage the different layouts in each section. [I first thought I could generate each output line in VB, but, "columnar look and feel" and changing font weight has me stumped.] I can visualize each section of the WO containing up to 2 sub-reports - the information relevant to the section and then instructions. As you can see in the sample, the sub-reports differ among the sections.

* The page header part (above the double line) is easy. Don't need help with that part.

I haven't worked with sub-reports, so am not familiar with using them.

All suggestions / recommendations are welcome.

View Replies View Related

How To Reset Default Access - Version: 2003 (11.0)

Is there a way in Access/VBA to tell Windows which version of Access should be the default? I would like to reset the default to Access 97 when the user closes my Access 2003 database. Most of our dbs are 97 (yes, long story) and we don't want them to be confused after leaving the 2003 database because when they next try to open a 97 database it will launch 2003. Thanks!

View Replies View Related

Reset MS Access Error Checking (unbound Labels) - Version: 2003 (11.0)


I am trying to reset the MS Access inbuilt error checking so that it resets all the 'ignores', but I can't work out how to do it.

I have tried turning error checking off and on, but it doesn't do it. There must be a way, but I can't seem to locate it.... does anyone know?


View Replies View Related

Snapshot Defaults

I am having a problem with 3 pc's attached to our network but at a different campus. They have been complaining that the Snapshot Views of reports they are running are stopping the print queue by asking to load paper type 'bond' to the printer. I have checked the Snapshot Viewer printer settings on thoses machines and indeed they are defaulting to 'paper type - bond'. Setting the paper type to Plain or Unspecified will only print on that type for that instance. Is there anywhere to set the default paper type, i cannot find anything!!

View Replies View Related

Qbe Size Defaults

Is there a way to change the default size of the design view query window, the QBE grid, and the table diagrams?

I find that almost every single time I create a new query, I have to drag the window bottom down, drag the pane divider down, and resize all the tables.

The whole point of QBE is that it is supposed to be a visual tool, right? Shouldn't a visual tool default to showing more? After years of Access development and creating many thousands of queries, I'm still really frustrated by this.

Does anyone know if there are registry settings, AccessObject properties, or some other means of changing the defaults for these features?


View Replies View Related

Kens Tips - Defaults

To set the default values for controls, select the control on the tool bar and press F4. The default value properties list will appear. I like to turn off all of the 3D stuff by resetting some the values like 'Special Effect', 'Border Style', etc. This way I don't have to manually change them after the fact...

Thanks Ken have done this - however when I go off and word with a differant mdb file then come back to the original which I had open when I entered the defaults - the defaults have disappeared.

Any suggestions.


View Replies View Related

Option Group Defaults

i have set up option groups (using the wizard) with Yes=1, No = 2 and N/A =3 with the default set to 3. After creating the option groups the default does not default even though the properties box clearly shows the default being set to 3 - can anyone suggest why this would be?

View Replies View Related

Combo Box Defaults Without A Default Set

I have combo boxes that have all been created using the wizard with the options Yes, No and Not Applicable. There is no default set but they default to the second entered option ("No") every time. I have created the form a second time in the hope this would do something but to no avail. Any ideas??

View Replies View Related

Changing Field Format Defaults

Does anyone know how to change a field FORMAT default? I am creating lots of tables with lots of number format fields. I don't, however, want a zero default value (or any default value for that matter) for all of these fields. I can go in and delete them manually, but that seems like a backward way of doing things. Does anyone know how to elimate that default value from the format of a number field in general?


View Replies View Related

Opening Defaults - Version: 2003 (11.0)

I have a default switchboard that opens up when the database is first opened.

Is it possible to have a report open before that switchboard opens.

I have a word doc that contains intructions I would like to have open before they arrive at the switchboard.

View Replies View Related

How Are Defaults Set For Menubars - Version: 2003 (11.0)

Hi all,

I'm running into something that probably has a simple answer. I'm opening a database that I've created that does not have any code with which to hide menubars. I open a table in design view. I don't get the menu bar that allows me to save the changes (the Table Design menu bar), only the default (Menu Bar). I think in another db I opened that this toolbar was disabled, and Access seems to apply this setting to all future dbs I open.

I have to go into Customize, Table Design toolbar, choose properties, then restore defaults. This would be a pain to do for each and every toolbar that's been disabled each time I run the other db app, then come back to this one.

So my question.... is there an overall setting in the MS Access 2003 app that will get ALL the default toolbars back to their original setting?

Thanks for any help!

View Replies View Related

Multi Select & Defaults - Version: 2003 (11.0)

I have a form with several list boxes, and I have set the default property to "All" when the form is opened. However on some of these list boxes I want the ability to multiselect values. When I change the Multi Select property to 'simple' or 'extended', it will allow me to select multiple items, but running my query returns no data. If I go and deselect the items that I multiselected and go back and click "All", I still get no data. If I go back and set the Multi Select property to 'none', then my query runs fine, either giving me all of my data if I select "All" or the pertinent data if I select just one item. I figure it must be something wrong with my query, and perhaps the properties I have set. Here is my query.



I want my default to be "All" when the form is opened, but have the ability to Select, for example, Harpo and Zeppo, then run my query to get just the pertinent data for Harpo and Zeppo.

Thanks for your help……..ElPhoenix

View Replies View Related

Numeric Field Defaults To Zero - Version: 2002 (10.0) XP

Is there a way to turn this off? It is making my life miserable.

View Replies View Related

Restore Startup Defaults - Version: 2003 (11.0)

is there a way to restore the default settings when access starts up? i disabled all the toolbars to see how it would look on startup, but now i cant figure out how to get them back

View Replies View Related

Updating Combo Box Defaults With Optionbox And/or Check Box For A Table

Hi All,

I am wondering if it is possible using VBA to update using either an option group or check boxes as shown in the frmDefaultValue in the attached file to update two tables tblLabelNumber and tblMediaType.

The form frmMedia contains two combo boxes. I am trying to use the form frmDefaultValue with an option group and check boxes as shown as not sure what is the best method here to update the values in the two table tblLabelNumber & tblMediaType at the push of a button Update as in the form?

Look forward to any comments on this.


View Replies View Related

Print Preview For Reports Defaults To 'fit', Instead Of 100% - Version: 2003 (11.0)


We just recently upgraded to Access 2003 but our database is still an Access 2000 database. Now when all of the reports are previewed, they default to 'Fit', which makes the data unreadable. A user has to then select 100% each time a report is previewed. (It happens with all our printers.)

Is there a setting in Access 2003 to set the preview default to '100%'? I haven't been able to find one!


View Replies View Related

Edit - Find Command Defaults - Version: 2002 (10.0) XP


I have a database that allows the user to search records on a continuous form. I added a button to the form that executes the standard Find command. Some of the users also use <Ctrl><F>. They've been asking if I can default some of the items on the Find command, such as the "Match Case" and "Match" (whole field, any part of field, etc.).

I haven't come across a way to do this, and I'm sure there is one. Any thoughts?


View Replies View Related

Insert Object Dialog Defaults - Version: 2003 (11.0)

I was just wondering if it is possible to set the defaults for the Insert Object dialog box.
Currently I have a button that (in addition to other code) runs:

DoCmd.RunCommand acCmdInsertObject

This opens the Insert Object dialog, however...

I would like to be able to set it so that the Dialog defaults to the Create from File radio as well as the Link checkbox as checked.

Any help would be be greatly appreciated :-)

View Replies View Related

I Keep Losing My Defaults; Page Margins, Windows In Taskbar..etc - Version: 2000 (9.0)

Hi All,

I think that this may be something that the network folks are running ????
I always set my databases to have default report margins of .25 and I turn off the Windows in Taskbar option too. Well every couple of days it seems that those options....along with some others I may not be aware of ??...are being reset.....

Any thoughts or suggestions ??? It's not the end of the world but it is aggravating....

View Replies View Related

Defaults For "Find And Replace" - Version: 2003 (11.0)

I do a lot of searching in my form view based on last names. I wish that when the "Find and Replace" function could be activated so that it would default to the "Last Name" field in the "Look In" window and also to "Any Part of Field" in the "Match" window. Any ideas out there?

View Replies View Related

Reset All

This forum was such a help before, I should post my latest dilemma.
I have created a Certification form. This form will allow tracking of a submitted form by Department. Upon receving the form the person tracking the forms selects the checkbox and it populates the date validated for the department. When all Departments have validated the Certfied button will be selected at the top of the page and set the date for all the departmental forms in the database. In 1 year they will select clear all and it will clear the fields and reset the tables to null the cycle begins again.
I have a form that contains 30 checkboxes Caption " Validated" (1 for each department )and 30 text boxes Caption "Certified Date "(This will set the current date once clicked for all records. , Reset all button ( Will clear both the checkboxes and validation departments.

My dilemma each department has at least 30 forms, I do not want to write a huge convulated group of vb and spells out each department. I simply want to select the department button and it updates the field. Has anyone done a similar update or perhaps there is an easier method. I have reviewed the forum for something similar.
Thanks in Advance

View Replies View Related


In my DataBase I want to reset the the records back to the first record. The only way to reset is to exit the form tehn go back in. Is there another way?

Please help this MS Access beginner

View Replies View Related

Autonumber Reset


I have a autonumber function in my form, but i have deleted all the records and want to start again but the autonumber has not reset back to 1, is there a way to do this??

Thanks in advance.

View Replies View Related

Reset Primary Key

Hi all,

Ive written a program in .net and am currently using an access db as the backend.
In the db I had 200 test records which i deleted to get the db ready for deployment. When i add a new record now the primary key on my "booking" table carries on from the old test number so 201.

Can I resest this so it starts back at #1 as once the db gets updated, the program i wrote then takes the data and updates the accounting system and uses the primary key as the invoice number and so I would like to start at 1.

Thanks in advance


View Replies View Related

Reset Tables

How can I reset my Tables without affecting the Relationships


View Replies View Related

Reset Identity Key

Hi there....

How can i reset the identity key?


View Replies View Related

How Do You Reset The Menu Bar?

I was in the startup options and unchecked a couple of toolbar boxe and now I dont have a full menu any more.

Please help

View Replies View Related

My Autonumber Has Reset To 1 ?

I have an inventory split database. It has been working fine. I noticed when I try to enter a new record, it will not let me as it would create a duplicate record. It has actually started to use the autonumbers in the pk again reusing numbers that already exist starting at 1 and moving up sequentially.

How can I make it continue from where it left off or at least not duplicate any of the existing records. This database has many tables with a bunch of relationships.
Bill Hesson :confused:

View Replies View Related

Reset Autonumber

just a small question. I have a database that assigns a unique 'audit id' to each entry. the ID is in the form of : DEA-[client prefix]-autonumber. Everything is working fine except the autonumber part. I have gaps in the numeric sequence. Ex: DEA-AAA-1, DEA-AAA-2, DEA-AAA-8, DEA-ABC17, etc.

is there a way that I can reset this autonumber so that it may look like this:
Ex: DEA-AAA-1, DEA-AAA-2, DEA-AAA-3, DEA-ABC4, etc.

View Replies View Related

Value Reset On January 1

I'm building a form for a clinic.

Insured patients have deductables and copays that usually reset on January 1st.

To be clear, a deductable of $500 is reduced each time the patient pays, but jumps back to $500 at the beginning of the next year.

The table containing patient records has a deductable field, where the form gets the initial value. I'll be making a running calculation of how much remains after each visit, but that calculation has to start over again each year.

Can anyone suggest code to do this or point me at something similar?

View Replies View Related

Copyrights 2005-15, All rights reserved