473,570 Members | 2,870 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB in Access Problem (I think)

13 New Member
Ok, so I posted a question about an overflow error before. Now I realize its not just there.

Here's the situation, you really don't need the code because well I don't actually think its the code. I have a class called CStream, in there it has some variables (H, P, T, W) all as doubles with get and let procedures. In the H get, there is an if statement that checks to see if H is set, if not set, calculate via P and T, then return H otherwise just return H. so in the module, I set H = a value, and then later I am accessing the H via a get (either via a print or calculation). NOW here is the issue. If I just run the program, I get the a calculated H (which is not what I want) if I step through the program (this is spooky) and get to the Get H procedure and stop just as it enters the get h, I mouse over the H and guess what it says... H = 0 (not set).... I keep running and it calculates etc. If I step through and stop at the same spot, still says H=0, I open up the locals window in the Debugger and look at the H value... it has the value I set it to... mouse over H again and it say H= value! now... WHY is that?????
Jun 1 '07 #1
2 990
2,364 Recognized Expert Top Contributor
I open up the locals window in the Debugger and look at the H value... it has the value I set it to... mouse over H again and it say H= value! now... WHY is that?????
Great job looking at the locals window through the debugger, it is your friend:-)

How do you dimension H? String, Integer!
Jun 1 '07 #2
13 New Member
all doubles as stated before. but to put it quite simply, access vba is acting like a little kid. if you aren't watching it (debugger locals window) it messes with you. It seriously forgets that H has any value and YES I am absolutely sure it is set, until you look at it in the debugger locals... then it says "oh yeah, stupid me, it has a value of 175, not 0".... How can I fix this, because its driving me nuts and I need this program to work.
Jun 3 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy in Visual Studio to create reports and labels as it's in Access?` The advantage of VS.net is that not every user needs Access, right? And that...
by: Simon Bailey | last post by:
I am a newcomer to databases and am not sure which DBMS to use. I have a very simplified knowledge of databases overall. I would very much appreciate a (simplifed) message explaining the advantages and disadvantages of both programs. Many Thanks Simon
by: Think | last post by:
I want to build a new field based on field START_TIME (1.12.2003 1:37:32) called TOTAL_NUMBER_OF_CALLS. In this field I want to have a number of total records. That number I see at the bottom of the page (navigation buttons). Thanks in advance.
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The application is relatively big: around 200 tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data (SQL Server 2000), 40 users. ...
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to speed. I like books with practical exercises, and also with test questions (like cert books) *2*
by: MLH | last post by:
Runtime error 13 - type mismatch. I get the above error when I create a text box control on a form named and I run the following code in a sub on that same form... If DLookup("", "tblUsers", "=Forms!Form10!UserID") Then tblUsers has a 6-char text field in it named . What can Access
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server...
by: Bob Alston | last post by:
Anyone know of any list of changes required in an Access FE to make the Access FE work with a SQL backend? ditto for Access FE working with a MYSQL backend? Bob
by: gellis72 | last post by:
I'm working on a program that imports a bunch of data from a folder full of Excel files and compiles it into an Access DB. The Excel files have a varying number of rows and columns that need to be imported, and the data needs to be processed/error checked before it's written to the DB. The way I've tackled this is to have a procedure that...
by: John | last post by:
Hello there, Im cursing my place of employment...and its taken me a month to realise it... The scenario: Ive just stepped into a role to migrate an access database to VB.Net. The access database runs on terminal services and supports approximatly 25-30 users. It is crapping out big time, corrupted data, changes to the front end are...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.