Search results

i'd need to see the data.

I just did this over a cup of coffee. It's junk code that I have that I use pretty frequently: I just customized it for this. Initial requirements would be having to rename your "group" to something else. I called it "rengroup". Group is an owned word in sql and even if you can trick your...

does your real data have like an index value or something? In my head, you could do this with probably a couple of recordset objects to at least identify the right values. I have no idea how I would approach getting it back into the list.

how big of a list are we talking?

Yes. I've got it. It's been in use for about 6 months now. But the quirk is, I have this horrible kind of setup for managing the email texts and I'm trying to think of a way to do it: function GetEmailString(sRepName as string) dim sresult as string select case srepname case report1...

just implement this somewhere: For Each cl In ThisWorkbook.Sheets("Distribution List").Columns(2).SpecialCells(2) If cl.Value Like "?*@?*.?*" And LCase(cl.Offset(0, 1).Value) = "yes" Then If strto = "" Then strto = stro & ";" strto = strto & cl.Value & ";" End If Next cl For Each cl In...

My samples are back in the office! I'll get it to you tomorrow. So basically: I've got a single access database. There's some fairly simple code that runs a bunch of stored queries, creates some new tables, and then sends the tables out to various users. So for each output table, there's...

Emmmmm... Do you have a example of this? Like 00001 Hello /00001 = hello ?

Yeah I played with that idea for a while. I came across a few limitations to doing that. This conversation has given me some ideas though. Thanks.

Hmmmmm..... Can I store HTML in the table?

Hi, This is all an Access based project, but this really more about the VBA side. Here's what I've got: -Class that manages a series of reports out of access. -A Class that emails the files exported to a bunch of users. General program flow: A header procedure loops through a table...

idk i'd try to do to see how well vba can run off the cli

http://www.cpearson.com/excel/betternetworkdays.aspx

what's the actual error message?

Cool I think that makes sense. I appreciate your help.

@Debaser: that's awesome. Do you know why that's the syntax?

Hi, This one is vexing me. Class property: Public Property Get avInputs() As Variant() m_avInputs = Me.InputRange.value avInputs = m_avInputs End Property Inputrange.value is a valid assignment set in class initialize. The precursors seem to be ok: Sub test() Dim OPR As New...

I'm not sure that this is the right path: Better solution might simpler (IE: outlook rules) or SP Workflows. Worst case, this is maybe an Access thing.

Hello Chandoo.org! Long time, no talk. I bring a random question that I can't - for the life of me - figure out. The set up. I have table like so: Name, Message FriendlyNameA, "This is a string of text" FriendlyNameB, "this is another string of text" I make an email call to insert...

I can't believe I'm having this trouble! I've got a series of time stamps. They're just time. IE: 2:35:00 PM. There's a date in the output, but it's wrong. If I change the formatting it's like 1/1/2001 2:35:00 PM. I need to do two things: 1) With a formula, change the date to the...

I bump into this a lot: mysql isn't a bad idea, firebird works with a little bit tweaking.

You're not going to get ms fanboyism from me......but Excel is probably the only software that I actually pay for. Sure. There's some offices that have ditched the MS Office Suite all together. I'm certain of it. I just haven't worked for or with any of those companies. Point being, I'm...

iirc, you set the pivot table filter by addressing the cell where the pivot table is---that's fine---but still if you change the pivot table like reordering the filter you might just end up with the same problem in your initial post.

I don't think there's a way to do this with get pivot data and I can't really think of another way to do this. My "best practice" for this is to just express the whole pivot table and make clever use of grouping instead of messing with the filters.

you don't need the percents when you fill in the parameters I think.