Topics Search

VBA Code for buttons, Access 2010

VBA Code for buttons, Access 2010
Views: 127
In using this new version of Access, I have found that when creating buttons, Access no longer uses vba codebehind to handle all the dirty work - rather, it seems Microsoft is forcing me to use the upgraded (and very nice I must say) Macro builder.

This is fine for all the simple tasks, but what I have myself into is a little more complex than the Macro builder is ready tohandle I think.

Before, when I created a button, not a Macro. I am trying to build the following button types:

Button 1 - Update a Field in a table, Save form, Close form
Button 2 - Update a field in a table, save form, new record
Button 3 - Update a field in a table, save form, print report, close form . and so on and so forth.

I used to put 3 or 4 buttons on the form, then copy and paste the generated vba in the correct order in a single button, and delete the dummy buttons. But now it seems as the basicfunctions are built using an embedded macro, and when that is combined with VBA, Access must choose between one or the other, rendering my button useless.

Is there a setting in 2010 that will change the way buttons are created in that VBA is used by default instead of macros?
Sponsored Links:

Similar posts...


VBA code from Access 2003 not working in Access 2010

VBA code from Access 2003 not working in Access 2010 Icon
I have been working on converting an old Access database from version 2003 to 2010. I had some minor success with using Access 2007 to assist with part of the conversion. The database links to, updates and creates Excel spreadsheets.

until this week. So, I've been trying to convert to Access 2010, with the knowledge that the users forthis app are now converted to Ofc 2010 (so there won't be any 2003 or 2007 users trying to use this).

The old app had several buttons for the users to update and create spreadsheets from a protected SQL server. Now, when they try to use the buttons (specifically, an "update" button) the coding stops.

I think I'm missing some kind of add-in or something, but can't figure out what it is or where it should be.

Here's the first part of the code, where it stops:
The debugger stops at the very first line, Access does not show me the usual prompts if I try to duplicate the second line of code. I think thesecond line is what is actually stopping this.

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).

Depolying ACCESS 2010 runtime

Depolying ACCESS 2010 runtime Icon
The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes code from modules, forms and reports.

You should back up your database before attempting to open the database and delete the VBA project.

My developing environment is Office 2007 ACCESS 2010. My runtime environment is Office 2007 RUNTIME ACCESS 2010.

Both ACCESS Development and Runtime are under SP1 32 bit

create a calendar from scratch using vba in access 2010?

create a calendar from scratch using vba in access 2010? Icon
I would like to create a similar scheduling system using access vba based on the link below. Is it possible to create such a system on ms access 2010. I know this can be achieved on access 2007, but I'm not sure that if I created it in access 2007 and then migrated it into access 2010 it will appear.

Is this possible to do and transpose it into access 2010? If so, how can thisbe done? Or can it be done programmatically via the date picker?[LINK]

Unable to open code window

Unable to open code window Icon
With both Access 2007 and 2010 I am unable to open the VBA code editor. In each, I click Create >> Module or VBA Code and Access goes into a non-responding loop.

Compact & Repair in Access 2010 - vba not working

Compact & Repair in Access 2010 - vba not working Icon
I have the following code which is executed when the user chooses to close the database by clicking on the exit botton.
As you can see, I've adapted it so that it should compact and repair regardless of Access version, however, it's not compacting the database in Access 2010 - why not? The code recognises that it's Access 2010, and therefore executes [SendKeys "%(YC)", False], but nothing happens.the database just goes on to close (which is correct). However, if I manually click the compactand repair button, it works!

Access 2010 - SP1 and October 2011 Patch

Access 2010 - SP1 and October 2011 Patch Icon
Once the fix is available sometime this month in the October Cumulative update, the KB article will be updated with information about the patch including where to download it from, how to install it, and prerequisites to the install.

2625046 Access 2010 crashes in VBE7.DLL after installing Office 2010 SP1 [LINK]

After spending the morning reading the Microsoft Answers site titled: "Access 2010 SP1 - You receive random crashes in certain database or when opening the VBA window in those databases after installing Office 2010 SP1"

It appears that MS Office 2011 including MS Access has a problem with the new versoin of VBA. It is described by coders as catastrophic. Replace 'random" with constant. Also add code erased.

when, where and results if anyone else is involved in Access 2010 SP1.

access oracle database from MS access

access oracle database from MS access Icon
I have a set of forms in my MS access database and have linked it to oracle database with ODBC. With the link tables now available , could someone help me out as to how to write VBA code for the buttons so as to retrieve info from the oracle database ?

I would be happy if you could provide a sample VBA code for this querry i.e. when the student id is selected through drop down list and Search button is clicked it must go and look up in the table in oracle and must give all the students details

A Standard Set of Form Navigation Buttons in Access 2010

A Standard Set of Form Navigation Buttons in Access 2010 Icon
This article shows you how to reach Access form Nirvana: a situation where you have a set of navigation buttons at the bottom of each form, which you can freely copy and paste without worrying about whether the code behind them will work.

Unbound text control on report no longer working in Access 2010

Unbound text control on report no longer working in Access 2010 Icon
I have an Access 2003 database that I am now opening in Access 2010. I use a form to 'build' a report populated by what the user selects on the form. The VBA code behind the form builds a fliter string, opens a report and applys the filter to it. This allstill functions fine, but the report header is an unbound text box which is given a value from within VBA depending on what the user chooses on the form.
The Header still works OK if you run the database in Access 2003 (other PCs in our school are still using it), but when I use Access 2010, the report header is blank, both on screen and when printed!
all strings and variables are correct!

Here is the code that opens the report and applies the filter.