Recent content by mhartman1

Hi Duane. Thanks for taking the time to respond. Over the weekend, I solved the problem. The problem is that I needed to upgrade the database engine for Office 2002 on my laptop that runs Windows Vista. I went that route when I ran the same queries on my desktop computer that was running...

Hi,from http://msdn.microsoft.com/en-us/library/aa217680(office.11).aspx I have been trying to get this query to work using the Microsoft Access Northwind database: The first SQL statement works fine but the second one gives an "Object invalid or no longer set." error. The problem seems to be...

Hello, I am trying to delete all background pages in Visio 2003 using the following code: Sub DeleteBackGroundPages() Dim MyPage As Page For Each MyPage In ActiveDocument.Pages 'Test for a "Background" page here If MyPage.Background = True Then 'Delete the...

Good food for thought. Thank you very much lionelhill for taking the time to respond. Have a great day! Mark

Hi everyone: I have a single column data-source for a chart that spans more than one 8 by 11 page when printed. The chart appears under the data source. I want to split the data-source into multiple columns so that the data-source and chart fit on a single page. My question is how to treat the...

Thanks Hypetia for taking the time to respond. This has helped me very much. Kind regards Mark

Hello: Can anyone tell me the correct way to call the following API function: Public Declare Function ColorRGBToHLS Lib "shlwapi.dll" (ByVal clrRGB As Long, pwHue As Long, pwLuminance As Long, pwSaturation As Long) As Long As a start, what is the "clrRGB" expecting? a hex value maybe? Or does...

Here you go......... http://www.techonthenet.com/access/functions/string/replace.php Regards Mark

Hello: What you want to do is loop through the controls on your subform using the Controls Collection: Search control collection in the help Regards Mark

Hello: Please see the enclosed link. There is a section on embedding Excel charts in other applications near the end. This may be of some help. http://www.towson.edu/adminfinance/ots/training/documentation/Excel%202003/Excel_2003_%20Charts.pdf Regards Mark

http://support.microsoft.com/kb/319400

Your welcome!

Hello Yes, you could use the Dsum or Dcount function to specify which records to count or sum. Many examples are in the help section. Regards Mark

Hello You would do this in the Modules section of Access: Create a module titled for instance, GlobalValues then open the module and place your declarations there. Regards Mark

Hello again: One other way, If this is a calculated control, because its is inefficient to store calculated values, you can use the NewRecord property to zero out your control when a new record is added. Enclosed below is the explanation from the help section of Access Regards Mark NewRecord...