Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mhartman1

    Microsoft Access

    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...
  2. mhartman1

    Microsoft Access

    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...
  3. mhartman1

    Deleting all Visio Background pages with VBA

    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...
  4. mhartman1

    Chart Data Source

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

    Chart Data Source

    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...
  6. mhartman1

    ColorRGBToHLS Function usage

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

    ColorRGBToHLS Function usage

    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...
  8. mhartman1

    Removing Blanks from Text Field

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

    same event on lots of fields

    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
  10. mhartman1

    How to embed Excel chart

    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
  11. mhartman1

    Access97 vs AccessXP(2002) changes list

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

    Control Source in Text Box

    Your welcome!
  13. mhartman1

    Control Source in Text Box

    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
  14. mhartman1

    Global function

    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
  15. mhartman1

    Giving Field a Value

    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...
  16. mhartman1

    Giving Field a Value

    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
  17. mhartman1

    Can I use a combo-box to select the source for my form?

    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
  18. mhartman1

    Validation rule based on a query

    Hello You can set your validation rule in the table or set the rule in the combo control in the properties window. Regards Mark
  19. mhartman1

    How to use an Access data field to create an automatic bar graph

    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

Part and Inventory Search

Back
Top