Bulk Label Change

[TKnight]

HI, i'm writing a DB which i'm going to turn into an app later on. It has a few fields which I want the user to be able define the first time he/she opens up the database. To keep all the queries and VB etc. working i'm not actually going to re-name the fields, just the labels of the fields on the forms that they appear on in the database. I was going to write out a really lengthy bit of VB to do this when I stumbled upon the "For Each... Next " statement in the help files.

The statement is

For Each frm In Application.Forms
If Statement......
Next

From this i'm assuming that I can write a procedure that looks at each control in each form, and if the caption is "Sliding1" (the name of the field) then replace it with a variable. I can manage the If statement bit but

For Each ctl in Application.Forms doesn't work. Can anyone help with the code please.

thanks, Tom.

 

[dcx693]

Which version of Access are you using? And do you know if you're using DAO or ADO?

 

[TKnight]

I'm using Access 2000 and don't know if i'm using ADO or DAO. I think i'm using ADO. How can I tell? And is it an important consideration if I want to create an app.
I've been making DB's for a while now but have never tried to create a stand alone one before. I was hoping it wouldn't be too tricky, can MS Developer simply convert an mdb into an exe of sorts or am I hoplessly naive?
Thanks for your help, Tom.

 

[Rich]

You can't make an exec from an Access db, the developer ed only allows you to distribute the access run time files.
I don't think your method of allowing users to define labels associated with controls is going to be reliable either

 

[TKnight]

So there's no way that I can convert a DB that i've written into something that doesn't need Access to run?

 

[Captain Chaos]

'Run time' access is necessary to open an Access created DB. The only other choice is a pure VB executable