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 was just wondering if any one had any tips or insider secrets on how to lower the size of a database and/or get it to run faster and more smoothly. I know you can split it but is there any other way? I'm using alot of macros and going from screen to screen there is sometimes a lag. I dont know much in the way of code but im willing to learn. Any links or advice on code how too's would be appreciated aswell...thanks alot I'd also like to say these posts have helped me a great deal and i cant wait until I am confident enough with Access to help out some other people.
I am experiencing an odd thing. The program that I have written in Access when I use it on my laptop the control tips do not work. When I use it on any other computer the control tips work fine, does anyone have any idea what the deal is?
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!!
I have recently been playing with exporting a query to a delimited text file and have learned some things along the way. Some of this is bound to be old-hat to some of you. However, I thought that it might be useful to post a summary of what I've learned for the benefit of others, like me, who may face some of the frustrations I've been dealing with.
Firstly, in order to export a query or table to a text format other than the default csv, you need to create what is called an 'export specification'. As has been mentioned elsewhere (http://www.access-programmers.co.uk/forums/showthread.php?t=59828&highlight=export+wizard)on this forum, you do this by clicking on the advanced button on the 'Export Wizard'. Pick the delimiter you prefer, click save as, and save the specification with a name that you can remember.
To use the specification in an export, you use the specification's name as the second argument in the DoCmd.TransferText method. (See access help for more detail)
However, things can go wrong!
Firstly, on some occasions, the export wizard fails to open thereby preventing you from accessing the specifications you have created or making new ones. This happened to me and it turns out that the reason was that some code I was running got interupted at one stage and DoCmd.Setwarnings was set to false when it happened. This prevents the export wizard opening for whatever reason.
The solution is to create a sub that sets DoCmd.Setwarnings to True and run it. (Credit to BobLarson here (http://www.access-programmers.co.uk/forums/showthread.php?t=37696&highlight=export+wizard))
Secondly, you may get an error message saying 'too few parameters...expected #' where the # represents a number.
This problem seems to be caused by using a control in a form as a criteria in a query that you're trying to export.
One solution is to simply get rid of the form references in the criteria of the query (Credit Jon K (http://www.access-programmers.co.uk/forums/showthread.php?t=54237&highlight=export+wizard))
But if you need to keep the criteria reference like I did, the best workaround I came up with was to enclose each reference to a form control in the criteria of the query with an Eval("").
Thus, if I were wanting to use a control called 'mycontrol' on a form called 'myform' as a criteria, I would use Eval("[Forms]![myform]![mycontrol]") instead of just [Forms]![myform]![mycontrol] in the criteria line of the query.
Thirdly, you may encounter an error that helpfully says 'Invalid Argument'.
This is due to the presence of a numerical field in the table/query that has its fieldsize property set to 'Decimal'. This is a known bug with access 2000 and solutions can be found at Microsoft's knowledge base (http://support.microsoft.com/kb/263946).
In my case, I resorted to changing the fieldsize properties to Double instead of decimal, and deleted/re-created my export specification after the change and this solved the problem for me.
I hope this post is helpful for others. Cheers! :D
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??
I am about to start a project where I must link an Access front-end database to an Oracle backend. I have about a year of Access development behind me now, and now here is the next challenge.
What I have to do is create analyses of data and output the data mainly in the form of diagrams (i.e. graphs or charts). I have seen how this can be done with Automation in Access in a book by Alison Balter (Mastering Access 2000 Development), by controlling the Excel object etc.
Here are my 2 questions:
1. I am considering buying another book on Access now, something that will contain more examples/methods for presenting information as a graph with the help of Excel. Should I stick to buying an Access book, or should I look into getting something that is more Excel programming oriented, i.e. something like an “Excel programmers compendium”? Any recommendations/tips to get me started would be appreciated.
2. The users want the graphs that I produce to be saved as a .PDF automatically at the push of a button in the Access GUI. How is this done? Do I need special software, or can I use something like PDFWriter to automatically convert the Excel graphs into .PDF’s?
Thanks in advance for the tips and have a nice day! :)
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?
Hi, I am new here and need some help with MS Access97. I am looking for a more convenient way to join tables together. The usual way that I know is to drag the field(s) in one table and drop it in the other table (within the relationship window).
Is there any other way that I can do the same without drag and drop (keyboard instead of mouse)? This is real problem to me when I need to do some modification and have lots of tables scatter across few pages and the vertical scroll of the Relationship window is not working properly with drag & drop technique.
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?
My combobox is not working correctly. When I select one of the dropdown items in the combobox it always defaults to the 1st item on the list. I want to be able to select any of the dropdown items on the list.
I have a Form that links to a List Box which pulls from a combined (concatenated?) list. The list it is pulling from appears as follows: SELECT [Rank]+" "+[Last Name]+", "+[First Name] AS Expr1 FROM [T_Personnel Information]; My issue is that the Field in the Form that pulls from the Field in the Table defaults to the first name on the list when left blank, where as I want it to default to a blank value unless I select a name from the list.
