Does anyone know how to get the address of a cell identified by vlookup?
For example, if Vlookup(Key, Range, COl#,false) points to cell C4, I need to return C4 (or $C$4).
The vlookup range is in another spreadsheet, if that makes a difference.
Thanks for the code, but I'm stuck again.
I haven't worked at all with DAO (but I'm reasearching it over lunch).
The calling code is giving me problems.
What I'd like to do is select a table by name, and then set the properties on a subset of the fields, so that (for example) for an address...
It won't cause any errors, because it's only done at the time a db is setup.
Here's what I'm trying to do. In the next 3 months, I will have to roll out approx. 600 databases, all with Access front ends and sql back ends. They all start with the same tables and Access objects.
To set up a...
At the moment that would be difficult. It's linked to an SQL database. I could create a stand-alone version, but I have to strip out some identifying data and build the tables, and I'm leaving for the day in 15 minutes.
If I haven't cracked this by late AM tomorrow I'll post a copy.
I need to requery a subform from a third form and can't seem to get it to work.
frmForm1 has frmAddress as a subform. The button cmdReviseAddress opens the form frmUpdateAddress where all of my validation work is done and the new record is added.
However, the new address is not being...
Thanks for the reply.
You noted:
If it was not setup as a file DSN, and sometimes as a file DSN depending on the version of windows, there might be a registry entry containing the DSN information
It was;
That's never happened before, but I will look.
I know it's not on my machine, because other users on the network can access the DB when my machine is lost.
I was hoping there was a way to derive the location from inside of Access, but I don't think that's possible.
I can't find the file dsn for an Access DB. I can refresh the tables, and I've looked for all of the *.dsn files on the drives where it might be and I can't seem to find it.
Is there any way to get the location of a file dsn from the linked table?
Thanks!
A woman awakes during the night, and her husband isn't in bed with her. She goes downstairs to look for him. She finds him sitting at the kitchen table with a cup of coffee in front of him. He appears to be in deep thought, just staring at the wall. She watches as he wipes a tear from his eye...
It’s pretty ugly data. I think you’re going to have to loop through your input table and make intelligent guesses about what gets imported and where it goes.
It seems that to be a valid message, the first line must be Message:#. Then you want to capture anything in the formats:
Date: blah...
OK, I wrote (stole) this over a year ago, and I no longer remember how it works, but it does. I modified from code that closed the calculator. The original code is still here, but commented out.
Good luck, and YMMV.
Option Compare Database
'************** Code Start ***************
Private...
Here's how I accomplish the same thing.
I have a hidden, unbound text box that holds the name of teh query you want to use as the record source.
The form has a default record source.
Using the Form Load event, you can set the record source to the desired query:
Private Sub Form_Load()...