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

  1. owrsome

    Merged e-mail in Word doesn't reach Outlook Outbox

    When I click "Merge to E-mail" in Word, my merged e-mailing goes nowhere. The message is in HTML and includes merge fields from a .txt file exported from MS Access. I have limited the first dispatch to a single recipient, myself, for testing. It does not go through Outlook's Outbox, nor does it...
  2. owrsome

    Transform from columns to rows?

    I have data in two columns Company1 Apples Company1 Pears Company1 Cherries Company2 Cherries Company3 Apples and want to tranform to four columns Company1 Apples Pears Cherries Company2 Cherries Company3 Apples I'd be grateful for advice.
  3. owrsome

    indexing individual words in multi-word fields

    Thanks for your reply! My text is commentary and thus differs greatly from one record to another, almost no two alike. In this case, can I assume your "Nope" applies? Do you know if I get the search ability if I move the dataase to SQL Server? Any thoughts about using a...
  4. owrsome

    indexing individual words in multi-word fields

    My Access database feeds .asp pages on my website. The pages regularly search for keywords in the database's multi-word text fields. Is there a way to speed these searches by indexing the individual words in the multi-word text fields? (I believe that indexing the text box indexes only the...
  5. owrsome

    Combine one record per item with multiple records per item

    Duane, Many thanks for hanging in with me. I installed your module and inserted your query. The query produces a syntax error which I am trying to find, but even when I get the query to run, won't it concatenate LinkText and URL in one field? I need each in a separate field.
  6. owrsome

    Combine one record per item with multiple records per item

    OK. I have searched the Tek-Tips FAQ's and How-To's, which appear to deal with concatenation or the production of a multi-field table, as well as other websites. Unable to find a ready-made solution or explanation of my problem, I have given myself a crash course in SQL. I've abandoned the IIf...
  7. owrsome

    Combine one record per item with multiple records per item

    Query 1 looks like this (simplified): BoatID(auto) Boatname(text) Beam(number) Etc. BoatID(auto) Boatname(text) Beam(number) Etc. Etc. where each record is a different Boatname Query 2 looks like this (simplified): LinkText(text) URL(text) BoatID Sequence(number)...
  8. owrsome

    Combine one record per item with multiple records per item

    The SQL for the (simplified) query is SELECT DISTINCTROW qryBoatCalcs.Boatname, qryBoatCalcs.[Beam-ft], IIf([qryBoatClicks].[Sequence]="1",[qryBoatClicks].[Linktext],"") AS LinkText1, IIf([qryBoatClicks].[Sequence]="1",[qryBoatClicks].[URL],"") AS URL1...
  9. owrsome

    Combine one record per item with multiple records per item

    I am building a product database to support a web site, and am having trouble combining fields from two Access queries into a third. The first query contains one record per product while the second query contains multiple records per product. I want the third query to have one record per...
  10. owrsome

    Count query

    I'm trying to count the number of records in my Vendors, Products, Specifications, and Books tables by their Topic field. Each table has a Topic field and Topics are records in a fifth table, Topics, and its field Topic is related one-to-many with each Topic field in the other four. I want to...
  11. owrsome

    Subform data lost when filled in before containing form has data.

    My Form (for the One table) contains a Subform (for the related Many table). If the Subform is filled in before any data goes into the containing Form, all Subform controls go blank when the user leaves the Subform to fill in the Form. How can I either 1) permit filling in the Subform before...
  12. owrsome

    Multi-table form

    I can see how separate forms for separate tables can reduce the problems I'm having, but I would be grateful if you can send me the example you offered. I can't seem to get the thing to work as you specify it, and I need to find out where I'm screwing up. Many thanks.
  13. owrsome

    Multi-table form

    Thanks, Neil. I changed the WhoSellsWhat table's key to multi-field keys (vendor and product ID's). When I use the vendors/products form to enter a new product for a vendor already in the vendor table, I get the "because they would create duplicate values" error. I'm not sure I...
  14. owrsome

    Multi-table form

    Thanks. It works! But it brings me to another problem. I want each Vendorname and each Productname in the underlying tables Vendors and Products to be unique. This will prevent me entering Vendor A with Product A, forget that I entered it, then enter Vendor A with Product B, and wind up with two...
  15. owrsome

    Multi-table form

    I want to enter data in three related tables through the same form. The tables are: Vendors, with fields named vendorID (key), vendorname and city; Products, with fields named productID (key), productname, and topic; and WhoSellsWhat, with fields vendorID, productID, and relationship. The...
  16. owrsome

    Finding dead hyperlinks in a table

    I store URL's in a hyperlink field. These, along with other field values, are pulled onto ASP pages as needed. Is there a method within Acces (or a utility I can get) that will periodically check these URL's on the web and report those that are dead?
  17. owrsome

    Simple question on .mdb files (i think)

    The question is very simple... Should the .mdb file be in a different format? The one file works, but I can't seem to get any other .mdb file to run with this code.
  18. owrsome

    Simple question on .mdb files (i think)

    Ok, I'm sure this is something I'm just overlooking, but I have an asp script that reads from a .mdb file using the following code... (Basically this works on one .mdb file but not on any others. So, I assume the error is in the format of the file, but I can't figure out the difference.) // //...

Part and Inventory Search

Back
Top