Topics Search

Question access 2010 macro & open form

Question access 2010 macro & open form
Views: 42
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
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...


Every Data Base I create gets corrupted

Every Data Base I create gets corrupted Icon
Using access 2010

I can code for hours, create forms, queries, what ever I want.

I worked on this application all day without issue. Open & closed it maybe 30 times.

I was just finishing up and all I did was create a autoexe macro to open a specified form when starting up.

Now I get a message saying that access has experienced a problem and needs to close.

It will ask me if I want to compact & repair and try to open again but I get the same error on any backup.

This has happened on every application I have written this week. (actually this same one 3 times)

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?

Importing Forms Question

Importing Forms Question Icon
Recently imported some forms into Access 2010 from the old version of the program we're updating, the old version was made in Access 2003.

A macro was present in the old version that didn't import in, but it still tries to run it but I cannot find where it is actually being called.

Also, the form constantly prompts for a value from a form that is in no way associated with the imported form.

So two problems:

Imported a form from Access 2003, macro tries to run that isn't in this version, can't find where it's calling it
Form keeps promptimg for a value from a separate form that has nothing to do with the current form

Any advice on where to look for the macro or to stop it from being called? All these prompts and errors happen before it gets to the Form Load or On Open event. Is there another event that happens before those?

Form After Open Event ?

Form After Open Event ? Icon
Forum, access 2010 accdb.

I have a question to ask the Operater subject to what data is in a Form Control.

Problem is, if I put the code in the Form Current Event, the question is asked before the form is displayed

Is there an Event that is "last" like an After Open Event

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.

Close Form Macro

Close Form Macro Icon
I am a new Access user and have Access 2010. I have recently started working for myself and have created a Client/Work database using only the Access Wizards (I have no clue about modules etc) I have created an opening Welcome Form that opens via an autoexec macro. I wanted this form to close on timer and for another form to open. My problemis that whilst I have created a macro that on timer opens the new form, but I cannot find anywhere a CloseForm macro action. The nearest I have found is a RunMenuCommand action of "Close", but that doesn't seem to work

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 Macro

Access 2010 Macro Icon
I have an MS Access 2010 Database that will be run @ 6:00 AM Automatically. The Autoexec Macro has been created. the purpose of the Macro is to update a local table with data from SQL Server. In previous versions of Access I used setwarnings = off to accomplish this without user intervention. However in MS Access 2010 I don't find that option. Anybody know where it is or how I can accomplish this

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.