Topics Search

Breakpoint data macros

Breakpoint data macros
Views: 10
Continuing to play with Acc 2010 I'm coming up against a problem with one of my data macros that doesn't appear to be doing what I want it to. I cannot find out how to breakpoint a data macro to see what's wrong with my code. does anyone know how this done
Sponsored Links:

More topics

 

Forced.... Runtime Code Break

Preview
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 ?

Preview
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

Preview
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

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

Access Web 2010: Problems with Data Macros

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

Microsoft Access Macros

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

Create a macro

Preview
In Microsoft Office Access 2007, macros can be contained in macro objects (sometimes called standalone macros), or they can be embedded into the event properties of forms, reports, or controls. Embedded macros become part of the object or control in which they are embedded. Macro objects are visible in the Navigation Pane, under Macros; embedded macros are not.
 

Removing "unremovable" breakpoints in Access 2007, how?

Preview
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?
 

Work out what queries/macros are being used

Preview
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

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