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?
Edited by: colinnwn on Thu Jun 8 13:04:28 EDT 2006.
* 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.
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!
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!!
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?
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.
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?
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??
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?
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?
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 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?
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!
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?
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....
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?
Hello, 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 Angel
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.
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. Thanks! Bill Hesson :confused:
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.
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?