Tips Or Hints??
Dec 6, 2005
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.
Thanks again
Brad
View Replies
Oct 25, 2005
hey,
does anyone have any links i could use to read up on queries?
im very new to Access and i want to create some basic msg boxes and commands etc...
thank you.
View 1 Replies
View Related
Jan 4, 2007
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.
Ta
View 3 Replies
View Related
May 18, 2006
Hi,
Does anyone know of any good sites where they are tutorials etc on how to create advanced functioning forms.
regards
View 2 Replies
View Related
Dec 30, 2004
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?
View 1 Replies
View Related
Jan 4, 2007
This is not a question.
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
View 1 Replies
View Related
Jun 26, 2005
Hello,
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! :)
J
View 3 Replies
View Related
May 16, 2005
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.
Please help. Many thanks! :)
View 2 Replies
View Related
