Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: conneticat
  • Content: Threads
  • Order by date
  1. conneticat

    Change button caption to a field text value

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

    Adobe LiveCycle ES2...simple question

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

    MS Access 2003 to 2010; events suddenly want field names instead of control source on a form?

    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()...
  4. conneticat

    Great 1 to 3 day GIS Classes...

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

    Problems importing Excel sheets

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

    ! is this a bad character for file names?

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

    Locked myself out...how to open a db in design mode?

    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).
  8. conneticat

    Create a query that smooshes data into one field on a form?

    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)
  9. conneticat

    Best alternative to MS Access?

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

    Validate input in a form based on a list?

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

    Is Microsoft Access 2007 as revolting as it looks?

    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?
  12. conneticat

    Multi users in one form?

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

    Variable in an Access Form?

    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?
  14. conneticat

    Tables vs. Div Tags

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

    Tidy up my database...lots of leftover debris

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

    Conditional formatting in list view

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

    Age as of January 1...expression

    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, " &...
  18. conneticat

    Add field to linked table (Paradox)

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

    Sort of a many to many relationship

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

    Simple way to put text in a date field?

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

Part and Inventory Search

Back
Top