Search results

Access 2000 SR-1/SP3, Windows 2000 sp4

No, and it isn't in the list either. What does it do and if needed, where can I get it. Indeed I ran the Component Checker. But thanks to your reply I noticed that three files have no more info than the filename, so no versionnumber etc. They are, msdart.dll msdaorar.dll msorc32r.dll Rings...

Looked on the microsoft website. But nothing fixed the problems, none added to ;) I find that the currentproject.connection class is not registered. The strange thing is that it passes the dim cnn as ADODB.Connection declaration without an error, but it gives the class not registered error...

Yes I have, version 2.5 it says. There is nothing in this list that indicates that this is missing.

Please take a look at the updated db. Make sure u click on the apply filter button.

Hi, I'm using a piece of code I found at mvps. And uptil now it has worked perfectly. It resets the autonumber of a table to a specified number. Function ChangeSeed(strTbl As String, strCol As String, LngSeed As Long) As Boolean 'You must pass the following variables to this function. 'strTbl...

Thank you both I've got it working with the four seperate tables. But I can also see the benifits using only 1 table. However I've got a question about the 1 table approach. The table will have all the fields that are in the seperate tables, and an identifier field for the type of info in the...

Hi I'm struggling to make a overview report. Let me first explain what I'm trying to do. I'm making a project managment database for my company. Each project consists of 3 types of costs which are put in different tables all with an identifier field which is the projectcode. So I have four...

Hi, I'm going to design a access database with which I want to conduct a survey. The survey is about cataloging some product which are available in the market. To do this cataloging I've stated four subcategories. Now I have to give a score to every possible combination of values from those...

Hmmm, and then use BitBlt to torture it into the right position. Anyone experienced in BitBlt in VBA?

Thanx but I forgot to mention I need a filled triangle. I was afraid it couldn't be done. Maybe a lot of lines next to each other with an increasing length would do it, but does anyone know what linewidths are used by access? Any ideas?

Hi, I want to draw a triangle on a report. I know it's possible to draw rectangle and cirles but not any other form. Is it also possible to rotate an object for an arbitrary number of degrees. Thanx in advance

I know, but this doesn't work with the UNION statement. I get the error message that the tables should have the same number of fields. M.

I'll try that. Would make it much simpler to not even have have a recordset as an intermediate.

Hi, I want to make a query that searches multiple tables for a specific string, f.i. Like '*an*' The tables have to be seperated because they contain different data. It's a database where I keep my collected info on a project. I have a table called "Literatuur" and a table called "Informatie"...

Hi, I want to export a recordset which I created at runtime to a Excel table. I tried to use docmd.outputto .. statement but I can't get it to work. Dim rst as Recordset Set rst = CurrentDB.OpenRecordset("SELECT * FROM strTable WHERE [Name] Like '*', dbOpenSnapshot) DoCmd.OutputTo...

Hi, I attached your db but working as you wish. The dot-filenames are located in a new table called Templates, to which the combobox refers. HIH Michelangelo