Search:

Thanks.

Thanks Sid that works. You say that "One can also automate this". How would that be done.

BTW I don't know if it's better, the same, or worse but I get the temp path with this one-liner
...

Thanks Sid. I'm on my way out the door and I'll try that code when I get back later today.

A server for which I have the path.

I don't think we are communicating too well. The situation is this. The user is using the current version of the workbook that I'll call wbOld and there's an existing workbook which I'll call wbNew...

You replied to a 2 1/2 year old thread.

They'll get version 26 manually but from then on it will be automatic since version 26 and all future versions will contain the code you write for me:)

Okay. Unlike VB6, Excel doesn't seem to have an application version number so I just added a constant in the workbook with a value of, say, 25. In the Access database there's a table that contains a...

I have an Excel workbook where there's a version check done on open against a master database and if the versions don't match the user is told to download the latest version of the workbook from the...

I worked it out a different way.

I have a table called Requests and I'd like to return values grouped by the month value of a field named 'Sentdate' which is formatted in the database as a General Date. I tried the following but gat...

Got it

MsgBox rs.Fields(0)

Thanks.

Okay I did this. How do I display the count?


.Open "SELECT count(*), SentDate FROM Requests group by SentDate", cn, adOpenDynamic, adLockOptimistic
.MoveFirst
Do While Not .EOF
MsgBox...

I have a table called Requests and I'd like to return values grouped by a field named 'Sentdate'. I tried the following but got a recordcount of -1. What am I doing wrong?

rs.Open "SELECT...

Never mind, there was a quote at the end.

Thanks but it's a syntax error not a wrong result and in any case this (where I've just duplicated the working part) isn't correct either


.Open "SELECT * FROM Requests where RequestType = '"...

I have some code where this works fine



With rs
.Open "SELECT * FROM Requests where RequestType = '" & Cells(Target.Row, 1) & "'", cn, adOpenKeyset, adLockOptimistic, adCmdText

...

Thanks everyone.

@sid: All will be Windows PCs but I don't know if the operating systems are consistent. I can find out though. BTW I love the logo in your signature.
@westconn1: I'll look into the Visual Data...

Strangely accdb seems to be the only choice.

1 to 3: Yes that's exactly want I want to do and other than the apparently non-trivial task of actually opening the database (read on) I'm sure I can do it with ADO. As for my other similar thread I...

It's been ages since I've done anything with Access but I seem to remember that I should be able to read/write to an Access database as long as that's all I want to do and I don't need reports or...

Yes, I want to store to a database and track the status of transactions that are generated from an Excel workbook. I at first thought of using a shared workbook as the database to store the...

I'd like to use Access to store data that can be read from and written to by multiple users of Excel at the same time without the users having to have Access installed. How can I do that?

Thanks.

I have a form control (not ActiveX) listbox on a sheet that has 'Selection Type' set to 'Extend'. How do I determine which entries are selected?

Okay, mistake number 1. I want to make an add-in for the VBA IDE but the above shows up in the Add-ins tab of the workbook.

I'm trying to write my first add-in for VBA. I have this code and it runs without error. Stepping through it the second time cbrWiz is not Nothing which says that it exists, but i don't see it either...

Life is tough.

It looks like the code is based on my Spell Check a Textbox that I mentioned above. Take a look at that code and see what's different.

I understand better what's happening now but let me amend the question since my description of the "thought experiment" unintentionally added a factor that is, I believe, adversely affecting some...

So a few feet of air makes that much difference?

The string doesn't touch the floor until it sinks below 5 feet.

I guess I'm getting (too) old but I just can't wrap my head around this.

Imagine a mylar party balloon that's filled with helium and which is attached to a 10 foot string. At the end of the string...

Si (or westconn1), I'm getting back to this and I find that I'm still confused. Can you show me a complete set of code that specifies both the source and destination sheets?

Thanks. For the life of me I couldn't find the Thread Tools menu.

Where is Thread Tools|Mark this thread resolved these days?

ActiveSheet.Range(ActiveSheet.Cells(4, 8), ActiveSheet.Cells(10, 8)).Select

Thanks Si, I'm sure that's it. In my code I bounce around between sheets and I ran into other places where after...

What do you mean when you say "fully qualify"? And why is the Range Cells index method different from the Range A1 method?

The cells of the active sheet of an Excel workbook.