Well what I would suggest, to make things easier, SELECT the values from the DB and have them stored in a variable on the VB side, then do your calculations, and post the results back to the DB.
...

An example of using the ToString() DateTime Strings to produce common date & time output formats in Visual Basic.Net

Access 200,XP and 2003

Clearing Controls & Forms in Access (VBA)

VBA Validation Module

Haven't worked in VB6 in a long time, so not sure if something like this would help?? :confused:

Private Sub Search_Click()
Set dbindex = td.Indexes(0)
dbrecordset.Index = dbindex.Name...

My apologies JCD, it was 2:30am when I read this thread. :D But glad you worked it out.

Happy Coding! :cool:

Just a point; The searching would be rather cumbersome, and unless Index Services are enable on the other systems.....extremely cumbersome.

:cool:

Why not use the standard FileOpenSave...

I agree with Slade, but I ask, have you run through the debug to see what the value is in the CompanyName variable?

Ok, a little more details? What is some of the code related to the button, and are you getting this message when you run the program and try to click on the button? Or when the program is run...

Well here is my point on this. Why not loop through the recordset (which is an abstraction of a table object, based on criteria you have specified) until p_id = txtPatientId.Text ?

i.e. ...

so you want someone to convert this for you? Interesting request. Let me ask you what version on visual basic do you have right now?

where did you get he source code in BASIC from? Do you...

Ok a couple of things. 1. There is some logic to the code I a not understanding, so maybe you could give me a explaination on what is suppose to be happening.
2. To make your code easier to...

OK, not quite sure what you are saying, so let me see if this helps.

Passing Arrays as Parameters

1. Reference the array by name in the CALL statement
2. The called SUB/FUNCTION MUST accept...

Random-access file ( or random file) is a file whose data you can read or write in any order without having to read or write all other data in the file.

Ok, what does that mean, well look at it...

No problem Dude!Win32 Scripting (http://cwashington.netreach.net/depo/default.asp?topic=repository&move=last&ScriptType=vbscript&SubType=Misc)

Good luck!

I would say that IE messed up then. Because it came up all caps. Sorry Jay! :cool:

And thanks for your input Big "B" Affleck. :cool:

First of all, posted in the wrong place dude! Should not be in the Code Snippet Section! Secondly, don't use CAPLOCKS when writting messages!

Saying that;
What you are asking is a standard...

QkSTechTrainee;

Sorry I don't have any other ideas at the moment, but I can post the website I got that script from, it may have something else that can help.

Problem is, I am at work and the...

Agreed! My Bad! Thanks for the correction!

Don't have the answer but here is some related script that may point you in the right direction.


Author: Jason Tanem

Description:

This script reads in the names of drives and sends an...

Setup an Array to store all the possible cards, and Remove them as they are "taken" and if need be store those "taken" cards in another array. Use FOR loops to compare the two arrays.

Hope...

Still, rather strange Problem. I run VS6.0 No Service pack in XP no problem.

Glad to hear the SP worked, not sure why?

Hmmm...

Agreed, and guess we missed the boat Tekmaven. Oh well.

That is a Windows API type of programming. Where you actually manipulate a UI Control from Windows. I am not sure how, and it would depend on the language you are doing it in? .NET or...

looking good so far KatB!

Hope things are still that way since you post. Sorry, work has been busy so getting back to post on here has been a challenge.

Any other catches?

Looks good so far. Good work!

Ok, thanks for the run down, but as the guidelines for posting here at Techtalk, is that you show some attempt at your assignment, and we can give guidance when you get stuck.

Now after saying...

Hmm, I am curious, what version of Access are you trying to connect to? You say you are using Excel 97, but what version of Access? And why are you using DAO to connect via ODBC instead of ADO ?
...

Dani is write, but I would stay away from Global variables. Nasty, and prof's don't usually like seeing them. IMHO and Experience.

But in saying that, maybe you need to create a global variable...

No problem Kat. That is the great thing about this forum, we are here to help.

Let me know if you need some more help, I love this language, and love teaching, so don't be affraid to ask...

Hey Kat, I am glad the advice is helping, but I am still confused as to why you are unable to add the totals of each item.

IntGrandTotal = intGrandTotal + intTotal

How is it that this won't...

Sure you do. Don't make it harder than it is...





Looking over the code in the Save_Click, you have the above. Where you grab the ID, ProductName, UnitPrice, and Quantity. Well totals...

Your code seems to be incomplete, as there are end subs with no "subroutine starts"... but besides that, why not look through the values in the listbox and total them up into a variable as you need...

Try http://www.planet-source-code.com/

Opps, that is



Import System.Windows.Forms




my bad!

I_byte: I have not worked with VBA in word very much, but you are the second person to ask me to figure something out in it. I love a challenge, so I will get back too you....

As far as

...

Hey thanks I_Byte :D


Well what is it exactly that confuses you about importing objects? If you mean in the case of importing the system.windows.forms namespace, it is just not needed...

I_Byte, still struggling with this eh? Dates and Times can always be so much fun...NOT!

Here is what I would have done, as I modified your code to have it make more sense then me trying to...

Opps. forgot to mention something. Sorry been working every night this week. The "D" in the ToString function, is one of several preset strings in VB.NET for date time formats. "d" is the...