realm174

Where should I post a request for qualified free Beta Testers, and what kind of background information should I look for?

Alright, here's an interesting one.

Running Vista SP1

Video card is ATI X1800

Driver is v9.8

So here's the issue. When i install the driver, do a dxdiag, Acceleration is "enabled". If I use any 3d app/game (for example, Second Life, Flight Sim, Sims3, etc) all is good. I quit the application, do another dxdiag, sometimes Acceleration is still on, but most of the time, it's Disabled. I reboot the computer (complete shutdown, power off and back on), Acceleration is Disabled, with no option to turn it back on. That happens 100% of the time. I reinstall the video drivers, all is good, Acceleration is back on. Run a 3d app again, same thing happens as stated above.

Just for the heck of it, did a test, installed drivers, Acceleration is on. Power off and back on, Acceleration is disabled, even without running any of the above mentioned app.

I did uninstall all traces of ATI drivers (driver cleaner, scanned registry and all), reinstalled the ATI drivers, same thing happens.

Any idea?

Does anyone know of a site with a similar concept as answers.yahoo.com, but without the thousands of students looking for someone else to do their homework for them, or the other thousands too lazy to search the net themselves? I guess I'm looking for something a little more mature, or advanced, or profesionnal, especially where people would stick to the topic at hand (ie, Programming).

thank you.

I came across an example that looks like this:

Public Sub OnClockTick2(ByVal sender As Object, ByVal e As

EventArgs) Handles MyFirstButton.Click, MySecondButton.Click

Console.WriteLine("Received a click event of first or second button")

End Sub

which gives me an idea of what I am trying to do. I have a form with multiple textboxes, and I want to do the same thing for each of those textboxes when text is changed in any of them. My question is, however, how do I determine which textbox was changed? Would it have something to do with "sender" ?

thanks!!

We have a lot of mdb (Access 2003) that use macros to do various things. In particular, it sends tables to various email addresses, exported in MicrosoftExcel(*.xls). This works perfectly under access 2003, however, it won't work in 2007, as MicrosoftExcel(*.xls) is apparently an invalid format. If I go on the pulldown menu, I see that the option has been changed to Excel 97 - Excel 2003 Workbook (*.xls), and if I change it to that option, the macros run just fine.

There's a lot of mdb's involved, and a lot of macros in each of them, so manually changing all the output format is not really an option.

I was therefore wondering, is there a way to use vba to perform the sendobject instead of the "canned" method? I already know I can use docmd.sendobject, however, how can I tie that sub to the macro option, if it is possible?

thanks in advance

I am using an UPDATE to affect possibly multiple rows in a table. The SQL query looks like this:

UPDATE AR_SYSTEM_AR_USERS SET ACTIVE="N" WHERE EMPLOYEE_ID IN (165404, 165818, 158046, 169010, 226475, 154646, 180763, 194616, 222167, 193440, 191877, 154252, 223172, 153144, 191415, 207675, 164307)

I need to have a message showed to the user stating which rows have been updated (not all employee ID listed will be in the table, therefore, not all of the ones on the condition will be updated). Of course, the employee_id listed will be different each time a session is run.

I know how to show the number of rows affected, but I need to be able to display something along the lines of:

Employee ID's x,y,z have been updated, the rest of them were not found.

The (pertinent section of ) code I have so far to make the update is as follow:

FileToRead = xlApp.GetOpenFilename("Excel, *.xls;*.csv", , "Select file containing most recent meters")

If FileToRead <> "False" Then

xlApp.Workbooks.Open FileName:=FileToRead

Set xlSheet = xlApp.Worksheets(1)

row = 2

Query = "UPDATE AR_SYSTEM_AR_USERS SET ACTIVE=" & quotes("N") & " WHERE EMPLOYEE_ID IN ("

While xlSheet.Cells(row, 1).Value <> ""

TermEIN = xlSheet.Cells(row, 1).Value

Query = Query & TermEIN

row = row + 1

If xlSheet.Cells(row, 1).Value <> "" Then

Query = Query & ", "

End If

Wend

End If

xlApp.Quit

Set xlApp = Nothing

Set xlSheet = Nothing

Query = Query & ")"

'DoCmd.RunSQL (Query)

And that part runs fine. It tells me the number of rows being updated.

Any help will be greatly appreciated.

Hello fellow helpers, This time, I have a question...

I have a workbook with multiple sheets. I need to link certain cells from one sheet to another, via VBA. That, in itself, is quite simple. However, what I am hoping to accomplish is to "underline" only certain words in the cell containing the hyperlink. To further clarify, I am trying to underline the word "Here" in a cell containing "Click Here".

Note: the cells don't actually contain "Click Here", I am only using that as an example to illustrate that only part of the words on the cell need to be underlined.

Everything I have come across so far use the entire cell content as a "friendly name" in the hyperlink.

Any assistance will be greatly appreciated!!

thank you,