Search results for query: *

vb5 Thank you so very much for the suggestion. It works! Once I get my MSDN CD back in the office I can read up on that event. Have a star. Jim

When my program starts, an mdi opens with a single form shown. The program gathers a little information from the user (including the Access database containing the data the program runs against) on this and one subsequent form, then runs and performs an extensive QA of the data, writing...

Zor, no need to be sorry for hopping in. Glad to see that I am not the only one who has scratched his/her head over this. DrJavaJoe, you are exactly right about inserting a record into a db to record the error. I join two tables then check for widows and orphans. If something goes wrong with...

BB, Thanks for the reply. The error handler is in a sub within a class module. I don't think I've programmed the error handling as efficiently as I should, but I had to do what I knew at the time. Thanks for the suggestion for strongm's post. I'll take a shot at finding it. Jim

I have a sub in which I have an error handler in the event of a problem with some database manipulations. What happens when there is an error within my error handler? For example I am adding a record to a table that identifies the source of my error, but if I've made a typographical error of...

Cassie & nicsin, Thanks to you both and here's stars for both. nicsin, thank you for the code snippet. Cassie, you are right - it was way too obvious! Jim

nicsin, I think I've been quite lucky when it comes to this part of the code. Part of the motivation for the question is bad thinking on my part - I'll go back and add the error handlers later. By the time I got to doing this, which was a small part my first VB project, I had enough...

nicsin, You are right. Sorry about being abrupt earlier. Although I have asked a lot of questions here, I have yet to figure out what happens when I am composing my response to one or two, and more responses come in (who if anyone gets notified of my response?). I kinda panic and just...

Cassie, Your second message came in as I was finishing a response to the first. Maybe I just need to think of the error handler in different terms - it really is in the flow, just parked out of the way for emergencies. As I pondered my first response I thought about what you've suggested in...

Cassie and nicsin, Thank you for the replies. Cassie, I have implemented exactly what you have suggested (but in only one sub at the moment). Again, it just seems like I am jumping out of and into loops. It may be ok to do it this way, but is sure does give me the creeps! nicsin, your...

My bane (among other VB things) - error handling. I have code that parses lines of text, one line at a time, and inserts the results into a database. I don't know if I am doiung the best and most efficient way, but it works. Generally, Dim objLine As TextStream Dim strNewLine As...

Jaroslaw, I am very new to hierarchical recordsets, but I did need to do something similar (I had grandchildren), and tended to go overboard on notation to keep it all straight, so I think the suggestion below has some redundancy in it. If it is wrong, hopefully someone more knowledgeable can...

Chip and DigitalGeek, Thank you for your replies. The XSD is valid under the few validators we tried, and it is a known problem with vb.net. We cannot modify the schema and we were hoping that having it would simplify the process of reading a set of text files and writing out XML files...

Hi, We have been given $$ by a client to develop a program in VB.NET that will take an ASCII file and convert it into XML based on a predefined schema that we are not at liberty to modify. Since we are new to this, we wanted to explore parsing the data, and use ReadXMLSchema and WriteXML to...

Nouman, Thank you for the submission. Since I do not have vb.net on my machine, I will pass it on to my colleague. It may be a couple days before we actually implement it (I think he is on yet another project at the moment) and test it out. I'll be back to let you (and the tek-tips...

Hi, I've been working on the VB6 side of things for a while now, but have been asked to assist someone (a very newbie to VB) who is developing a standalone program with VB .NET to take 8 ASCII files (each with fixed length records) and convert them to XML based on the schema that was provided...

Hi giyer55, If I want to check if dataenvironment1.rsvaredit is closed, I check the State with an If..Then block rather than using On Error Resume Next so, as Johnwm indicates, not to hide some other problem (been there, done that making it tough to find the real problem). Jim

Thanks guys. Didn't mean to spur this much activity. I guess I am trying to look at it from two points of view: what (little) I do know and what I found on this forum, as well as if there was something that I had not found that would be better. So I think both CCLINT and vb5prgrmr hit the...

vb5prgrmr, Your response came in as I repsonded to CCLINT's reply. Thanks for the suggestion. Jim

CCLINT, Thank you for the information. I will admit that I do not understand some of it (e.g., asynchronous processing of the recordset and threads), but I can find and learn more about it. I am familiar with other aspects of your response (e.g., the State property, but not all the possible...