Recent content by shepherd

Hi, I'm trying to dynamically edit selected text using execCommand and fontsize as the passed command. [i.e. execCommand(fontsize,'',4) ]. The problem is that this works fine for relative browser sizes, but I need it to work for absolute sizes as well - either points or pixels. I've scoured...

hey, thanks for the response. Yeah, that's actually how I've handled it in the past, but I was hoping there was a more graceful way (I always felt like this was kind of a hack). I'm thinking that this is probably the only way to do it though.

I have a few procedures which uses transactions within access to ensure data consistency. What I'm wondering is, how can I test if a connection has an ongoing, uncommitted transaction or not. I'm trying to create a routine in my error handler to rollback any open transactions if any errors...

Hi Jon, Just wondering if you were able to solve this issue? I'm having the same exact problem. I have Office XP running on my machine, and all of the sudden can't use the FlexGrid control in any of my apps (including VS2003.NET!). I'm not sure what happened. I feel like maybe the library...

Hi Rick, thanks a lot for the info. It would be nice to see at least *some* effort on MBS's part to help support implementation and development efforts with this product. But I agree, as always their marketing is top-notch... (oh well). Anyway, I've been a little more successful piecing...

I just happened on this thread searching for info on Microsoft's RMS system. I've had a hard time finding developer info on the product so far, so I'm really hoping someone can help me out here. OK, here it goes... I was wondering two things: First, does anyone know if there is a way to...

Quick question - Would creating a filegroup comprised of multiple physical files only be advantageous if each of those physical files is located on a separate physical drive or array? I'm wondering if there are any benefits to creating a secondary filegroup that has more than one data file if...

Hi - Recently, a friend of mine was telling me how great the data environment tool in VB is. I've always done this work by hand (ado). Does anyone have any info, or experience on the pros and cons of using the designer instead of coding connections manually? I'm wondering what type of...

Hello! I have a query which returns multiple records to a user. I can't figure out how to display checkboxes instead of True/False fields in the results. Are there any list controls, or grid contols that allow for displaying boolean fields as checkboxes or similar graphical representations on...

I need to create a rollup table, with the data grouped by day. The field that I will be grouping by is a standard datetime field which records the exact time a transaction is made. Is there an efficient way to do this? When I run a cast or convert to int on the date field, it rounds up (so a...

Can you supply a sample of the code that creates the temporary table, and the code that calls the procedure?

Try this: ncell.Interior.ColorIndex = vColors(cint(ncell.Value))

The single in single out idea as I know it only applies to encapsulated procedures like functions and subs, not simple routines like loops and conditional blocks (and although I adhere to this and require it of my programmers - simply from a standpoint of code maintainability - I will agree that...

Well, if you notice, I didn't submit an entire procedure, just a piece. And, I was assuming that the boolean would have been initialized before the snippit I submitted (i.e. when variable declarations were made) - the idea remains the same. I also agree with woyler regarding the exit...

Did you dim (and Set) your adoInfo variable as an ado connection object? The error means that you're trying to access an object that you haven't created yet...