Making MS Access Form as a standalone form like in VB

[Oscar N. Goyee]

Well, its sames difficult for me; I love access so much and wish to make
it perform extra task. I prepared an HTML form but can not connect it to
my access table and so I think it is possible to make an access form a
standalone form for user input. Can anyone assist. My mail add is
dianafather@aim .com.



*** Sent via Developersdex http://www.developersdex.com ***

[Steve]

Re: Making MS Access Form as a standalone form like in VB

Oscar, why don't you just code up a VB form for user input and connect
it to an Access backend? To my knowledge, you can't force an Access
form to exist outside of Access. Your users would have to open the
Access file to enter data, no matter how you set up the Access form.

[Oscar N. Goyee]

Re: Making MS Access Form as a standalone form like in VB

Thanks so much steve; I got the same feelings but my problem is
connecting the vb user input form to an Access backend. Can you help
me? Will be grateful.
Best



*** Sent via Developersdex http://www.developersdex.com ***

[Steve]

Re: Making MS Access Form as a standalone form like in VB

Sure. What you need is a Connection object. In the Connection object's
properties you'll want to set up a DSN (Data Source Name) that points
to your Access database. From there you can use an ADODB Recordset
object to retrieve data from and commit data to your Access backend.
It's been a couple of years since I've done this, but I'm willing to
open up a new .NET project and figure out the syntax and all that
again, if you're willing to bear with me on it. I can't do it during
the day (at work) but I have some time during the evenings this week. I
can start playing with it tonight if you let me know today.

[Pachydermitis]

Re: Making MS Access Form as a standalone form like in VB

Are you .Net or VB 6?
If it's VB6 here something I grabbed from a vb app that uses access as
a backend.
const strDonn= "Driver={Micros oft Access Driver (*.mdb)};" & _
"Pwd=;" & _
"Dbq="
Dim rstJobs As New ADODB.Recordset
Dim strSql As String
Dim strWhere As String
Dim connDb As New ADODB.Connectio n
connDb.Open strConn & App.Path & "\System\System .mdb"
strSql = "SELECT JobID, JobName FROM tJob WHERE JobActive=True
ORDER BY JobName"
rstJobs.Open strSql, connDb, adOpenForwardOn ly, adLockReadOnly

Anyway there is your connection. Connections are the most resource
intensive part of your db access so try open one and leave it open
until you are done. the reset is the same as inside Access. If you
miss your access functions, you can also reference access' library to
use its functions.
HTH

[Tom van Stiphout]

Re: Making MS Access Form as a standalone form like in VB

On Tue, 20 Dec 2005 11:35:09 GMT, Oscar N. Goyee <dianafather@ai m.com>
wrote:

It's poor newsgroup practice to ask for email responses.
Unlike what Steve said, you can create a form that lives outside of
the Access main window: make it a popup.
There is also nifty code out there (google for it), that puts the
Access main window behind that popup, and moves it with it when it
moves. To the end user it appears you have a single-form application.

-Tom.


[color=blue]
>Well, its sames difficult for me; I love access so much and wish to make
>it perform extra task. I prepared an HTML form but can not connect it to
>my access table and so I think it is possible to make an access form a
>standalone form for user input. Can anyone assist. My mail add is
>dianafather@ai m.com.
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***[/color]

[Larry Linson]

Re: Making MS Access Form as a standalone form like in VB


"Oscar N. Goyee" <dianafather@ai m.com> wrote
[color=blue]
> Well, its sames difficult for me; I love access so much
> and wish to make it perform extra task. I prepared an
> HTML form but can not connect it to my access table
> and so I think it is possible to make an access form a
> standalone form for user input. Can anyone assist.[/color]

Do some Googling on the archives of this newsgroup at
http://groups.google.com. What you want to do seems to fit his description
of how he has used Data Access Pages.
[color=blue]
> My mail add is dianafather@aim .com.[/color]

The practice in this newsgroup is "you post it here; we answer here." For
other good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP



Larry Linson
Microsoft Access MVP