Search results for query: *

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

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.

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

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

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.

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

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

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

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

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

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

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.

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

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

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

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?

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.

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