Search results

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

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

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

I've checked the archives for answers to this question, but none of them seem to apply. I have a query as follows: SELECT weblist.[CD Action], weblist.[Digital Action], weblist.[CD Num - Original], weblist.[CD Title - Original], weblist.[Print List Text] FROM weblist ORDER BY weblist.[CD...

I have a field which must be checked monthly for characters. Right now I'm using menu Find and Replace with a query, but I'd like to automate the task using a macro. For example, the field contains the following text string: Banging and boppin’, hip-hop with a “street” feel; percussion I...

I have a field which must be checked monthly for characters. Right now I'm using Find and replace, but I'd like to automate it using a macro. For example, the filed contains the following text string: Banging and boppin’, hip-hop with a “street” feel; percussion I need to remove the MS...

I'd like to run a search and replace on a query result to remove carriage returns, linek breaks and tabs from the data. I know that MSWord has character aliases that will allow you to do a search and replace - does Access have an equivalent for these? Thanks! Susan

I have two fairly simple tables and have joined them in a query. One of the tables contains a memo field. When I join the two queries, the memo field results appear in a foreign character set which a co-worker has identified as Korean. The only language in this system is English. What's...

Using Access 2003, I continue to receive the "Compile Error: Error in Loading DLL" with the following code: Public Sub s_runMe() Dim cn As ADODB.Connection Dim rs1 As ADODB.Recordset Dim rs2 As ADODB.Recordset Set cn = CurrentProject.Connection Set rs1 = New ADODB.Recordset...

I am trying to run the following Macro: Public Sub s_runMe() Dim cn As ADODB.Connection Dim rs1 As ADODB.Recordset Dim rs2 As ADODB.Recordset Set cn = CurrentProject.Connection Set rs1 = New ADODB.Recordset Set rs2 = New ADODB.Recordset rs1.Open...

I'm attempting to save the data in a table to an excel spreadsheet using the Transferspreadsheet command in a Macro. I don't know VBA. Transferspreadsheet is the only command I have in the macro. I've listed the table, the location of the spreadsheet name, the spreadsheet name . . ...

I created a query that involved an IIF statment: cattext: IIf(IsNull([parentcatdesc]),([categoryDescription]),([parentcatdesc]) & " (" & [categoryDescription] & ")") When I view the query, it looks fine. I changed the query to MakeTable and created a table. When I view the table, the...

I use the following code underlying a combo box search form for a database: Private Sub OK_Click() Dim Where As String Const ObType = "Form" Where = Where & MakeSQL(1, "completeddate", 8) Where = Where & MakeSQL(2, "MDEissue", ?) Where = Where & MakeSQL(3, "library", 10) On Error GoTo...

What Microsoft product do I need to buy that contains the packaging wizard that will aloow my Access appliaction to run on a machine that does nopt contain Access? Thanks! Susan

I have a simple database - no links - that uses a form for record entry and look-up. I would like to prevent the fields in a single record from being updated or changed after a particular field (completeddate) has been entered (i.e. is not null). Once that completed date field has been...