Recent content by ssVBAdev

Thanks for that info, John. I looked through some of the MSDN stuff that came with VB6 and could not find that. In fact, I did find one article that had some of that same wording but the examples they gave did not work as the data access logic had changed (or something to that effect anyway)...

Thanks for all your help and time, Denster! This program is on another computer so I'll have to give it a go when I get back to that computer. I'll try to post back with how things go. ******************** What's the best way to get the answers you need?? See FAQ222-2244 for details!

Ah, that's what I'm looking for. For some reason though, I tried something to that effect and the grid would not retain the data. If you close the database once you are done populating the grid (during runtime), does the data in the grid get cleared out? I've also just switched from a Win98...

It's not so much the editing of the cells that I'm having trouble with right now (although, by the sounds of it, I may need your code soon [keep the notification on this post and I may get back to you :-)]), the issue is how to even get the data into the grid in the format that I want it. Using...

That is pretty much correct Denster. I guess I don't follow what you are doing by snapping a textbox over the cell though. I'm interested to know more about it though. In Excel, I import the data into the matrix - which is much easier to read than trying to go through the database say in...

I have an .mdb database with the tables as laid out below. The Main Table has a list of Groups where there can be any number ("N") of groups. In the groups are subgroupings (as noted by the number after the dash). Each subgroup has any number of Items in the subgroup (see the "ItemNO" field)...

This is "kind-of" what I am working on. The VBA is written with Office 11 on XP. I have Office 10 on W2K, but I have not heard back yet regarding the operating conditions of the user. I think they may be quite behind. I have had such problems in the past involving, of all functions, the...

Is there a way to "trap" compile errors much like you would trap a run-time error? I have a computer in another office using an Excel VBA program I developed that has not caused troubles on other machines in other offices before. Now, for whatever reason, one specific module is giving a...

AurtherKnight: Thanks for input but as I mentioned it turned out to be a motherboard problem. So scanning the file system at this point would be irrelevant and not a help. The computer hardware itself could not write to the RAM and then read it back properly. Just one of those quirky things...

Well, as I said I had no issues on Friday and the computer ran all day fine. Today, I put the memory module back in but switched the two. Tests showed that the module in slot 1 was again failing. As BadFrog pointed out, it seems that the slot is problem and not the memory module. I'll check...

Well, as I said I had no issues on Friday and the computer ran all day fine. Today, I put the memory module back in but switched the two. Tests showed that the module in slot 1 was again failing. As BadFrog pointed out, it seems that the slot is problem and not the memory module. I'll check...

Thnkas for the info John. You're right though, we don't generaly think about those kinds of things but I guess, just like cars, we need to care of what's under the hood. But, the computer is still less than 1 year old. Many parts are still under warrenty. I'm going through the process of...

linney, Sure there are savedump events in the Event Viewer but (and I'm no hardward expert here) this tells me nothing... And the mini dump file is not readable in a text file so I'd need some kind of reader or viewer to see the contents of that file. even then I'm not sure I'd fully...

I'll give it a go. The trouble is that this problem is so intermittant. I'll work just fine for a while (perhpas for an entir day) then all of a sudden, I'll be working normally, the computer will jsut shut down. None of the logs have been a help thus far in determining what happened just...

Well, after installing the audio driver without problem a shutdown still occourd and it was the same problem... a driver of some kind. I've run the Microsoft Memory test a couple more times and apparently one of my memory modules failed the same test on two different occasions. Anyone know if...