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

    Convert yes/no to bool for Excel export

    I need to convert a yes/no field to it's Boolean equivalent prior to exporting to Excel. Dilemma: I have a table I export to Excel. While the table shows -1 and 0 for the Yes/No entries in the table, once it exports to Excel, it changes to TRUE/FALSE based on the data in the table. I need to...
  2. roxannep

    Globally replacing letters in Table, Query, Other Names

    I have a database that I need to clone and then change a few letters in fields, table titles, etc. (the company name changed, and I thought this would be easier than trying to go through every table, qry, macro, etc., and manually changing two letters in the name). Example: query titled...
  3. roxannep

    Calculated Field for Multiple File Nos.

    I work in Access, but have a request from my kid's HS band teacher and this needs to be done in Filemaker Pro. (Reminder to self: DO NOT VOLUNTEER to help "Create" a database until I know for sure what software they are using!) We volunteers are building a sheet music database (I am the only...
  4. roxannep

    Need to edit recordset thru query, MAX also needed

    I have two tables: Contacts and Transactions. It is a one-to-many relationship (Contacts-to-Transactions). I am trying to come up with an editable recordset in datasheet view using this relationship. The hitch is that I need to display the Contact record only once for any and all times it finds...
  5. roxannep

    Filter or query that allows edits

    I have two tables: Contacts and Transactions. I need a way to filter the Contacts by Transactions over $500. The common field is ContactID in each table. I can easily do a query, but I need to make an edit to the Contacts record. Naturally, all transactions meeting the criteria show up...
  6. roxannep

    Splitting data entry from one field into multiple fields

    I need to split out some data in one field and have it pasted into separate fields. Example: Fields: NAME, FIRSTNAME, LASTNAME NAME: Bob Jones needs to split out: FIRSTNAME: Bob LASTNAME: Jones and empty the NAME field. In some cases, middle initials are included so how to handle those...
  7. roxannep

    Query First and Last Record of Most Current Batch

    I need to have a message box come up showing the contents of one of the fields in the table based on the most current items entered. The user sometimes must enter 25 identical records except that each one must have a different file number (example: inventory but each item is given it's own...
  8. roxannep

    Message Box Reporting Variables

    Situation: Currently have a form that user inputs inventory item data in unbound boxes, including one indicating how many times to duplicate the item. These items are sold singlely in various locations at various times and must be tracked individually with their own unique identifier. To...
  9. roxannep

    Select one record from Summary List

    I have a query with a record summary by title. My boss would like to have a box to click on the left side of the list and then have it pull only one record of that title into a new table for export to Excel. Example: My query results would look like: DENOM TITLE COST COUNT $1...
  10. roxannep

    A2K, Different OS's, Maximum Users?

    I have a client that I support who called asking what their maximum number of users is for their Access 2000 dbase. They have had no problems with the dbase until just recently. Today they started receiving a message that it could not allow any more users on (unfortunately no one wrote down the...
  11. roxannep

    Upper/Lower Case Changes

    I have recently "inherited" a database and in designing and running reports, I have found that the original programmer inserted the ">" sign into many of the tables' fields' format property. Problem: when producing some reports, we need names to show in upper and lower case...
  12. roxannep

    Pull Data from Table or Return New Data to Said Table

    I am trying to set up a module that pulls the address information (address, city, st, zip) from a table called HOUSEHOLDS to the table called PLAYERS when I enter the phone in PLAYERS. It should compare it to HOUSHOLDS and pull the appropriate data if it finds a match. I keep getting an error...
  13. roxannep

    ZIP code auto-fill

    Okay, this one is pretty basic but I'm about out of tries: I need to have an entry in the field ZipCode of my Players table retrieve the city and state from LU_Zip which contains that information. Problem: The ZipCode field may contain 5 digits, or 9 depending on if we have the +4. The LU_Zip...
  14. roxannep

    Multple Queries One Report New Twist

    Having reviewed what's already been posted, I have not found an adequate solution to my delimma, so here goes: I have a Transactions table, from which I'm querying records for a sales report. The necessary fields are: PaidDate, AmtPaid, RefundDate, Refund, Cost1, Cost2 When the Sales Report is...
  15. roxannep

    Email Problems - Crashes Access 2000

    Below is coade I'm using to send individual emails (recipient doesn't see everyone else's email in "to" field). Problem is it crashes Access 2000 after only one or two records are circulated through (the first record of the set). Any ideas .... perhaps I'm missing something in code. I...
  16. roxannep

    Access and Outlook 2000 Not Communicating Well - Any Ideas?

    I converted a database from 97 to 2000 wherein I have emails going to recipients. The email is in VB and the recipients and variables are pulled into a table via MakeTableQuery based on my criteria. This all worked lickety-split fine in '97 versions with Access dumping out each recipient's...
  17. roxannep

    Select Case Giving Me Errors! Code needs help?

    I have a Make Table Query that sets up a table wherein one field may have one of three options. Depending on the option, a particular email message needs to go out to them. Below is the code (and I am new to this, so please bear with all the obvious errors), and I get a message back telling me...
  18. roxannep

    OutputTo in Module Not Working!

    I have set up a module to run "OnClick" from a form button. In putting in the DoCmd.OutputTo line, I keep getting errors telling me that I don't have an Object Type listed. Since I am trying to export the string as it is and there is no form or report that it attachs to, I must be...
  19. roxannep

    Need to Generate Variables in HTML Report

    I have set up a report that has HTML code in it and then has fields where the variables are needed. All of this is exported to an .rtf file (which is why I have to have HTML code as part of the report itself) which our operator then copies into a bulk loading auction program that only accepts...
  20. roxannep

    Export to Excel, including HTML code

    I've tried a variety of scenarios and exports to get this to happen with no luck. Perhaps someone has a method that would work! I need to export the results of a query into an Excel Spreadsheet (which is forwarded to an auction site .... they are requiring .xls format). Problem: in order for...

Part and Inventory Search

Back
Top