Search results

They come from two fields - sorry it wasn't clear from the mail (it looked ok, when I typed them in). In the meantime I struggled togather a code (taking everything from newsgroups here) that does this, (I had a parameter in the query which created further complications)...

Thanks, it worked fine for me.

Hi Pat, this is very helpful to me too. Could you tell me how this situation would look like if the parameter was not in the query that you actually wanted to open but in a previous query that this one refers to. Thanks for the help.

I have records in the format of: AAAAAAAAAAA 3 BBBBBBBBBBB -4 CCCCCCCCCCC 5 I would like to display them as: 3*AAAAAAAAAAA-4*BBBBBBBBB+5*CCCCCCCCCCC Could somebody tell me how to achieve this?

I would like to search my text field "altavista" style, which means using quotes for expressions and - sign for words that must not be in. I am sure this is quite a common task. Does anyone of you already have a code for that? Thanks for the help.

Chris, can you also write out report in snapshot format?

Could you create one big report and include the 30 as subreport? Than you would only need to export one.

Well, DevTipText is the Memo field. This is the query that only returns 255 character from that field: SELECT DevTips.DevTipText FROM DevTips INNER JOIN (Comp_temp_select INNER JOIN DevTips_toComponents ON Comp_temp_select.AutoID = DevTips_toComponents.CompAutoID) ON DevTips.ID =...

Jee, I found the answer, and it is weird. If it goes trough a query that has Total in it, it gets chopped down to 255 characters. Queries withouth Total are OK. Now what do you say to this...

they are set to yes. I also tried to create real large text boxes for the memo but no luck

I have a table with a memo field. They usually contain more than 255 characters. I checked it and in the table they are correct. However when I produce a report on it only the first 255 character appears from the memo field. I am using a text box to display them in the report. Should I use...

Anauz, I know you must be tired of pressing the Send button by now, but could you send this code for me too? Balazs.Klein@shlgroup.com Many thanks.