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...
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...
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...
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
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...
Hello:
If this control has a field from your table bound to it, you can go to your table design and select the field that holds this entry and in the Field Properties section put:
the value of zero. Then each time you make a new record, this control will have zero
Regards
Mark
Hello
I believe you can do that by using the AfterUpdate event of your combobox to set your forms recordsource. Then just requery your form.
Regards
Mark
Hello:
Here you go.....
http://msdn2.microsoft.com/en-us/library/aa141505(office.10).aspx
http://msdn2.microsoft.com/en-us/library/aa141474(office.10).aspx
http://www.aspfree.com/c/a/Code-Examples/Creating-a-Chart-using-Data-from-a-Database-with-MS-Chart-Control/
'
Regards
Mark
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.