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...
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...
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)...
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
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.
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...
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...
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...
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...
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.
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.
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.
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.
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!
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....
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.
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...
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.