Search results

all, I'm using this function and I'm concatenating all of the field data from the Excel spreadsheet into one string that represents a record. However, some of the field data actually *contains* commas! So my record string would look like this: value1,value,2,value3,value4 So using #Print in...

That is wonderful advice Lagbolt. Nothing else needed! thanks so much sir.

YES. this is what I was getting at. So if indeed an application becomes such that hundreds of thousands of records are dwelling in the tables, would that be an indication (if you know things will go that far) that you should consider up front how many joins or complex joins should be involved...

I'm not really asking about the *size* of tables, but rather all of the relationships that have to be formed between them, forms being used behind all of those relationships, and then many people then using those forms. So yes, the question is about performance with this, and more than that...

Hi all, I have a situation here where I'm going to be making a DB app that has a massive amount of data storage requirements, but ironically it fits perfectly into a 3-dimensional structure (e.g. - literally all 1-many relationships can be used for the entire set of tables). Here is an example...

luckily it was *not* variable in this case! :)

I'm sorry Pat. I wasn't using the sorting and grouping wizard in the report. Issue solved. I can't believe I didn't think of that. I'm just too much of a developer for my own good!

thanks Pat! I used your suggestion and it worked just fine. One more question for you? For some reason I'm also having trouble sorting by a field with my grouped report. Don't know why. Here's the deal: Rpt is opened by a form and the WHERE is driven by a multi-select listbox: Dim...

all, It's been so long since I've done this, can you guys help me out here? I have a table that has invoice line items in it. Each line item has the same invoice number to it. I am creating a report, but I need to group the records by Invoice # so that, after each # (and all the line items...

thank you Rx. I will research what you've posted.

all, In excel I'm trying to figure out how to eliminate (or hide) right-click items as they appear when you right-click a cell (or even on the worksheet itself). I believe the following folder (and key addition) in the registry is relevant to this request: CURRENT USER \ SOFTWARE \...

it's 470 pages but I'll try to find what I need! I got 5 areas out of it that seem to relevant to what I need. thanks Tony. :)

does anyone know of a good site that offers good advice on how to research writing vbs code to interact with active directory? I'm assuming it's fairly simple but have never done it. I'm aware that AD is just a storage resource for information on a windows network, but I'm thinking there's...

all, I know VBA can simulate the DOM usage to some degree, but this thread suggests that it is not the best language to use to navigate the web because it's sleep() function equivalents are not reliable: http://www.access-programmers.co.uk/forums/showthread.php?p=993845 does anyone know other...

Guys, the "beyond the brain power" comment is probably right. there is a way, and yes it is for intellectual reasons, however it certainly is more difficult no doubt about it. we'll see if any other comments come along. thanks Brian. I will use yours unless something else comes along.

thanks Brian. but again, I'm really interested in a mathematical algorithm of somekind that you can map to this whole thing. I know we can shorten the syntax (as you've just done), but is there any math you can apply to this in the form of searching out the characters you want? What...

hello guys, I know the code isn't perfect. It's not supposed to be. what it is *supposed* to do is take 9 blocks of 3-chars-each from each of the 3 lines, one block at a time. make sense? I'm not going to change the code, you get the idea. but here is a sample of the 3 lines of text I...

all, I have this block of code: If ctr = 4 Then For block = 1 To 9 For ctr2 = 1 To 3 'each line. For ctr3 = 1 To 3 'char 1 - 3 in each line. Select Case ctr2 'which line? Case 1 strOut =...

Hi guys, Does anyone here know of a place like this? I'm trying to avoid MSDN if I can. That's all I know that's out there. I'm trying to understand "what is needed with what" when messing around with .NET components and the branches of installations that they've created off of the...

I'm enum'ing all of them as I'm writing this. I noticed all of that. This is too bad, but it looks like it's going to be a piece-meal solution. I can just see the corruption train-wreck from this. thanks Lagbolt. Always reliable, you seem to be. :)