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!

  • Congratulations bkrike 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: Carenne
  • Content: Threads
  • Order by date
  1. Carenne

    Query to change values to lowercase (conditionally)

    Hi everyone -- I'm going to be importing a HUGE (single field/single words) list (20,000+) words into an Access table for manipulating and exporting into another application. Initially, the list will look something like this, with many repeats of each word: preliminary preliminary Preliminary...
  2. Carenne

    Subtotals based on Yes/No field

    Hi everyone -- I'm having trouble producing some calculations in a report and hope you can help me. This is in Access 97, and the report is based on a query that contains two related tables - a customer name table and a service log table. The service log table has a column for dollar total per...
  3. Carenne

    Forms Creation Utilities?

    I'm wondering if anyone knows of any third-party utilities or plug-ins available that are designed to streamline the task of working with the cosmetics of a form? I'm thinking of all the little stuff that takes so much time. I'd like to be able to say "Take these 6 objects I've selected and...
  4. Carenne

    Request for Recommendation of Online Courses

    I took a beginner's level Access course years ago and have been getting by with that, supplemented by the online help, LOTS of reference books, and posting questions to forums like these. But I run into a lot of frustration (and subsequently waste a lot of time) when I run up against the...
  5. Carenne

    Repeat from previous field if empty after update

    I have three fields in a form (not the same fields I described in a previous post) which will often be sequential (one-time) repeats of the same field in the previous record. I know I can use the Ctrl+' feature to repeat the data from the previous field, but I'd like to make it even easier and...
  6. Carenne

    Setting Default Values Based on Last Record

    I have a form that has four fields for which I want to set default values. Due to the nature of the data entry process, the values will be the same in these fields for dozens and sometimes hundreds of sequential records, and then it will need to change for the next dozens or hundreds, and so on...
  7. Carenne

    Unlinked Forms (Rafe?)

    Rafe, hope you're catching this. You mentioned in a response to one of my other posts that you often use unlinked forms. I'm wondering how you get all the data linked correctly when you do that. I've had occasion when it made sense to me during a certain phase in the form's creation to do that...
  8. Carenne

    Changing the field default via a form

    I have a field on a form which is not tabbed to and contains a default value (which is a foreign key to the main table which the form is based on). This value will stay constant for hundreds of records, then the user will need to change it for the next few hundred, and on and on. I would like to...
  9. Carenne

    Toggle Tabbing Off and On

    I have a form with several fields which I would like the users to be able to easily toggle back and forth as to whether they want to automatically tab there or not during the data entry, without having to go into design mode to change the settings. Can I do this with controls on the form somehow?
  10. Carenne

    Maintaining Historical Data in a Field

    I have created a database for someone to manage an ongoing project that requires weekly invoicing to a client and payment to numerous subcontractors. I have three tables - a "master" table which contains the date (of books) received and invoice date, a "detail" table which...

Part and Inventory Search

Back
Top