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

Jeff Pritchard's current thread on stopping a library mde being used
made me realize I don't have a clue what he's talking about.  I would
have asked there, but didn't want to hijack his thread.
What is a library mde?  Is this like an add in of some sort?  I have

I'm working on converting an A97 DB that someone else wrote to A2K3.
It's converted fine, as far as I can see.  Now while making changes,
I've removed several buttons on a form that called reports, & removed
the code that the buttons used; the reports are no longer needed.

It's  a Christmas Eve, but I still struggles with one problem. Hope can
get some idea from someone. Here is my question:
I have two forms, form A and formB, where form B is used to add data
into a database, let's say B_DB. when user pickup a member id on form

I have a form which is used as a subform.  When I set the visible property
of a textbox to No, the textbox is still visible.  Why?
Robert

In Access 2003, I have a form (continuous form view) with several text
boxes. The text boxes are not bound to a table since the layout of the
form differs greatly from the structure of the normalized table into
which the data must go. Each time the text in any one box is modified,

im automating mappoint through access to get mileage between two
address fields. when ever i call the function it makes mappoint the
focus, and i have to reclick the access screen to regain access forms
focus. how can i get access focus via vba and without having to click

I am new to Access and have stumbled through building a
bill-of-materials database. My main form has 4 subforms set to
continuous mode that all exhibit the same scrollbar oddity: if the
number of records the subform displays is even one line larger than

Is there a way to save information on a report to a table. If so how?
Also would you be able to over write an existing file based on some
form of id? Could use any help thanks!

I'm encountering an error on attempting to set the form to the subform on a
form
dim frm as form
set frm = forms!frmmainform!frmsubform

I am trying to accomplish something and i'm having a hard time figuring
out how to do it.
I have a form that is used to enter records into a database called
"fiber panels".  One of the fields of that database is called "number

Does anyone know how to create a Pivot Chart at run-time?  I have a
database of meter readings that currently requires me to have 200 forms
created so the user can enter date criteria and have a chart pop up.  I
would like to remove the forms and have them created at run-time.  Any

I have an activex calendar control. On the open event of the form I
have the form go to a new record. The form opens with the calendar
control blank. As soon as I enter a value anywhere on the form, the
control shows up?

Apparently you can only do this with one value i.e Call
MyAssetLocationZoom(Me!txtLocation, "Amend data")
This runs;
Public Sub MyAssetLocationZoom(ctl As Control, formName As String)

Hi - can anybody point me to a tutorial that explains how to format a
date field within a SELECT statement.
I am trying to create a datafeed into another system.
The date field displays as  "2005/09/24 12:33" within the results from