Solved

HTML embedded in MS Access form

Posted on 2012-04-09
7
519 Views
Last Modified: 2012-04-10
Hi all,

Presently undertaking a change in the startup form of my database programme. I was thinking of using a HTML editor to create this start up form (in order to make it more "appealing").

I was therefore wondering whether:-

a) it is possible to have a HTML front end (note: I do not wish to use a Browser to access the data).

b) Is it then possible to embed html coding in an Access form?

c) I wonder whether I am mistaken in proceeding in this manner.

Grateful for replies
0
Comment
Question by:PipMic
  • 3
  • 3
7 Comments
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 375 total points
ID: 37824628
The short any is NO unless you use a web browser control.

What version of Access are you using?    Access 2007 added a lot if UI stuff that makes it a lot easier to make :"appealing" looking apps. . Access 2010 is even better.

Have you tried turning on themes?

 Themed controls
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 375 total points
ID: 37824676
Here is an example of an application that was built in Access that I think looks appealing: http://www.fairsoftware.com/
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 125 total points
ID: 37824898
That is a web app.

Access is not a web app and cannot create interfaces like that unless you use a *Lot* of custom controls and programming...

Even in Access 2010 where you can have a "web Database", the type of interface you are thinking of is not possible...

If you really need something like this, you will have to dump Access (as the front end interface)  and use a web technology (.net, ASP, ...et al)


Besides, a simple "HTML Editor" would not get you what you are after anyway...
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37824923
"Appealing" is a subjective term.

I mean if it looks good, but does not work, ...how "appealing" is it.

You main goal should to be to get the DB working flawlessly, and worry about things like "Looks" later...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37824930
THTC:

<Here is an example of an application that was built in Access >
Meaning the BE was built in Access or are you saying that that "Page" was built in Access...?
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 375 total points
ID: 37824940
I totally agree that just HTML alone will not get you want you want.  

You may also want to check out this:

Power Tip: Integrate Silverlight into an Access database

Power Tip: Integrate Silverlight into an Access database (Part II)

Boyd Trimmell, Microsoft Access MVP
0
 

Author Closing Comment

by:PipMic
ID: 37826497
Somehow I was expecting this answer. It confirms my initial thought that this manner of creating a more attractive interface would best be done differently.

Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Star schema daily updates 2 39
ORDER BY 7 41
T-SQL Query - Group By Year 3 33
MS Access Query Date Field Not Returning Results for the Correct Date 6 18
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question