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 SkipVought 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: *

  1. KristenCarr

    Data Entry Form - Search

    I have very little front-end dev. experience & I'm creating a Call Tracking data entry form. I would like to search by several columns, including LAST_NAME and ID but never more than one column at a time. I have a form and a subform. What I would like the user to do is open the (blank) form...
  2. KristenCarr

    Reports - Page Break after Group

    I have a report grouping on OFFICE_NUMBER with data displaying after the grouping. This report is actually a letter and I need a new page for each set of data. I have all the text in place but the 'details' section of the report, where all my data is displaying, is breaking the data into...
  3. KristenCarr

    Simaltaneous updating of duplicate/truplicate data in several tables

    Ahhhh...so you need the least normalized! Sorry, I don't know how to help you and I can't think of a good resource since you are, in reality, breaking all the rules. I'll ask around to see if anyone can help. Good luck!!! I'll keep my eye out for an answer for you.
  4. KristenCarr

    Simaltaneous updating of duplicate/truplicate data in several tables

    Is there any reason you have duplicate data to start with? There may be something I'm not understanding but one of the fundamentals in db design/normalization is to not store the same information more than once so as to avoid this kind of situation. I'm not sure how to fix it except to avoid...
  5. KristenCarr

    Transfer Text - Read Only Error

    I'm trying to Transfer Text using a Macro in Access 2002. The Macro worked fine in Access 2000 but yesterday I upgraded(?) to 2002, converted my db and now I get the following error: Cannot Update: Database or Object is Read-Only The read-only attribute is not checked for the database and I...
  6. KristenCarr

    Formatting Text in Make Table Query

    I'm working with a Sybase table (through Access) which stores phone numbers as Text(25) formated as (XXX)XXX-XXXX. I need to change this to be XXX-XXX-XXXX for an export to another db. Formatting won't work since it won't know what to drop, I figure I should parse it but don't know how to do...
  7. KristenCarr

    Unwanted results from IIF statement

    Thank you...it didn't work though. I can't even get the appropriate values in a Select statement.
  8. KristenCarr

    Unwanted results from IIF statement

    I'm using the following IIF statment in an Update query. The idea is to compare 2 dates (short date) in one table and insert a value into a third column in that same table. It is not giving me errors but is inserting all 'C' values. The table only has 27 rows in it right now so I can easily...
  9. KristenCarr

    Meeting Request Form in Outlook2000

    When using the Meeting Request Form to invite attendees to a meeting the message is sent as a regular email. I don't know too much about Outlook set-up but I believe we are not using an Exchange Server...is this required for meetings?
  10. KristenCarr

    Can't open e-mail session

    Creating a Macro may not be the answer. I faced this problem previously (using Access97). Sending the email worked from some machines but didn't from others, regardless of whether Outlook was open. We compared all settings and couldn't find the answers. This was never resolved, please post...

Part and Inventory Search

Back
Top