Topics Search

Question access 2010 macro & open form

Question access 2010 macro & open form
Views: 44
I'm trying to open a new form via double-click on a cell of a sub-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:
Open Form
Form Name: F_New_Non_Hedged_Share_Class
View: Form
Filtername:
Where condition:
Data Mode:
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
Sponsored Links:

Similar posts...

 

access runtime 2010 dont show some forms content

access runtime 2010 dont show some forms content Icon
I have a question that I have implemented database with access runtime 2010 I have a navigation form opens up which provides buttons to open different forms & reports. but I cannot open some of the forms in runtime although title heading appears but other content just goes blank, it has subforms in it . . some forms opens and some reports as well but some form just doesn't, and on the notification bar it asks for a save as?
 

Access 2010 Default Macro Behaviour

Access 2010 Default Macro Behaviour Icon
When I use a form wizard in Access 2010 and create a button, it defaults to creating a macro to perform that button's action. How can I change this so it never creates a macro but it builts VBA
 

Cross version compatibility between Access 2010 and Access 2007

Cross version compatibility between Access 2010 and Access 2007 Icon
Access 2010 brings you many new features (Data Macros, Calculated Columns, etc.) that Access 2007 does not understand. If Access 2007 goes ahead and open a Database created/modified in 2010, it will ignore these new features and might even cause data loss or corrupt business logic. For example, a data macro validation rule that is forced in 2010 but ignored in 2007, this can cause data inconsistency. To prevent that from happening, we implemented the feature to block certain databases to open in Access 2007 after it’s modified in 2010, or open it as read-only in 2007.
 

Access 2010 - Creating a Data Macro

Access 2010 - Creating a Data Macro Icon
Office 2010 Developer Training Course > Access 2010 > Building Solutions with Access 2010 Lab using the Contacts Web Database template.

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.
 

Access 2010 to Word 2010

Access 2010 to Word 2010 Icon
I am having a problem with creating a button in access that will open a word doc and populate fields in it. Seems easy right? There's a million tutorials right? No. not right.

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.
 

Input date for a macro

Input date for a macro Icon
I have just upgraded from Access 2002 to 2010. I want to write a macro to set the default value for a field in a form, the value is a date. But I can't find the InputBox in the list of commands for a macro .

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!
 

2010 VBA "do while" code in a macro

2010 VBA "do while" code in a macro Icon
In Access 2010, want to run perform a "do while" loop in a macro. I understand VBA is the way to do this. So, I think I want to run a VBA script in a macro.

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.
 

How to you tell Access 2010 to run VBA code?

How to you tell Access 2010 to run VBA code? Icon
I started with creating a Macro in Access 2010 which is very repetitious (open a query, update and close. move to next query). I used the Macro builder to make sure I got the right code commands and then converted to VBA because it is my understanding running code is better than running a macro (but I still haven't seen anything thatexplains to me why that is so).
 

Access 2010 to Access 2003

Access 2010 to Access 2003 Icon
I have been reading for what seems like forever but haven't seen the exact words I need to in order to make a decision. I am trying to decide between Office 2007 and Office 2010. I am wondering if Access 2010 can open, use, and save Access 2003 *.mdb file format.

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.

Migration considerations
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?
 

SetWarnings macro command in Access 2010

SetWarnings macro command in Access 2010 Icon
In Access 2010, while building a macro in design view, the SetWarnings action command is not available in the "Add New Action" drop-down menu. I can import a macro from an earlier version of Access and copy/paste the SetWarnings into my new macro, Is there a different command in Access 2010 or am I missingsomething?