Topics Search


Views: 10
When I use a function which contains debug.print in the Immediate Window it produces a string of characters i.e.
3 yrs, 1.15%
5 yrs, 1.65%
How I translate this to a message box? Or even one step further into the body of an email via my .body = [some vba code].
Sponsored Links:

Similar posts...


VS2010 Service attaching to a remote debugger symbols will not load to set a breakpoint

VS2010 Service attaching to a remote debugger symbols will not load to set a breakpoint Icon
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,

Cannot enter the project to debug mode

Cannot enter the project to debug mode Icon
I have a project that was download from the net. It is a open source project. I can run without anyerror with IDE 2005. But I cannot enter the debug mode. I have set the project build to debug. But I cannot still enter to debug.

I also got the following message when I run the project.

The following module was built with optimizations enabled or without debug information:

To debug this module, change its project build configuration to debug mode. To suppress this message, disable the "Warn inf no user code on launch" debugger option

Not stopping at Breakpoints in Debug mode

Not stopping at Breakpoints in Debug mode Icon
I am using VS2010 with Win7 and VB.NET solution. Between, everything was working fine for months; the problem started yesterday.

The solution and the projects within it are set for Debug; I deleted the .suo file as recommended in one posting. I ran rebuild on each and every project individually and the entire solution.

I deleted the files in bin\Debug and did the whole thing over again. Still can't debug.

While stepping into (F8) I did get the hollow debug symbol in the margin and when just running the program (F5) the program starts up without stopping at any of several breaks in different functions and subs.

disable debug error

disable debug error Icon
how to disable debug error in ms access vb,
I mean when I open a form some time showing debug error this is being a disadvantage due user using and user can be edit, if debug error just I want OK button only

Compile Error Syntax Error

Compile Error Syntax Error Icon
Wonder if anyone can help
I get an syntax error when compiling the code below.
Any help will be much apprediated.

Private Sub Command105_Click()
If IsNull(Me!Encryption_Password) Then
Me!Encryption Password = DMin("[Encryption_Password]", "QueryEncryption", "[Encryption_ID]=" & Me!Encryption_Password)
Debug.Print DMin("[Encryption Password]", "QueryEncryption")

Debug.Print LaptopID, Me!Encryption_Password

VBA doesn't recognzie variable's contents

VBA doesn't recognzie variable's contents Icon
I have declared a public variable in my form's vba code


Returns goes back to the original code.

But when I check the value of the variable in the originals form code with a msgbox. it is blank.

When the code finishes running (there is just one or two lines of code which do not affect the variable). I debug.print strinput and it has a value.

Why does debug.print recognize the value of the variable but the code within the form (it is an afterclick event subroutine) not recognize it? The public variable is declared in the original form.

Debug not working in 64bit

Debug not working in 64bit Icon
I've downloaded the 64bit debug symbols and told the IDE where they were located. But for some reason, VS won't build a 64bit debug EXE.

This is my first time doing 64bit so I never had to worry about it before. Is there something I need to do in the IDE that I don't know about? I went to Project Properties and set things to 64bit debug. But when I compile the program, it makes a 32bit program.

I can't debug my code in VB6 IDE

I can't debug my code in VB6 IDE Icon
I'm trying to debug the code in VB IDE. This IDE is able to debug the console VB Scripts. But in our project, we are generating the HTML pages using the VB. We wrote the .cls modules for that.

When I try to debug this .cls modules, the control is not going to the particular code line. the properties of my project is alright.

Access - Eval function

Access - Eval function Icon
this is my problem
I need to use <EVAL> function for my db, but it does not run.
Example: if I execute this routines (sure enough I build my string)

Sub ChangeIcon() Dim mStr As String mStr = "CommandBars(18).Controls(1).FaceId" Debug.Print Eval(mStr) End Sub

all works well and I see the result (67 for example)
But if I want to change the FaceId, the routines don't show any error, but che FaceId is non changed

Sub ChangeIcon() Dim mStr As String mStr = "CommandBars(18).Controls(1).FaceId" Eval (mStr & "= 3") Debug.Print Eval(mStr) End Sub

value returned always

Best practice for print preview and print a report

Best practice for print preview and print a report Icon
Typically when you print something, you get a print preview (with focus) and then print dialog to print to a printer of choice. How can you accomplish this ni Access 2007? I can go straight to print, and I can preview (unfocused tab) or preview as popup, then magnify/demagnify with mouse and click ribbon print button.