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 Mike Lewis 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: *

  • Users: TomB
  • Order by date
  1. TomB

    CR 7 and Access 2000 ?

    Got it. It wasn't a CR thing at all. The converted database was a little bit screwed up (only one table). All reports that access this table came up with the error. Now everything is OK. Thanks a lot, 'cause you put me in the right direction ! Tom
  2. TomB

    CR 7 and Access 2000 ?

    First: 'Unknown Function Name' (Headline: Database Error) Then: ' Error detected by Database DLL' I just figured out that some of the old Reports work just fine if I change the Database. Only a few come up with this errors .... ???? Thanks Tom
  3. TomB

    CR 7 and Access 2000 ?

    OK, may be I'm a little bit to stupid for that: If I create a new report I can connect to Access 2000, no problem. But if I try to change the Database for an existing report from the old db to the converted one I still get an error ... ??? Can someone please open my eyes ? Thanks Tom
  4. TomB

    CR 7 and Access 2000 ?

    Yes, got it. It is: http://support.crystaldecisions.net/communityCS/FilesAndUpdates/access2000drivers.zip.asp Thanks Tom
  5. TomB

    CR 7 and Access 2000 ?

    Can I use CR 7 Reports with Access 2000 ? I get an incorrect table list if I connect to an Access 2000 DB. Is there anything I have to know ? Thanks Tom
  6. TomB

    Data Control and Access 2000 ?

    But that does not update the Data Control ! Or at least I can't get it running ... The access with the Database Object works with 3.6, what do I have to change in the Control ? Thanks Tom
  7. TomB

    Data Control and Access 2000 ?

    I have to update an old application which uses the Data Control to connect to an Access Database (98). Now it should connect to an Access 2000 DB, but it can't open it. Is there any way to make it work without replaceing all controls ? If I have to replace the contols which new ones should I use...
  8. TomB

    Outlook Address Book..Does any code Exist for this?

    I'm working with Office 2000 (OLB 9.0). You should check the NameSpace properties in the object browser. I don't know if there is something different in olb 8.0, sorry. Tom
  9. TomB

    Common Dialog box

    You can find this in the General discussion-Forum : cdlg.CancelError = True On Error Resume Next cdlg.ShowPrinter If Err.Number = 32755 Then MsgBox ("Cancel") Tom
  10. TomB

    Disable ComboBox dropdown button?

    I don't know how to disable, but to hide it. Set the Style property of the combo to 1 (simple combo). But the user can still see the other listitems by using the arrow keys. Tom
  11. TomB

    the Optional parameter

    isMissing doesn't work with the Integer argument. If you don't pass a value for b it gets value 0. And your result is c + b = 4 (4+0). Tom
  12. TomB

    Speeding up grid loading

    It's me again, try this: You can put the text in a cell directly: MSFlexGrid1.TextMatrix(row, column) = newText You don not need to set the col and row property. Tom
  13. TomB

    Speeding up grid loading

    The property name is MSFlexGrid.Redraw ! Tom
  14. TomB

    Speeding up grid loading

    I am not sure, but there should be a property of the FlexGrid like ScreenUpdate which you should set to false before you load the data and then set it back to true. Hope that helps ... Tom
  15. TomB

    Help ! update recordset from other recordset

    Is it possible that some values are Null ? Tom
  16. TomB

    Outlook Address Book..Does any code Exist for this?

    Hi lulo, try this: Dim ol As Outlook.Application Dim ns As Outlook.NameSpace Dim ct As Outlook.MAPIFolder Set ol = New Outlook.Application Set ns = ol.GetNamespace("Mapi") Set ct = ns.GetDefaultFolder(olFolderInbox) no = ns.AddressLists.Item(1).AddressEntries.Count For i = 1...
  17. TomB

    VBA Excel

    If you want to add a PageBreak at a specific point then: YourSheet.HPageBreaks.Add Before:=ActiveCell Reference the Excel OLB in your VB App and you can see all constants, objects and methods. Tom
  18. TomB

    Alt Ctrl Delete, Help

    There is a way for Windows95/98 but I think none for WinNT. If you want the solution for 95/98, let me know. Tom
  19. TomB

    HOW DO I DISABLE USE OF TAB KEY TO USER

    TNN, try this: Set all tabstop properties false. Private Sub Text1_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then KeyAscii = 0 TabIndex = Form1.ActiveControl.TabIndex + 1 Form1.Controls(TabIndex).SetFocus End If End Sub You don't need the sendkeys. Use the tabindex property to move...
  20. TomB

    Adding to Rich Text in Rich TextBox

    I had the same problem and I found a way to work around: Set the SelStart Property to the End of your RichTxt and then add the new text with SelText = newTXT. I don't know if this is the best solution, but at least it works ... CU Tom

Part and Inventory Search

Back
Top