Recent content by hadwin

Thanks for the answer... Only problem is I am using am using MS Access 97. I don't believe Access 97 have ADO, only DAO.. Is there any way to work around this? I am thinking since I'm sure Access 97 have the "Select Data Source" window already, all I need to do is to find out how Access call...

Hi everyone, I have a database that retrieve a bunch of data from an external Oracle database through ODBC, it then save them as local tables. I therefore have a lot of SQL Pass-Through queries. I used to have a manual process of clicking on each query, to retrieve one table at a time. I now...

I should add I can already reference Excel through code such as Dim xlbook As Object 'Excel.Workbook Set xlbook = xlapp.Workbooks.Add Dim oSheet As Object Set oSheet = xlbook.Worksheets(1) but some function such as CopyFromRecordset are not available...

Thanks Soctt & Wayne, Scott, for some reason I can't find the Excel Object Library under the list of references available on Access 97. But under Excel 2000 I clearly see a Excel2000 object listed. Are there certain steps I need to take before I can reference the object?

Thanks Wayne for your quick respond... I did look into tricks to get around the lack of conditional formatting with continuous form, both on this forum and just by google serching.. All the ideas I run across seems to be along the lines of .... putting a textbox with background behind the real...

Hi all, I am really stuck on this problem :confused: Hopefully someone can give me a few pointers. I am running Access 97, I want to do some conditional formatting on a form. There is no conditional formatting feature (i.e. formatting such as different background colour dependent on value) in...

Please update link to Mike Gurman's Code Hi, The link mentioned "http://www.access-programmers.co.uk...TML/004538.html " is out of date If possible can you please publish or update the link to Mike Gurman's code? I am trying to figure out how to do conditional formatting in Access 97, while...