Recent content by wolfert

Have you solved this already? I'm having the same problem now. Patrick.

Hi, I have got a serious problem (don't we all). When I import a Access2k table to SQL2k (only 57 records) some data is lost. All records are imported but one field is left empty ocassionately. The table is as followes: Table [Opmerkingen] Fields: [ISO NR] = text [Opmerking] = memo Some...

Incredible. So much programming for just a simple icon. I would just download the resource hacker util (see my above post) and save as. This saves a lot of API stuff. Patrick.

Phew. I don't know if you can rip icons of exe files with the imagelist. I do know that you can use the program resource hacker to rip icons from executibles, dll's etc. http://www.users.on.net/johnson/resourcehacker/ You can save the icon as ... and load the .ico file in the imagelist. Patrick.

Thanks. I already figured it out. I used the Datediff function to get a difference between the values and multiplied with 24 or 60 to get days / secs.

Hello, I am creating a query in Access 97 and I would like to summarize a time field. E.g. [Duration] = 00:04:03 I I sum this field in the query, I get all mixed up values like 0,67 in stead of 1:65:03 Any suggestions? Thanks in advance, Patrick Wolfert

Thanks both for your help. It isn't really a problem because SQL is the only thing running on that server. So memory is available for SQL. I discovered I could not install a new virusscanner on the server because the setup ran out of mem. I looked at the task manager and discovered that sql is...

Hello, I have a SQL server (2k) up and running (win 2k adv. server as OS). The problem is that the sqlsvr.exe's memory usage is increasing by the hour. In two weeks time, the program is using 1,6 GB of internal memory. Once I reboot the server (or restart the service), the mem. usage is just a...

Try this: DoCmd.TransferDatabase acImport, "dBbase IV", "D:\V Care\Project\", acTable, cmbhav, "D:\V Care\Project\bhav1.mdb", False, False Patrick. PATHTOFILE is just the path, not the file itself. Patrick.

Try this: DoCmd.TransferDatabase acImport, "dBbase IV", PATHTOFILE, acTable, DBFFILENAME, "D:\V Care\bhav.mdb", False, False patrick

What parameters have you given TransferDatabase. Please post the code. Also: Have you looked at the VBA help file. It contains an excellent example of both commands. Patrick.

You're welcome. Patrick.

Thanks. Works like a charm. I will set the primary key it's just that I just finished importing the table from access. patrick

Hello, I have imported an access dbase into SQL 2k. Afterwards I have done some querying / updating etc. The problem is that somehow there are a lot of duplicate records in the table. I most have made a mistake with updating the table before. I have tried linking the table in an access dbase...

I did check them and both are running under their NT-account (Administrator on the server and my own username on the notebook). Patrick.