Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access refer to Primary Index

Posted on 2011-03-17
3
Medium Priority
?
282 Views
Last Modified: 2012-05-11
I have a generic Audit utility.
I populate a text field with the formname and other data.

I was wondering if there was any way to refer to actual value of the "primary index" without knowing what the name of the index was.

I would like to be able to refer to the actual "primary index" value in my audit string.  (A sort of form.primaryindex function??)
(As I write this question I am becoming consious that a form could have multiple tables and therefore multiple "primary indexes".   Therefore my query may be impossible! ?)




0
Comment
Question by:Patrick O'Dea
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
AkAlan earned 1500 total points
ID: 35161226
Not sure what you are really needing here. If you include the primary key in the query, you can then use it as the control source for a text box.
0
 

Author Comment

by:Patrick O'Dea
ID: 35161250
Thanks AkAlan,

I have not expressed my query well.

In all honesty I have had a couple of glasses of wine ... and this query is a complex one!

I will award the points and close the query (for the moment!)
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 35161253
Thanks
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question