Search results for query: *

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)

QUOTE: You stated "interface has to be easy for my users". Do your users mess around with report design? Not if I can help it QUOTE: Going back to your original post, why do you "have to dumbgrade up to MS Access 2007 from 2003" Because our University has rolled over and decided to succomb...

VB and SQL not a problem...will check out Crystal reports, but the interface has to be easy for my users, some of whom only use Access a few times a year.

It's really the Access interface/forms in 2007 that causes all the problems. I'm willing start from scratch, but would prefer something that's similar to Access, since I know it so well.

Looks like I have to dumbgrade up to MS Access 2007 from 2003, but I'm disgusted with MS Access 2007 like the rest of the world. What's a better db? Currently, I have developed several dbs with lots of fancy-schmancy reports, automated events, easy to use forms, complicated relationships that...

....The setting is called "reinstall Microsoft Access 2003"