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

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

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

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

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

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)

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

Is there a simple way to make a field on a registration form comply to a hidden list? I want to limit the zipcodes that can be entered on my form to those in my list...all 439 of them. I don't want to have a huge drop down list, however. Any SIMPLE solution? I can't muck around with...

What's the opinion of everyone about Microsoft Access 2007 and it's incomprehensible ribbon, attempt to reorganize itself and those "multivalue fields"? Should we fear it or love it? Do we have a choice?

I have an Access database split into the tables and a complicated ever-evolving frontend. It lives on our LAN, and right now there are at least three people using it daily. Is there a way for everyone to work in just one frontend (with the latest changes, on our LAN) or do I always have to...

How can I type a number in a field on a form, then click a button (or set an afterupdate event procedure) to multiply that number by whatever temporary variable number I type into a message box? Ya know what I mean?

Just curious what everyone else's opinions are on abandoning tables for web layouts in favor of div tags & CSS...

Is there a simple straight-forward way to clean up all the debris in my database...it's pretty complicated, and as I was designing it, I created and abandoned lots of macros and event procedures, a few tables, several queries, a few weird fields, lots of stuff where I don't know what the heck I...

thread702-838396 OK, it took me three years to answer this one. Just kidding...I was looking for an answer to this question, and came up with a simpleton answer. Create two or three or fifty unbound text boxes all the same size, make the text for each one a different color and the background...

Thought this might be a useful expression to someone somewhere. DOB is, of course, date of birth. I dare you to remove some of the parenthesis... AgeAsOfJan1: IIf(IsNull([DOB]),"No Age Listed",(Fix(((((Date()+1)-Format(Date(),"y"))-[DOB]))/365.25)) & " yr, " &...

I have a wretched Paradox db that I have to keep intact (it reports some data at the end of the year to government beancounters), so I've built a MS Access db with links to tables from the Paradox db. I want to add an autonumber field to one of the Paradox tables that contains a list of names...

I have a database of information including kids and their parents. I want to also indicate that some kids are siblings (not always evident by sharing a parent!). This might be simple, but I just can't figure it out. All I can think of is making another table that creates a random "sibling...

Is there a simple way to have the option to put the date in a date field as well as have it default to something like "N/A" when the user enters N/A or something simple like 0 (but no other text). I don't want to get too complicated, and I'd like to leave this field as a date field or a number...