Related Topics

Breakpoint data macros

Forced.... Runtime Code Break
I once perhaps had a breakpoint set on a particular line of code in one of my routines behind a form. This breakpoint is now no longer set.

However, in recent days I have noticed when this particular piece of code executes (it is only opening a REPORT!), operation stops and the current line of execution is highlighted much as if it had stopped on a breakpoint.

If I Run / F5 from here. all runs as normal and subsequent calls through this routine do not STOP. So, it only ever happens the first time for thatdatabase session.


Data Macros - anyone with experience ?
Forum, access 2010 accdb.
Anyone used data Macros with a split accdb ?
I did ask this question a while ago but no response.

I plan to use Data Macros to handle the process of collecting data for our Data Transfer to remote site task but my new text book for 2010 only handles these for a database that is not split

Most advice is to split your database so why have a feature that isn't setup for split databases


Programming with Access 2007
Macros in Access can be considered like a simplified programming language that can be used to increase the functionality of the data base. For example, it can enclose a macro to a command button in a form, so the macro is executed when clicking in the button. The macros contain actions that make tasks, like opening a report, executing a query or to close the data base. Almost all the operations of data bases that normally are made manually can automate by means of macros, thus saving time.


Programming Access 2007
Macros in Access can be considered like a simplified programming language that can be used to increase the functionality of the data base. For example, it can enclose a macro to a command button in a form, so the macro is executed when clicking in the button. The macros contain actions that make tasks, like opening a report, executing a query or to close the data base. Almost all the operations of data bases that normally are made manually can automate by means of macros, thus saving time.


Removing "unremovable" breakpoints in Access 2007, how?
I have a situation of a non removable breakpoint in my Access 2007 applicaiton.

I have done "clear all breakpoints" countless times, complied the code countless times, compacted the database, exit / restart, and on and on.

I can not seem to find a way to get this breakpoint to go away.

Does anyone happen to know where Microsoft keeps the list of breakpoints? Perhaps in one of the hidden tables? Any other ways than "clear all breakpoints" to remove ALL of them?


Microsoft Access Macros
The following articles contain useful information about using macros in Microsoft Access 97 and converting macros to Visual Basic for Applications code.
Macros are very useful for automating simple tasks, such as carrying out an action when the user clicks a command button. You don't need to know how to program to use macros. Macros can perform a number of the common tasks that you can also use Visual Basic code to perform. However, using Visual Basic code instead of macros gives you much more flexibility and power, and there are many things you can only do in code, such as returning values or iterating through recordsets.


Access Web 2010: Problems with Data Macros
Some time ago I published an Access database on a Web site Office 365 and found to work properly. The problem is that currently, all data macros are no longer visible from macros in forms. As an example, I have a product form with a button that performs an action on the record in the table "Products". Pressing the button runs the onClick event, and this in turnexecutes the data macro Products.CanUpdateProduct and Access displays the error "Can not start CanUpdateProduct macro."

I made a copy of the database to run locally and the problem is something different, "macros do not allow data queries that contain linked tables, action queries and database references."

This I think may be related to a configuration database that prevents access to data macros, or tables are locked but can not find anything that allows me to correct this misconception.


Work out what queries/macros are being used
I am reasonable at creating access databases, but I have inherited a rediculously complicated (by my standards) access database created in the stone-age. It works fine in Access 2010 which is what I am using.

I have a report which I want to change around, but I need to assertain what queries/macros are being used to create the data this report calls, as directly referencing the data I want to add to this report gives me an error.

How do I find out what queries/macros are being used in a given form/report


Using Macros to Automate Data Entry
As you will have seen in the previous topic, we can use Macros to Require Data Entry and to inform users of any errors made in the data entry routine. We can also use Microsoft Access Macros to speed up the process of data entry. We can use a macro to remove the need for a user to enter the same data over and over for each record, we can use a macro to automate this process.
A Microsoft Access macro is a database object that allows us to automate repetative tasks without having to write complex programming routines. In Access, these tasks that the macro performs are know as macro actions.


Introduction to macros
This article explains what macros are and how they can save you time by automating tasks that you perform often. It explores the fundamentals behind creating and using macros and also touches on improvements to macros in Microsoft Office Access 2007.
In this article: What is a macro? Understand macros; New macro features in Office Access 2007; Create a macro; Run a macro.


Microsoft Access Macros vs. VBA - Why Use Macros?
Macros have been used as development tool since the early days of the Microsoft Office product line. Microsoft Access macros incorporate generalized database functions using existing Microsoft Access capabilities. Errors in a macro can be easily resolved by using the Microsoft supplied Help function. The ease with which you can generate Macros makes Macro development seem easier to accomplish...


VS2010 Service attaching to a remote debugger symbols will not load to set a breakpoint
I have a Vb.Net 4.0 Windows Service. The service is setup to run in DEBUG with generate debug set to pdb-only.
Configuration is set to debug.

Installer project is set to DEBUG. VS IDE is set to debug.

I do a clean build and clean install of the DEBUG version. I run x64\msvsmon.exe on remote machine (W2008 R2 64bit). I attach to the process via workstation (XP PRO 32bit) in VS2010 without issue. Everything is set to debug but I get the infamous message breakpoint will not currently be hit,


vba vs macros
if the majority of my code is in vba, does it hurt to have some simple stuff in macros.like a close form button or whatever

I was reading that macros are amateurish, and you should make your whole program in vba.but I copied a couple of buttons or what not from templates or examples, and I absolutely do not understand macros at all.i understand vba A LOT better.but im scared to change it because I need it to still work.


Macros
This week we'll discuss, for those of you unfamiliar with programming, one of the more conceptually complex aspects of Microsoft Access. We'll start with a discussion of events: what they are and how Access uses them. Then, we'll move on to a lengthy discussion of macros, including what they do and how you design and use them. TOC: Macros; Debugging;
Getting Fancy with Macros.


Introduction to macros: Automate tasks
This article explains what macros are and how they can save you time by automating tasks that you perform often. It explores the fundamentals behind creating and using macros and also touches on improvements to macros in Microsoft Office Access 2007.
In this article you'll learn: What is a macro? Understand macros, New macro features in Office Access 2007, Create a macro, Run a macro.


Access 2007: Enable Macros on Startup
Has anyone figured out if it's possible to enable vba macros on startup using a script? In Access 2003 I used application.setoption to tweak a number of application parameters though I'mnot sure if I can use this to enable macros in 2007.

I know that I can manually enable macros through the trust center and I could also add a trusted location (could prob. also automate a registry update to do same). My preference though isto enable macros using a script as over 600 users will, on occasion, use these databases and I don't want to spend my days telling people how to enable macros.


Unable to open my database
I created macros which I put close application so and save it, and as soon as I open the macros it shut down so I can't able to edit does anybody know how to get in and delete macros...


Data Macros
We've recently been upgraded from Office 2003 to 2010. Apart from getting used to the ribbon I'm loving some of the improvements in both Excel and Access. One of the things I've just noticed is "Data Macros" which seem to allow one to create trigger type functionality in Access - this is very exciting!

I have already tested and it seems that the data macros will workboth within the application and also if you're modifying/inserting data using ADO (which is how many of the applications I've written work).

Are there any pitfalls or known issues? One immediate use I can think of is to have Access automatically update a field with a timestamp any time a record is changed - currently I do this using VBA I.e.

The VBA will modify the record and then modify the LAST_UPDATE field - it works but I would much rather that the DBMS handledthis.


How to display message if macros are disabled?
I would like to know how I can make Access 2007 display a message if I open a database that contains macros but in the Trust Center macros are disabled

I know that Access automatically displays a warning bar when doing so, but that is no good to me, I would need a msgbox that appears if macros are disabled (so that other parts (forms, etc) don't get displayed


Split web database macros
Need some help with splitting a web database. So I have a fully functioning web database that exists on Sharepoint but the performance is pretty poor online. I was thinking that splitting the database would be a good way to help speed things up as that usually improves performance on client databases. I used the wizard to split the database which worked successfully but now all the data macros fail in client mode and won't upload to Sharepoint. Any advice on how to get the data macros working again