Recent content by fmm

What's brown and sticky? A stick!

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.

Is there a keyboard shortcut to move from the Properties listing back to the form in edit mode? Thanks!

I actually figured it out last night, but your method is much cleaner. Thanks for your help! fmm

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...

Thank you, I will give this a shot.

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...

I have a model db (Access front end, sql back, linked tables). I need to be able to change input masks at the table level in code. Any ideas? Thanks!

This works: Forms(lsTemp)!frmAddress.Form.Requery

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...

It looks like I get everything except the name & location of the actual DSN file. Thanks anyway.

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!