Search results

Hi, Sorry I'm little confused here, you say Do you mean you want "ABCDE" on the report as that's the ORDUNIQ 4546 corresponding value in the OEORDHO table. Also do you now need to rows of data, "ABCDE" and "DEFG", as there are 2 VALUEs in OEORDHO, which relate to 4546. I haven't got XI one...

My bad, I didn't read the help files at all it would seem. Use .SentOnBehalfOfName = "jackie@tjmcconnells.com" However it was all in the helpfiles!!

Third answer first, as it's the most important. The help files from 2003 say (It's worth looking at those first, honest) Second question has been answered by Bob, but, also from help files: First: Admittedly I don't know, nor can I find it. The old Access 97 helpfiles had all the memory...

No problem. Make sure you take Pat's Access advice whenever you can :) BTW, that little known forum http://www.mrexcel.com/board2/index.php you said, 'seems like a good place to reference things like this:', is about one of the biggest Excel forums out there. I am an MVP on it and Moderate...

Ah, Jackie, you found me out. I read the help files and it said 'a name from your address book' I gueesed at the 'or email' bit :o I suppose it depends how your email is set up, I wouldn't know how to use the Glodal Address List (GAL) in outlook. I am assuming you are using Outlook Exchange at...

Jackie, You need to add SenderName: With MailOutLook .SenderName = "The name you want" .BodyFormat = olFormatRichText Change "The name you want" to a name from your address book or the actual email address. Cheers,

I've been trying to answer this for AGES, so I've brought it home as it won't post at work. As Pat says you can add the sheets to the same workbook. However, I wrote this at work I'm gonna post by god! ------------------------------------------------------------ If you need the pretty...

Sorry it taken AGES to get back to you. I have tried since last week to answer this at work and decided to bring it home. Sonce bringing it home I have thought of a second way in which you can do this (see further on) but I might as well ut my effort to paper, as it were. This code is just...

Hi, A) Why don't you just use Excel? B) Why do you want them merged? Is it to add to your database? Cheers,

Hi, I wouldn't do what you are trying to do. Don't have calculated fields in your table, just have them in a query at run time. You'll be forever updating your table as new data is added. Anyway, you Inner query shouldn't be working as you are asking for 2 fields to be returned. But I urge you...

Why aye!!! I'm fairly certain I put, 'or something similar'. Anyway, I re-read your request and realised I mustn't have bothered properly the first time :o whoops I'm not fully sure why you would have both businessname's in the query? Or both contactname's either? Anyway, You could use...

Does it noe need to be,[referrer_mainbusinessname],[referrer_secondarybusinessname]) or something similar, if it's returning a result, but not the right one, you are asking for the wrong field.

Firstly, 'Its me again.' holds absolutely no useful information about the question. Please try to describe the problem in the subject. OK, you say, 'each are to be treated independently of the other because for the most part their fields are different' Can you please post what each table has as...

Can you post exactly what the row before might contain compared to the current row, I'm fairly confident my link can be changed to suit. If you can provide an example of the query without the calculated 'row before' data, that would be helpful. All it is doing is taking the Date of the current...

Helo, I'm affraid I'm just leaving work so can't fully answer your question, but I can see what's going wrong. The 'qd.Parameters![Name of Portfolio] = PortName' is working fine, the point at which it is asking you for the Parameter is: DoCmd.TransferText acExportDelim, "AB BONDS RPT"...

I see what you are doing, As I have already mentioned, please please please keep to 1 thread, I gave you most of the code you have in another thread. Of which you haven't replied, also mentioned. For others info: http://www.access-programmers.co.uk/forums/showthread.php?t=134094 You also...

If you are using dates, the following might be helpful: http://www.access-programmers.co.uk/forums/showthread.php?p=621177#post621177 Cheers,

I concur with the others. Post your code please. I'm not sure how old either o the others are but: I'd say you need a table or query on your query. Joking aside, you don't have many posts. Please read the following and you will find the riches will be flowing: How to ask questions the smart...

Sorry for taking a while to get back to you. Can you describe what is happening please? I have created a report the has Group by on the Account number from the orginal table, then a subreport using the query I gave you and linked Master/Child on Account Number and get a report. Not sure what...

Hi, Firstly, please don't post related questions in 2 different threads, reading this one doesn't allow anyone to help you with the code you have in the other one. (I they aren't related I appologise) Secondly, please please please, do not have titles like "pls help me...", I don't usually...