DataBase - Breakpoints Window
Asked By Bill
27-May-10 03:51 PM
In Access 2003, where do I find the Breakpoints
Window where I can set a condition upon which
the breakpoint becomes active?
Thanks,
Bill
Access 2003
(1)
VBA
(1)
Jeanette Cunningham
(1)
Print
(1)
Click
(1)
Code window
(1)
Breakpoint
(1)
Jeanette Cunningham replied to Bill
it is also called the code window or the immediate window.
Ctl + G will open it for you.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
Bill replied to Jeanette Cunningham
The immediate window is where I would go to
view the output of "Debug.Print". Unless I am
missing something here, I do not get that I can
enter a condition that will turn on a breakpoint
like the HELP describes.
What I want to do is single-step through code
when a certain name is reached in a cloned
recordset.
Bill
Jeanette Cunningham replied to Bill
In the immediate window, choose the line where you want the code to stop so
you can single step.
Click in the very far left of that line, and the line will be highlighted
(often red).
That is called Setting a breakpoint.
Now run the code by opening the form and using the buttons etc.
When access gets to the line with the breakpoint, the immediate window will
open.
Press F8 to move to the next line of code.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
BruceM via AccessMonster.com replied to Jeanette Cunningham
Just to clarify a little, select the line of code in the main VBA window, not
hte immediate window.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1
Bill replied to BruceM via AccessMonster.com
Somehow, I am not making myself clear. I know how to
set breakpoints and single-step code in Debug. What
I have not been able to find is how to have a breakpoint
disabled until a certain record is reached.
Bill
Stuart McCall replied to Bill
In the VBE, Debug -> Add Watch
Bill replied to Stuart McCall
Thank you. Obviously, the online HELP text I
found did not pertain to VBA 2003. Funny that
VBA HELP issued from within VBA edit did not
reveal "add watch" when conditional break in debug
was searched, oh well.
Thanks again,
Bill
Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will be able to afford, because the pricing and licensing for the Enterprise version is very, very steep. The alternative is hosted Sharepoint / Access Services, and the costs do not seem terribly high. It seems to me that the pricing is upside-down. Big enterprises do not want to deploy Access apps in the browser - - they will build their own .NET apps, browser-based or not 2010, it could vastly increase those costs for organizations with legacy hardware). The features of Access 2010 used in conjunction with Sharepoint 2010 seem to me to be most compelling for and small businesses. I do not know if I could sell clients on hosted Sharepoint / Access. I have been able to sell clients on hosted Exchange, and it is been very W. Fenton http: / / www.dfenton.com / contact via website only http: / / www.dfenton.com / DFA / Access Discussions SQL Express (1) SQL Server (1) MySQL (1) Exchange Server (1) Windows Server (1
Access 2010 for software development DataBase Hi, What do I need to use Access 2010 (or perhaps 2007) to port our 2003 application and create an executable (MDE in Access 2003)? Are there any issues with 2010? -paulw Access Discussions SQL Server (1) SharePoint (1) Albert D. Kallal (1) Office 2007 (1) Office 2003 (1) Access 2007 (1) Access 2010 (1) Access 2003 (1) You can use Access 2010 to develop
Data Macros Don't Work With Linked Tables??? DataBase I have an Access 2010 ACCDB with an AfterInsert data macro on a table. Works fine. However, when I end and back end file open, just in case that was an issue. Thanks! Neil Access Discussions Windows SharePoint Services (1) SQL Server (1) Access 2.0 (1) SharePoint (1) Outlook 2007 (1) Access 2010 (1) Access 2003 (1) Outlook (1) I should note that I am using the data macro to call a VBA function (by setting a local macro variable to the result of the function call). So this is not for the web, I did not see a problem with calling a VBA function (and various places I have seen online mentioned workarounds for calling VBA from a
Considerations migrating from Access 97 mdb to Access 2003 (or up)? DataBase What are the things I need to watch for? I know about sheet properties and Sandboxing mode and making sure to run Jet 4.0 SP8 for 2003 but what else should I look for? We're kind of at the end of the road (so it seems) with Access 97. It does not play well with Windows 7 Professional even in XP Mode, the is crashy / unsreponsive at times. I figure moving up to a more 'modern' version of Access can help alleviate some of these problems and allow it to run native in Windows XP mode. So I am all ears for recommendations on migration or ways to get Access 97 to work properly in Win 7. Thanks a bunch. Access Discussions Visual Studio .NET (1) Windows XP (1) Office 2007 (1) Access 2007 (1) Access
correct term. I am talking about Dbs to which you set a reference in the VBA references section. Secondly apologies for sort-of reposting this question, but I drew blanks last in the library and seeing how many forms there are. Any help gratefully received Phil Access Discussions David W. Fenton (1) Access 2007 (1) Office 2007 (1) Windows 7 (1) Distributed (1) Exception (1) Relative (1) Declare the (standarized) forms in the user databases, than the forms can be updated with one click of a button. In this concept it is not necessary that the General database knows means no MDEs, right? That would be a complete showstopper for a large population of Access developers, I think. It would not be for me in all my apps, but for to the Menu db that it does not reload it. I can remove the reference (Access.References.Remove RefName), but then I have to compact and repair the Db before adding the Tools-> References section. As far as I know it is not possible to use VBA to compact and repair. I cannot find any way of removing the reference from the Project explorer after running Access.References.Remove RefName. Any help gratefully received as ever Thanks Phil Hi David Think one