Monday, December 17, 2007

Converting to Access 2003

Converting or upsizing your older Access database to Access 2003, Microsoft helps you out with this tool

Tuesday, December 11, 2007

CurrentDb.Properties("AppTitle")

If you have code that refers to

CurrentDb.Properties("AppTitle")

you will need to fill in the Application Title in the menu Tools ~ Startup

Thursday, December 06, 2007

Jeff Conrad talks Access 2007

Jeff Conrad put together the following resources for Access 2007 junkies

Hi everyone,I'd like to let you all know of some new content I've added to my Access 2007 site.

This page http://accessjunkie.com/helplinks2007.aspx lists any new Help articles concerning Access 2007 posted on Office Online along with the date of release. It also lists any recently revised articles as well. Currently I have ~40 articles listed. I'll continue to update this as new articles get posted.

This page http://accessjunkie.com/faq2007.aspx is my new Access 2007 FAQ . I'm really proud of this one. It includes links to pages discussing the most frequently asked questions I'm seeing in the newsgroups and online forums. I've been wanting to put something like this together for a very long time, but coming to work at Microsoft put a little "dent" in my free time. :-) I've been slowly chipping away with adding content for many months.I will be adding a lot more pages and content to the FAQ as time progresses, but I feel it's finally at a point in time where there is enough content to make it live. Right now there are 50 questions/pages devoted to common questions/issues. Most of the pages include screenshots so people can easily see what I'm talking about.

I think people in this group will find these two pages of most interest: http://accessjunkie.com/faq_13.aspx
http://accessjunkie.com/faq_30.aspx

In the regular newsgroups, these two seem to be the most asked questions:
http://accessjunkie.com/faq_01.aspx
http://accessjunkie.com/faq_02.aspx

I hope they help you when you're assisting people with 2007 questions. Feel free to point people to them; the pages are now live!--

Jeff Conrad - Access Junkie

Wednesday, December 05, 2007

Renaming a query

Recently I had to build a monster stack of union queries that were all based on a single query (query1). In this case I had to have two different versions of query1 for different purposes. So I needed to rename a query. To do these two renames is simple in vba

currentdb.QueryDefs("query1").Name = "queryY"
currentdb.QueryDefs("queryX").Name = "query1"