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 strongm 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. mvdmeij

    memory leak?

    Don't know which version you're using but Delphi 6 had a bug, (see http://info.borland.com/devsupport/delphi/fixes/delphi601/database.html) Info: Area: database\dbexpress\tsqldataset Reference Number: 114136 Status: Fixed in Delphi 6 Update Pack Date Reported: 6/11/01 Severity: Serious...
  2. mvdmeij

    MSSQL driver error

    I guess it's the following: On the SQL server itself it's proosible to use characters which the BDE doesn't handle (spaces, dollar signs etc.) To handle this kind of syntax you need to use brackets [] for the tablename/quer/view Hope this helps... Good luck, Mark. PAC Greenware...
  3. mvdmeij

    Backing up text files

    WinAPI is the interface to Windows functionality. An API is an Application Programming Interface. Windows uses DLL's which contain general Window functions, some of the functions are exported and can be directly used in your Delphi program bij using the WinAPI (see the WIN32 SDK help files)...
  4. mvdmeij

    Restoring a backup from a CD

    SQL7: In the enterprise manager, from the menu select Restore database. Select from device, click select device.. Select: Disk Click Add Give the path to the CD. Good luck, Mark. PAC Greenware http://www.pac.nl
  5. mvdmeij

    Bad Token Received

    Maybe this will help: http:// support.microsoft.com / support / kb / articles / Q199 / 1 / 05.ASP http://support.microsoft.com/support/kb/articles/Q136/3/90.asp (error on SQL 6, solved(?)) The problem can also be caused by network hard/software. Not much but hope it helps... Good luck, Mark.
  6. mvdmeij

    ODBC Failure on TCP/IP

    Could you give some more info: What kind of db-connection is used (e.g. OLEDB, ODBC, ADO..)? What the update looks like in the access application? How long it takes for the update to complete? I can't imagine that such a change to the network, will have an impact on the application. Unless...
  7. mvdmeij

    Dates in SQL

    The default is US english on SQL server, but on the PC the regional settings will be used to display/input dates. So, I guess you don't need to make conversions. If you do for some reason use FORMAT (in access) or CONVERT (in SQL). Check the Books online of SQL server for more information on...
  8. mvdmeij

    DLL Problems

    I think the DLLTEST isn't of much use for you... Better have a look at the Dependency Walker, which gives you the information you request (should also work on WinNT). Also have a look at this site, here are some very useful tools for debugging & monitoring: http://www.sysinternals.com Good...
  9. mvdmeij

    add.new help

    This will not work... rstNew!GetRows = rst!GetRows First of all the part to the right rstnew!GetRows doesn't work, Access expects a Fieldname to which a value is parsed. Something like rstNew![Name] = rst![Name] (so you have to specifiy the fieldnames). Second: for adding another record you...
  10. mvdmeij

    Totals on a form

    The form Registration should be based on a table (e.g. tblRegistration) with the fields mentioned. The form Totals should be based on a query in which you select and aggregate the totals you want. I don't think you will need any coding.... Good luck, Mark.
  11. mvdmeij

    NT and Dr. Watson

    rst2.Fields(0).Value is an existing db? No (security) restrictions on accessing it? Correct path to the database? I guess one of these is causing the problem... Hope this helps, Mark.
  12. mvdmeij

    Merge Excel files

    By using references to the other worksheet: use references in the workbook where you want to merge data: =[Name.xls]Sheetname!CellAdress (e.g. =[test.xls]test!A1 Mark.
  13. mvdmeij

    DLL Problems

    Tools are also available on http://www.stanford.edu/group/itss-crc/projects/public/w2k/Utilities.htm for function reference use this one: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winui/hh/winui/winuserstart_88bp.asp Good luck, Mark.
  14. mvdmeij

    Comdlg32.dll - version 4 vs. version 5

    I guess something has changed with the parsed structure OPENFILENAME may'be this link is helpful for solving your problem: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winui/hh/winui/commdlg3_1hma.asp Hop this helps!
  15. mvdmeij

    create a local drive name for a particular dir

    the dos command is: SUBST S: C:\CLIENT42
  16. mvdmeij

    ActiveX problem

    I didn't mean you should create a batch file in Access, but just a DOS batch file, something like this example activex.bat copy filename.ext c:\windows\system\*.* regsvr32 -s c:\windows\system\<file.ext> <path>\msaccess.exe <path>\<database filename> Hope this helps....
  17. mvdmeij

    linked excel chart in access report won't update unless excel is open

    Don't use copy and paste but instead use the menu Insert, menu-option Object. Then select the workbook containing the chart and check the link box. This will insert your chart as an OLE (object linking and embedding) object, assuring it will be updated whenever you update it in Excel.
  18. mvdmeij

    ActiveX problem

    1. Locate the file containing the ActiveX control (filename.ocx, I guess). 2. Create a batch file which: - Copy the ActiveX component to C:\WINDOWS\SYSTEM of the PC - Register the ActiveX component (regsvr32 -s c:\windows\system\<file.ext> this sets the necessary registry...

Part and Inventory Search

Back
Top