Search results

That worked like a charm! Thanks so much. It's exactly what I needed.

@nanscombe Finally got some time today to play with the database you created. I imported my own data table and then changed "theMemo" field in your tblRawData table to field NBS_Update in the Remedy CCRR Data table. Note that I changed the field name to include the "_" to avoid the space, as I...

THANK YOU! This is very cool. I ran your sample an it worked exactly the way I wanted. In your example, you are running the Fingerprint and Result for display form for one record ONLY with an event procedure attached to the "click me". The raw data remains untouched. I just need to...

Thanks! As I don't see ANY references to either the table name or the field name, where do I put this? I want it to happen when I load this form, as it's the first thing that happens when I open up my Database. It would have to happen right after I import the data to the new table (I delete...

Thanks, I will give it a try and let you know how it goes!

Greatly appreciated, Thanks!

Sorry, I meant "File". I export the file from Remedy in CSV format. It will not preserve the CR/LF. I know they are there, because if I open the record in Remedy, it does a CR/LF before each of those dates.

@CJ London: I tried the query. It ran, but came back with errors. The problem I have with that is that I run several queries BEFORE I run the different reports, and the reports are based on different queries, so I really need the original file to be modified on import or I have to change ever...

myNewMemo=replace(myOldMemo, ". 2","." & vbcrlf & vbcrlf & "2") A couple of newie questions: Do I need to DIM myNewMemo and MyOldMemo or are you referring to the fieldname "NBS Update"

Thanks! The bold was just so you could see the dates. They are not in bold in reality. All dates are in the 2000, nothing before 2009 actually. I cannot guarantee there is a full stop and space ". ", before each occurance of the date, but there is a pretty good chance. Unfortunately...

I import a CSV field which has not preserved the CR/LF when it was exported from BCM Remedy. There is no setting for that. The memo field prints on my report like this: 2012/05/23 3:13:45 PM PCOLLINS This is not considered an emergency, but should be reviewed in more detail to see if this site...

The reason I want to do this is to make the report easier to read. Right now it all runs together. So, when do I perform this split? Right after I import, or right before I print?

The BMC Remedy "Export to File" function has no options for preserving CR/LF. All I can do is choose the file type as "CSV", "ARX" or "XML". I have been using CSV as it's the easiest.

When I export my Remedy data to a CSV file, it automatically removes the CR/LF (not sure why). As a result, when I import the CSV file into an Access table the field becomes one LONG line of text. FYI, the import specification has that particular field set up as a memo field. Here is an...

I wasn't able to upload my zipped file (being blocked at my end), and my development db is too large to attach. I have attached a couple of jpegs instead (I have removed all sensitive info, such as addresses and costs). The inital query "NSB Dynadocs Inventory for NetCon" restricts the list to...

Let me put something together and post later today. Thanks!

All solutions should be that easy. I have another issue I have a post open for. Not sure what to do about it. Any suggestions? http://www.access-programmers.co.uk/forums/showthread.php?t=217555&goto=newpost

That worked. Thanks!

I had been deleting and overwriting an existing table with imported data in a Event Produre on a form opening. It has worked fine for the past couple of months. I then created a relationship between that table and another, and discovered I can no longer delete the table as it has a...

Regardless of whether or not the syntax is correct, the first code statement above (the only one I have tried) seems to take hours to process and has yet to complete -- I have had to crash Access to get it to stop. I suspect the performance is negatively impacted by both the dcount being done on...