Question access 2010 macro & open form
I want the form that is opened via the double click to display the record of the line that I double-clicked.
It works fine with this code:
Private Sub ID_DblClick(Cancel As Integer) DoCmd.OpenForm "F_New_Non_Hedged_Share_Class", , , "[ID] = " & Me!ID End Sub
However, since I'm trying not too much vba code, i'd like to setup that kind of thing via access 2010 macro.
So I have:
Form Name: F_New_Non_Hedged_Share_Class
Windows Mode: Normal
Question: I'm assuming that I need to update the "where condition", but what should I put? I tried different things, ie. [ID]=[ID], etc - but without success
fyi: the dbl click is not on the ID field of the sub-form but an other field. I'm assuming this doesn't change anything
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I'm at Exercise 4: Creating a Data Macro and for whatever reason my macro is not working at all.
I created the macro and confirmed it matched to the guide and I had no errors when I saved it, so that has to count for something.
The macro is suppose to be invoked when the 'Status' variable is "Offer Outstanding" more than once in the database.
Yet I can select it multiple times without any instances of the macro displaying any warning message as it should.
I have done a lot of research on this and have yet to be successful. I am pretty familiar with access, and and very familiar with word mail merge, but due to the frequency of needing tocreate these letters I am hoping to streamline the process to the click of a button each time.
The issue is that the form I have open in access is populated with the data is opened using a "find Group" query, that has a criteria "Like "*" & [Group Name or Keywords?] & "*"" for group name.
I can create a macro to open the mail merge doc, however, when I try to create the mail merge doc to open the "find Group" query is empty and I cannot include any fields.
I have even gone so far as to experimented with including report type field calls to access the form directly (eg =[Forms]![Find Groups]![Group Name]) and nothing.
I am about read to throw my computer off the bridge and join a nice Amish community.
but have usually been able to write my own macro's before . I'm just having a bit of trouble working out macrosin Access 2010 are written!
This Macro runs against a Form that has a SubFrom (MainForm named "Expense ID" & SubForm, "Expense"). Macro is initiated by pressing a button.
I would like help with some VBA code showing how to perform the following:
1. Evaluate a field ("Activity") in the first record of Subform ("Expense") against condition "Is not Null".
2. If condition is true, set value of another field ("Post") in the same SubForm record to "1".
3. Move to next record and repeat steps 1 & 2 until all Subform records are evaluated.
4. Return to macro that initiated the VBA script to perform the next action in the macro.
I have found the following quote and when reading its suggestion it would lead me to believe it would but then there is that little warning that "Because Access 2010 has many similarities with Office Access 2007, such as the same native file format," I'm not totally convinced.
When you plan a migration to Access 2010, changed, and removed for Access 2010. Because Access 2010 has many similarities with Office Access 2007, such as the samenative file format, you can also review and use the existing migration documentation for Office Access 2007 when you migrate to Access 2010.
So my question is can Access 2010 open, use, and save databases in the Office 2003 file format?