Topics Search

VBA Code for buttons, Access 2010

VBA Code for buttons, Access 2010
Views: 122
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:

More topics


VBA code from Access 2003 not working in Access 2010

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.

VBA 7 Reference for use with Access 2010

I have turned the Microsoft website upside down trying to find the VBA 7 Reference Manual. No luck. Can anyone point me in the right direction?

I have to rebuild our Access database almost completely. None of the buttons, macros, combo-boxes built with 2003 work in 2010. And none of the data validation and automation procedures I wrote in VBA using Access 2003 work.

So far I have been able to re-build many of my buttons by just playing around until I get it figured out. But simple things like getting forms to maximize when they open, or being able to push a button and open a new form with the child records of the parent displayed on the previous screen are really eluding me.

I have ordered books, but they won't be in for two weeks. I really expected most things to work when we upgraded because I did not use the menus in my application

Access Crashing

Has anyone else seen this type of issue

I have a form with several buttons that call functions, one to run a VBA module, the other performs some VBA then opens a form.

Yesterday they all worked fine - today very time they are clicked they crash access.

Now here is the weirdest bit - if I put a debug stop in the code in the On_Click event of the buttons access does not crash!

Has anyone seen this before and is so how have you fixed it

How to you tell Access 2010 to run VBA code?

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

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

VBA Code to prevent editing in Access 2010

I recently purchased Access 2010 and have created a DataBase, a Data Entry Form and a split-screen form. The split-screen form is ideal for inquiring the DataBase, but it permits anyone to change values in the DataBase. Can VBA code be written for a module that will prevent whoever opens the split-screen form from changing any value within the DataBase? Now the hard question. I do not know VBA, so is there a volunteer willing to write that code? Any

Where to see the VBA code behind the form ?

Many years ago when I last used Access, I could see the code behind a form, where I could see the code behind the different buttons on the form and so on.

Where can I see this VBA code ?

I use Access 2007 now, if it matters.

Access 2010 now creates macros instead of VBA code

I have been using 2003 for a while but I have switched to 2010 recently.

I have just found out that if you use the wizards when creating a command button, Access now creates a macro instead of creating VBA code (for opening a form, for example)

I prefer code over macros, so is there a way to change this?

Also, what about the macros that have already been created? How can those be converted to VBA?.When I use the "Convert From's Macors to Visual Basic" option I get a "There was a problem opening the macro "[Embeded Macro]". Do you want to continue?" and the macro does not get converted

Unable to open code window

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.

create a calendar from scratch using vba in access 2010?

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]