Help

Opening MS Paint and Pasting Via Code
In my not too successful attempts to get an OLE chart object (Graph 11.0) that has been manipulated on a form to be reproduced on a report, I am considering the following procedure. First copy the graph area to the clip board (easy enough using Me.OleGraphControl.ChartArea.Copy). Next open an instance of MS Pa... 17 Oct 2006 13:01

My Calendar control button stopped working.
After opening and clicking on the popup calendar command control button, "fdlgCal"; I click on a given date. The date is suppose to then appear in a date field next to the control. Instead, I get the following error: "Microsoft Office Access The expression On Click you entered as the event pr... 12 Oct 2006 20:47

Help with table and form design
Hi, I've got a two part question on table and form design (sorry for the length but it takes a bit to explain). Our sales department uses a look-up table to help the them select the best equipment to use for a customer's needs. It basically consists of a table with the following setup: Equipment: Option1... 13 Oct 2006 14:38

Picking up focused data from continuous form
Thanks in advance... I have a form displaying the results of a query in a continuous form style. I want to be able to double-click on the key field of the form (a textbox, in this case a AssetID) and use this to populate the AssetID textbox of another form. Any ideas on how to link these? Thanks! Bhavesh ... 11 Oct 2006 11:08

ControlTip Text Doesn't Work
I just noticed that control tips aren't working in any of my databases. I recently installed Access 2003, and created a database in it, and noticed that control tips weren't working in my controls. I was using control tips with command buttons in the form header. But they also didn't work with the command butto... 13 Oct 2006 01:59

MAPISendMail question - repost
130 Targets(0) = "smtp:CRCI(a)NorthState.net" 135 MySubject = "Some relevant subject" 140 MyBodyText = "Blah, blah, blah" 150 Call SendMailWithOE(MySubject, MyBodyText, Targets) SendMailWithOE invokes MAPISendMail courtesy of the msoe dll in the outlook express folder. (see function declaration) ... 4 Oct 2006 20:00

date time
hi all ! i am doing a query to calculate the difference between a time in a field and the present date/time. the problem is its producing the result as a decimal value of a day. how can i get it to produce the result in days & hours ?? thanks brino ... 2 Oct 2006 08:02

Webservice Complex Types
Hey guys, I googled for nearly 3 hours - but no result... We run a web-service and want to reach that service from Access. In the following part you see the wsdl content and the automatically generated class. I need advice to get the input/output running for this service. Thanks for your help Thomas ... 13 Sep 2006 05:50

Excel Import Problems
I'm hoping the answer to this is that I'm just doing something silly, but I'm really scratching my head over this one. I'm importing data from multiple workbooks, each workbook has a sheet called SubSAT and I need to get specific data from that into the database. I'm finding that if I have the workbook open on m... 11 Sep 2006 07:21

filtering duplicate fields with unique rows
I have a query that outputs the following, A | Name1 | Date1 A | Name2 | Date2 B | Name1 | Date1 B | Name2 | Date2 I would like to see, A | Name1 | Date1 B | Name1 | Date1 In some cases, there could be more than 2 duplicates for the first column field. I would just like the first row of each duplica... 5 Sep 2006 16:23