By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

how to create an index in a table

P: 1
I use msaccess 97 and also msaccess 2013. I would program in a vba procedure 2 things:
first do a test if the table has the specefic index I would use.
In case no I would create in the procedure the needed index file.
How I progrfam that in vba?
Thanks
May 21 '14 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,240
Etienne,
Welcome to Bytes.com. Please keep in mind that the better job you do asking your questions the better responses you can get. You have asked a very general question and reference two very different versions of Access. Not a lot of folks here use '97 anymore but there are quite a few that used to so maybe you can get some good feedback about that version.

Here are some links to help you with 2013. They refer to the sample Access db, Northwind.mdb. You'll find that under the Help section of your Access program.
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

There's a lot of good examples in the sample DB. Study that and ask here for help with specific problems.

Jim
May 21 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.