Recent content by conneticat

I'd like the caption of a button to change to the text of a field when the user enters the data. For example, when the user types in "Roses" in the field "Botanical1", the caption of "Button1" changes to "Roses". Nothing I try works; not setting variable values/targets, etc. I'm not even sure...

That sounds brilliant, but way beyond me. Can you be specific, like where and what? There's actually only one field that might be blank.

I occasionally use LiveCycle to create simple online fillable forms. For one form, users put the information on the first page, and it propagates throughout the document. There are borders around the fields...I'd like these fields to NOT print (no border, nothing) if the user leaves it empty...

Huh? Did you read my post. On forms, fields have properties, each field can have a name, as well as its designated control source. Events where I used the bound control used to work in 2003, but no longer work in 2010. Access isn't telling me anything in a popup. It's obvious when the event...

Finally pulling an older db into 2010... For some reason, events aren't working properly with control sources: For a simple example, this worked fine for years: [Field Name] = [Control Source]: MoneyOwed = ClassFee MoneyPaid = Payment OwedBalance = Balance Private Sub LastName_LostFocus()...

http://clear.uconn.edu/geospatial/training.htm Geospatial Training Program

Both really good suggestions! Thanks so much!

I vaguely remember something about Nz (null zero) being useful... This might help you understand: http://msdn.microsoft.com/en-us/library/bb148937.aspx

I'm trying to help someone else, and I'm not sure what he's trying to do, (and I don't "do" Excel) but... He has 169 separate Excel folders, and they all have the same headings in the same order (good start, at least). He wants to import them all into a single Access table... Question 1...

Thank you ("!") He doesn "do" Linux, so even that's no excuse. I will print this out and smoosh it under his nose.

http://en.wikipedia.org/wiki/Filename#Reserved_characters_and_words OK, Wikipedia isn't really the final word, but this is a pretty good basic list.

I frequently begin important files and folders with "!", such as !filename.pdf. I've been doing this for decades with no problems. Our IT guy believes it will crash our entire LAN-ish shared drive and end the world as we know it, and I was admonished this morning via email. This is not a...

Ah-ha...I thought it was more complicated than that. Now, we must crumple up this post and eat it to preserve the secret.

I can't remember the super secret code to open a database in design mode after you've locked it up to keep users from changing things. It's something like holding down ctrl-shift-? while clicking on the db file (no passwords involved here).

Not sure how to ask this... Query or whatever that takes one field in all the records and outputs all that data into a single inline field (I'll worry about delineation later) on a FORM (not into a report...that would be too easy)