By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,365 Members | 2,946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,365 IT Pros & Developers. It's quick & easy.

Making MS Access Form as a standalone form like in VB

P: n/a
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
di*********@aim.com.

*** Sent via Developersdex http://www.developersdex.com ***
Dec 20 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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.

Dec 20 '05 #2

P: n/a
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 ***
Dec 20 '05 #3

P: n/a
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.

Dec 20 '05 #4

P: n/a
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={Microsoft Access Driver (*.mdb)};" & _
"Pwd=;" & _
"Dbq="
Dim rstJobs As New ADODB.Recordset
Dim strSql As String
Dim strWhere As String
Dim connDb As New ADODB.Connection
connDb.Open strConn & App.Path & "\System\System.mdb"
strSql = "SELECT JobID, JobName FROM tJob WHERE JobActive=True
ORDER BY JobName"
rstJobs.Open strSql, connDb, adOpenForwardOnly, 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

Dec 20 '05 #5

P: n/a
On Tue, 20 Dec 2005 11:35:09 GMT, Oscar N. Goyee <di*********@aim.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.
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
di*********@aim.com.

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


Dec 21 '05 #6

P: n/a

"Oscar N. Goyee" <di*********@aim.com> wrote
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.
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.
My mail add is di*********@aim.com.


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
Dec 23 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.