473,320 Members | 2,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Making MS Access Form as a standalone form like in VB

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
6 11573
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
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
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
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
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

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: commanderblop | last post by:
Hi there, I am in the process of translating an WIndows/ASP/MsSQL Content Managment System (CMS) to Linux/PHP/???. Is there a popular database I can use that will allow standalone files like...
3
by: mehrdad | last post by:
Hi, I have a fully functional MS-Access database. May I build such an "exe" file from a MS-Access "mdb" file which one who has not MS-Access installed on his/her system can take advantage of the...
3
by: canigou9 (remove your socks to reply) | last post by:
(cross posted - comp.databases.ms-access, microsoft.public.access) Hello folks - this is my first post here, after a short lurk. I have written an application in Access2002 for a friend's...
3
by: ajdfljsdf | last post by:
After some basic research, I am still somewhat unclear on how Access would be used in a workgroup setting. Basically, we want to run 10 MS Access clients to access an MS Access database on a...
5
by: elieli_132 | last post by:
Hi, My problem is the following: Made changes to code in form and closed the form. Now unable to open / design the form. - Tried copying and pasting - the new one does not open /display....
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
14
by: Champika Nirosh | last post by:
Hi All, We have a windows from application written in C#, there we have used Browser COM and other basic libraries present in standard .NET/C# SDK. So the next part is to make this appliaction...
0
by: Bruce Pataki | last post by:
I am creating an MFC application with activeX document server support. The application runs perfectly fine when i run as a standalone application. But when i run the application in Internet...
27
by: SQL Learner | last post by:
Hi all, I have an Access db with two large tables - 3,100,000 (tblA) and 7,000 (tblB) records. I created a select query using Inner Join by partial matching two fields (X from tblA and Y from...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.