Recent content by susanmgarrett

Absolutely perfect! Thank you very much - that was precisely what I was missing. I didn't know to add the second table in the FROM section or how to handle the asterisks properly. That works properly now. Thanks for the lesson!

I have a main table that contains a text string in a field called Category. Normally, I'd just put a LIKE "*looking for*" string in the query criteria field. But I have over 2,000 text strings that I need to use as criteria (a one-time only proposition, thank heavens). I'm looking for any form...

I'm using the standard duplicates query on a field called trackTitle: SELECT TrackTitles.trackTitle, TrackTitles.akTrack FROM TrackTitles WHERE (((TrackTitles.trackTitle) In (SELECT [trackTitle] FROM [TrackTitles] As Tmp GROUP BY [trackTitle] HAVING Count(*)>1 ))) ORDER BY...

Tutorial? Thank you both very much. Can you point me toward a tutorial on creating dynamic SQL, because I haven't the faintest idea where to begin. I'm using Access 2003. Thanks.

Parameter Query? I've been doing a bit more research and suspect that I may need to create a parameter query for this instance. I can get Like "*" & [Enter first search term:] & "*" And Like "*" & [Enter second search term:] & "*" To give me the first search term and the second search term...

I'm searching for multiple words in a single field

Search criteria Keith - thanks for the help. I'm building a database to do searches on a field that contains music lyrics. So one of my users might need a son that includes the words "love" and "blue" but not "sky" (yes, we do searches like that). The search terms change with every search. I...

I need to create a user interface that will allow a boolean type search of a field. This would mean item1 AND item2 AND NOT item 3, item1 or item2, item 1 NOT item2, etc. I've set up a combo box setup with the following script, but I can't figure out how to adjust it to allow the multiples...

I'm using a module to associate like records into a single text string. My problem is that when I run this, one record (the last record) is always missing. What can I change in this module to ensure that all of the records process correctly? Thanks! ____________________ Public Sub s_runMe()...

All of the 3700 MDBs are in the same folder. The MDB to be created to hold the full file can be placed in the same folder as well. The 3700 MDB files all have the same nomenclature (xxxx.mdb) where x is a number, but they are not sequential and skip numbers. There is nothing else in the...

I inherited an interesting problem. I have 3700 tiny MDB files all of which contain the same table (same name, field structure, etc.), but different data. Each database has a slightly different name. It's the result of XML data mining. I need to combine these 3700 tables from these different...

I'm attempting to create documentation for an existing Access database - literally, it's a work-flow document. It was relatively easy typing out the list of tables, modules, and Macros, but I have god-only-knows how many queries. Is there any way to export a text list of query names to include...

I have a Make Table query that includes a new field concatenated from a numeric field and a memo field, with some assorted text elements - Issue Description:"("&[number]&") "&[Description] When I run the Make Table, the new field "Issue Description" is created as a text field, NOT as a memo...

I have a problem I should be able to solve, but I can't think my way around it. I need to automate a series of tasks to perform the following: 1. The user clicks a button on a menu form and arrive at a select records form. 2. The user makes choices regarding the contents of certain fields...

Removing Order By worked! Thank you very much. The removal of Order BY now means the field will print more than 255 characters. Thank you very much for the assist.