Search results for query: *

That work absolutely perfectly. Thank you!!! Patrick

I have a situation where I've got multiples of an item that I need to make unique. I can find them using a find duplicates query. What I want to do is append them to a table that has an autonumber field and then use that number to append to each duplicate to make it unique. For instance, two...

That was the problem, I didn't have the thing set to wrap text, thank you. This site is great!!!! Patrick I used to work in an orange juice factory...I was canned because I couldn't concentrate.

This is a follow on from an earlier post where my problem was with Access. Now I'm in Excel and want to force a new line in a cell. When typing this manually, Alt-Enter causes a new line with a cell. Is there a way to make this happen when concatenating text? I know the command sequence...

Worked great, I like simple fixes like this. I can't tell you how much time I spent researching this. You'd think somewhere there would have been an answer to this question in Access' help area. Oh well. At least there is one on Tek-Tips now. Thank You Patrick

How can I encode a carriage return in a concatenated field? I've got some text that looks like this (say this is from a field called [Q_TEXT]: THE PART IS QUOTED AT $3.25 MARKUP 1.25 When I run a query, the text will print just like this and that is what I want. It also comes out in a data...

THANK YOU! That worked magnificently! This is a very simple solution that, while crude, works very very well Thanks to you and Vic for all your help. Nice!!!!!! Patrick

Hi Vic, Hi Remou, Hope your weekend was a good one. I've been away. Am I SOL? Patrick

Vic, I don't do any editing with the queries. I just have them in edit mode becuase that is the default in Access and I don't mess with it. The first two just increment a counter. It is very crude, but, as I said, I'm not really a VB programmer. My last programming events were using Quick...

I've got to go off-line for a few days. I'll be checking back in on Monday. Thank you. patrick

The path is: C:\Documents and Settings\pairus\My Documents\Rockwell Project\MFG_Notes\ Macro is: 1)SetWarnings 2)OpenQuery: Query Name: Update T Counter; View: Datasheet; Data Mode: Edit 3) OpenQuery: Query Name: Update T Counter 1; View: Datasheet; Data Mode: Edit 4) OpenQuery: Query Name...

The report's name is test. I'm in a macro then I use the OutputTo action. The report gets it information from table T2. The fields I fill in are: Object Type: Report Object Name: Test (test is the name of the report) Output Format: Rich text Format Output File: Retval & ".rtf" Autostart...

Thanks both of you. They both look like what I'm trying to accomplish. On the first one, I'd need to run a counter, right? I tried to implement the second idea by creating a module. The contents of the module (named module1) look like the following and it put Main in the upper RH part of the...

I'm sorry I'm not clear....I'll try some more. [group_id] is a field, it is located in the report header so when the report runs, I can get multiple lines of text for each [group_id]. The information for all the reports is in one table but, I am using a set of macro driven queries so that for...

I'm using a query to filter the data I want which is then used in a Report. The reports will created one time, I was planning on using OpenReport and or OutputTO from the access macros. As far as the code, I don't know, I don't know what is required. The field names are Group_ID and Note_Text

I have a couple thousand reports to create as part of a data migration project. The information is in a table and I'm using reports to put the data in a report format to be OutputTo in RTF format so I can use them as attachments, etc. I can't sit and type all of these names and am wondering if...