Converting an Access Form into a Data Access Page

MX1

Does anyone know if you can convert a form into a data access page? It
looks like you can only convert tables and I have a form with some very
complex calculations that I'd love to leverage via an Intranet.

Any thoughts or experiences with this are welcome. Thanks in advance!

Nov 12 '05 #1

Subscribe Post Reply

4717

Allen Browne

A form and a DAP (data access page) are radically different animals. For
example, the form exposes some really useful event for controls and for the
form itself, but these are not available in a DAP.

If it's just a matter of calculated fields, would it be possible to create
calculated fields in a query, and use the query as the source for your DAP?
For example, you could type something like this into the Field row of query
design:
Amount: [Quantity] * [PriceEach]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MX1" <mx*@mx1.abc> wrote in message
news:eAjqb.116492$Tr4.326739@attbi_s03...

Does anyone know if you can convert a form into a data access page? It
looks like you can only convert tables and I have a form with some very
complex calculations that I'd love to leverage via an Intranet.

Any thoughts or experiences with this are welcome. Thanks in advance!

Nov 12 '05 #2

MX1

I'm going to give this a shot. Thanks!

"Allen Browne" <al*********@SeeSig.invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

A form and a DAP (data access page) are radically different animals. For
example, the form exposes some really useful event for controls and for the form itself, but these are not available in a DAP.

If it's just a matter of calculated fields, would it be possible to create
calculated fields in a query, and use the query as the source for your DAP? For example, you could type something like this into the Field row of query design:
Amount: [Quantity] * [PriceEach]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MX1" <mx*@mx1.abc> wrote in message
news:eAjqb.116492$Tr4.326739@attbi_s03...
Does anyone know if you can convert a form into a data access page? It
looks like you can only convert tables and I have a form with some very
complex calculations that I'd love to leverage via an Intranet.

Any thoughts or experiences with this are welcome. Thanks in advance!

Nov 12 '05 #3

Similar topics

converting access db to mysql

by: chicha | last post by:

Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I...

Microsoft SQL Server

ms access web how-to

by: mora | last post by:

Hello. I am hoping to get some help here about connecting, directly or not, an Access database with a web site. I have done some research but have not come up with much of use. I am wondering...

Microsoft Access / VBA

Converting an Access database to a web-based format.

by: RCS | last post by:

Okay, a rather 'interesting' situation has arisen at a place I work: I need to convert a database from Access to something that can be used over the web. I am currently maintaining and...

Microsoft Access / VBA

Converting a Response.Redirect's URL from querystring-based to other

by: Keith Patrick | last post by:

I have to do some programmatic redirects (in several pages) based on URLs I am given from an external source. The URLs have querystrings at the end, but one in particular is about 240 chars long,...

ASP.NET

Converting Access form to a asp form

by: Jack | last post by:

Hi, I have an Access application which need to be converted to asp-sql server application. This Access application uses a single form. This form has got a SS number with names and age. The form...

ASP / Active Server Pages

Is This Possible ... ?

by: Wayne Smith | last post by:

I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web...

ASP.NET

Converting Microsoft Works databases.... *shudder*

by: Michael B. Trausch | last post by:

I was wondering if anyone has had any experience with this. Someone I know is trying to move away from Microsoft Works, and I am trying to look into a solution that would convert their data in a...

Python

Error in converting app from 1.1 to framework 2.0

by: Blasting Cap | last post by:

I keep getting errors that pop up when I am trying to convert an application from dotnet framework 1.1 to framework 2.0. The old project was saved in sourcesafe from Visual Studio 2003, and I have...

ASP.NET

Converting 2003 to 97

by: murraystewart | last post by:

I have spent days building a database in access 2003 and the found it needs to run on Access 97, I did the conversion but the form is not opening with an error message "you loaded a form or report...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

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...

General

Wordpress or something else?

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...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware