Cantr Objects Database Program

[Emandir]

When I put cantr.mdb in C:\cantr\cantr, I got a 3024:
"Fichier 'C:\cantr\cantr.mdb introuvable'." (File... not found)
It is there though!

When I put it in C:\cantr (with Cantr.exe), I've got a 13...



Jean-Luc

[west]

I just unzipped them both to my desktop. Worked fine.

[Junesun]

Same here: works fine.

Judith

[Anthony Roberts]

Ok, here's the code for adding a column to an Access database:

-----------------------------------------------------------------------------------

Dim dbsYourDB As Database
Dim wrkLocal As Workspace
Set wrkLocal = CreateWorkspace("", "admin", "")
Set dbsYourDB = wrkLocal.OpenDatabase(App.Path & "\xyz.mdb")
Dim tblNew As TableDef
Set tblNew = dbsYourDB.TableDefs("Name of your table")
With tblNew
.Fields.Append .CreateField("Name of the new column", dbText)
End With

----------------------------------------------------------------------------------

This opens the database xyz.mdb, assuming it's in the same path as the program exe (App.Path), goes to the table called "Name of your table" and inserts the column "Name of the new column" as a Text field. If you need another field type, you can find the list of type constants in the category DataTypeEnum in the DAO library (part of the object catalogue). I think you can take it from here.

Judith

Thanks very much, I'll put this in my code and see what happens.

When I run the application, I get 'runtime error 13, type mismatch' ... anyone else who experienced this?

This error means that some variable is trying to be put into another variable of a different type. Ie: It's trying to put letters into a variable with numbers

But you get it when it RUNS? No idea why... something must be wrong in the program.

dunno if it's just me or if i need another programme but i can't even get the thing to run it gives me a run time error in axtive x

and

A couple of things

First Anthony Thank you for doing all this work. You are the man...nest to Jos....and well...never mind lol

But I'm also getting a run-time error

Run-time Error '429':
Activex component can't create object

If I had more knowledge in codes I might have been able to figure this out my self........let this be lesson to everyone...stay in school and don't get kicked out for breaking some jerks hand after he slaps his girlfriend. Just stay in school.

Run time error in ActiveX. NOOOOO IDEAAAA what that error means, lol. It -could- maen you're missing the Visual Basic 6.0 Runtime Datalink Libraries. But, usually you get an error "VB6somethingorrather.dll missing" type error. You can try and download the VB6 Runtime DLLs and see if that helps. Ya need to go to Microsoft for the file. It's like... 8 MB, I'd say? No idea.

When I put cantr.mdb in C:\cantr\cantr, I got a 3024:
"Fichier 'C:\cantr\cantr.mdb introuvable'." (File... not found)
It is there though!

When I put it in C:\cantr (with Cantr.exe), I've got a 13...

Jean-Luc

No idea why this is happening. Are BOTH files (The cantr.exe AND cantr.mdb) in the same folder together? They need to be... maybe that's the problem. Even though you say they are in the same folder, maybe you moved one? Or even, renamed cantr.mdb to have a capital or something? No idea why this is happening... - I said that already.[/quote]

[rklenseth]

Just to let you know, I am not having a problem. To those that are, make sure you unzip the file first. It won't work otherwise.

[Spectrus_Wolfus]

Just to let you know, I am not having a problem. To those that are, make sure you unzip the file first. It won't work otherwise.

yeah jos unzip it before ya run it hehe

duck's behind his iron sheild and hopes the toothpick of doom misses

[Anthony Roberts]

Just to let you know, I am not having a problem. To those that are, make sure you unzip the file first. It won't work otherwise.

yeah jos unzip it before ya run it hehe

duck's behind his iron sheild and hopes the toothpick of doom misses

The error Jos got has nothing to do with running the program from inside the zip program O.o;

[kasuo]

Hey, good work Anthony. I'm glad to see the database is up and running. Hopefully this will help in speeding up searches for tool building as well as reduce bandwidth use for searching through the tools on the site.

[Nick]

I'm an idiot, I wasted like 20 minutes today looking through the manufacturing page for different things.
I forgot I had this program!!!

[Anthony Roberts]

Hey, good work Anthony. I'm glad to see the database is up and running. Hopefully this will help in speeding up searches for tool building as well as reduce bandwidth use for searching through the tools on the site.

That was the plan. Look at this code...

If Anthony Cuts Down Bandwidth Then
- Jos Thanks Anthony
- Anthony gains benifits that no one knows about
Else
- Everyone Hates Anthony
- Anthony cries
End If

Plus, Nick, I feel for you. I -wrote- the program and did the same thing too! I'm a dolt.

[Anthony Roberts]

Hey Guys,

Sorry there's been a lack of update at all for the program. Weekdays I don't seem to have the time to code, but on the weekend I'll see what I can do.

In any case, why am I posting? Just to bump the post to the top area, so that more people can see that there's a program here that will help save Jos's costly bandwidth, give me more recognition (Not that I care ^.-), and allow more people to use it and find any problems with it (So far).

If I could make this a sticky I would, doesn't need to be though. Anyway, time to go do some coding, a little bit at that!

For everyone that has posted so far that has used this program, I ask that you send me a PM with your Real Name (If you'd like), Website (Also if you'd like), and your public e-mail address (Yet again, if you'd like) so I can put you in the credits as testers. That'd be great, thanks!

[Nick]

I am getting Visual Studio 6 this week, and I have a lot I want to add to your program

[Anthony Roberts]

You have fun with that I want to see it too, just to see what you've done ^.^ If I may, of course.