Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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