How to Open a Form in HTML

[KevinKohrs]

Hey guys,

Sorry I am pretty green to all of this, I have designed a form and need to try and open it in HTML only with a submit button (I have that part). I tried on Open and I get an error. I have no VBA experience so I was hoping to use the builder.

I tried playing around with the Condition and Actions columns (OutputTo option) and no luck.

Any help is appreciated.

Thanks

 

[Norie]

What exactly are you trying to do?

Display and allow the form to be used on a web page?

 

[KevinKohrs]

Yes, sorry I should of been more clear. I have a team of 48 users that occasionally need to give feedback on certain situations (hence the form I created) and we all have access 2007 but being a tech center they like to poke around. I don't want them to have access to the form structure.

Thoughts?

 

[Norie]

Kevin

I've never used Access on the web/intranet/whatever but I think it's possible.

Don't know the ins and outs of it, why not check the Web Database template, it's available in 2010 so I would think it would be in 2007 too.

Mind you, from what I see from a quick search SharePoint might even be involved somewhere.

Have you considered using something other than Access?

 

[KevinKohrs]

Well maybe I could just use the front end/back end db approach, just pointing to a shared network folder. I have tried this and it worked, but I just wanted to Jazz it up a bit.

So is there a way they can pull up the form only no other options using access (since we all have access to it). I have created a submit and close button which work great.

The only problem I see is how to edit it, once created.

Thoughts?

 

[Norie]

How to edit what? The data or the form itself?

If you do use a front-end/back-end setup you could keep backend in a folder other people couldn't access.

For the front-end you could just set up links to the back-end tables and create forms for data input etc.

Probably wouldn't stop somebody poking about but they might not find anything of interest, depending on how you set the whole thing up of course.

 

[KevinKohrs]

Thanks for responding so quickly, when I need to update the form I have to do it on my back up copy and the overwrite the current Front End db.

I thought I might of had the HTML thing but I always got an error that said:

"The output macro action can not run with specified output file argument when in disabled mode of when called from an embedded macro."

I could not figure out how to enable a macro or use a stand alone macro.

 

[Norie]

I don't really think you can use macros (ie VBA code) in HTML.

To be honest I don't think Access is what you need for this.

I could be totally wrong though.

 

[KevinKohrs]

That's cool, thanks for your responses. I'll figure something out.