Search results for query: *

nah, thats too messy. this needs to work on most of the computers in the building!! I can't beleive microsoft would build in something as useful as this but not let u code with it!!! someone must know!!!

tried that also and nothing shows up in the code!!!

That works ok but if you actually go into xp and select file>send to>mail recipient (not "as attachement"). This actually puts the data into html format then into the body of the email itself. I can make a new mail message from excel vba but i can't figure out how to get the sheet...

sorry mate, nothing there about it. if no one can help me on that perhaps someone could tell me how to open an outlook new mail message, copy the excel sheet and paste onto the mail message and send it?

sorry it only says bout the workbook method. im really pullin out me hair here!

Plase can someone help. I need to send the contents of an excel worksheet via email exactly how you do it if you select: file>Send To>Mail Recipient. Im using excel xp and need to code this in vba. Ive tried the sendmail function but this sends the whole thing. Many thanks Andy

I have the following stored procedure: SELECT mv_rep as Rep,mv_account,aca_name as Name,sum(mv_cost)as Cost, sum(mv_sell_value)as Value, sum(mv_sell_value - mv_cost)as profit, datepart(month,[mv_date])as Month,datepart(year,[mv_date])as Year From movements m1 INNER JOIN ADDRESSES ON(...

Nice simple one but i cant get me head round it. What i want to do is IF the field [pr_Discount]=Y then add 30% to the field [pr_Cost]. All this in one query if poss

yep thats it all the same except include just the single product he bought the most of.

bperry, ur a life saver! it works!!! the sales date field is just date, there is a seperate field containing the time but like u said im just looking at general sales. ok, ur really good at this so here is another im working on. I would like to add into that query u just gave me, the product...

Thanx guys, just got into work, im gonna try this stuff now and give ya a shout later to see if it works. and i was planning on having an easy day today!!!!

bit of a novice, so stay with me a minute...... What i need to get in a stored procedure is the equivilant of several access queries. what im trying to get is a list of customers who havent bought anything in the current month. Then for all of the customers who havent bought in the current...

i have a stored procedure called as_spAnalysis. I have an excel spreadsheet called sheet1. I need to pass to the stored procedure the month and year which gets entered into seperate cells on the spreadsheet (sheet1, a2 and b2). I need to, at a click of a button, return the information and have...

thanx

any chance i could have that in an access query?

ok here is what ive got. tblRep2: name Postcode andy ec1m 4gg tblNorth: Postcode ec1m4 in tblnorth there are the beginning of some postcodes. In tblRep2 there is a list of companies with their names and full postcodes. What i want to do is select all of the companies in tblRep2...

im trying to replicate a table up to my web server but im getting the following error when i try to input something into the "type field" microsoft OLE DB provider for ODBC Drivers error '80040e07' [microsoft][odbc sql server driver][sql server] the conversion of a char data type to...

can u insert a webpage into a .swf or flash movie in v6?

what i want in the end is a line graph that shows a running total against a running target. so i tried doing this in a report but i cant base a graph on a report. Next plan was to have a make table query which does a running sum on the cost for each day, then i will be able to base the graph on...

how do i get that to work? ive got: ident date value cost ashur001 01/10/01 £10 £5 ashur001 02/10/01 £20 £10