Hi, do you wnat to just access and an "access" database using vb, or create your own in vb?
which versions are you using?

Hi, can you please send me a copy of your program to play about with, and I can see what I can do for you.

Thanks, I used the

Private Sub mnuprint_Click
frm1.PrintForm
End Sub

and that worked fine.
Cheers.

Sorry, when i say print, i mean output to a printer.
soz

Hi, can you guys please tell me how I can print a screenshot of a form?
I am linking to a database and I want to print the form with the names of fields etc...
Cheers

OK Guys, thanks for all your help, I copied my one from home into college and it now works. I have no idea what was wrong with it in college originally, but if/when i find i will let you know....

Hi, I just tried using this code, but got a whole load of run-time errors, doesn't seem to work with ADODC
do you have anything else?

The easiest way i find of opening an outside file is this:


shell "C:\file.extesntion"

that is it, just one line, it calls the requested file into the window shell, thereofre running it.
...

I agree with comatose, in the properties window of the command button there is a property name "Enabled" set this to what you want the button on startup, and then when in the form the code you need,...

the best way to do it is to link to the file outside as said above, just ensure that the path is correct and always links to the right file.

I'm next in on tuesday, and will do it then
cheers

Yeah, I 4got to take my flashdisk with me, I'm going to try that when i'm next in on tuesday.
Cheers

yeah, the database is the same, i just recreated the program at college and changed the paths to match, i just am really confused why one code works in one place but not another!!

Hi, this code is behind a command button, and workd when i'm @ home, but the same code will not work when at college, when i hit debug it highlights "adodc1.recordset.find tr"
Private Sub...

Hey, You can use access 2k
add the Microsoft ADO Data Control to your form, right click and then click properties.
you then want the last one and then build. make sure your database connects, then...

Hi, it looks as though in the connection properties that you have selected a read-only connection, hence not being able to update.
try changing that.

Hi, I am using the Microsoft ADO Data Control 6.0 and connectiong to my database using Microsoft Jet 4.0. My fields are being outputted into labels.

I have a tex box called text1 and a command...