Search results

Replace what? I would love to use the replace function (Access 2003), but have no idea what characters to enter into the find field to find and replace. I know tab in word is ^t and paragrah mark is ^p and line break is ^l. Are there equivalents in Access? Thanks. Susan

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

My work-around This question was never answered. My work around was to turn the Query into a Make Table Query for the first time it was run. I changed the text field for the new table into a memo field. I then changed the query to an append query and created a second query that was a delete...

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

Newbie at VBA - need help. MAke sure you have a reference to ActiveX Data Objects Um . . . how? Where do I go to check that? Compact & Repair your database Done. and decode your database as well. Again, how? Thanks very much - I am learning so much from you people! Regards, Susan

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

Looks good . . . but need more help please. I really AM a newbie when it comes to VBA. Where would I place this code? Thanks! Susan

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

Looking to set a query output to memo from text I have a similar problem. I have a query, which I use to fill an MS Word report document. I concatenate two memo fields in the query, but the resulting new field is a text field with a 255 limit. Is there any way to set the data type for that...

Thank you! That was exactly what I was looking for! Thanks!

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

For 2003? Is this a version of Office 2003 for XP? Or is it an earlier product? Or a completely different product? I'm trying to find it on the Microsoft website to get a price and content quote and can't find it. Thanks. Susan

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

Perfect answer for Publisher section! Jon - believe it or not, this is THE perfect answer for the publisher section of my flat file, because I need that information split into two fields. Query1 runs just fine. You're right about Query2 running slow because Query1 results in just under...

Beautiful! Thanks very, very much! I imported the queries and they work perfectly for the Composer section of the database, as it can import into a text field. I'm exchanged a non-delimiting character for the comma and it seems to work just fine. That's exactly what I needed for the...

Query construction Yeah, that's what I thought. But I can't figure out how to break that composer field automatically into the requisite fields for a single record. My table has the following records: Track, Composer Right now my query results in three records: Track 1, Composer 1 Track...

Exporting as a flat file to database This is coming from a new database and being transferred into an old DOS database that's part of an ancient proprietary program that's written in a language so old it may as well be sanskrit. It's going to be deprecated in in a few months, but until that...