How can I open subform on the main form to Enter new data?
I have button which On_Click event reveals SubForm (Visible=True) and
SubForm is prepared for entering new records.
Thanks, Chris

I am creating a database of artwork.  I have photographs of all of the
pieces.  The photos were taken with a digital camera as jpeg images, then I
reformated them (cropped, resized, etc.) in Adobe Photoshop and saved them as
bitmaps.  

I have a column call it WO (Text Field).
the data on it looks like this:
4545-1
2323-500

How can I print an Access database structure? I need to print the Field
names, field order and field data type.
Thanks
Chris

I'm responsible for updating an access data base which has several columns.
One of the column list locations where business is done.  We have a new
location
and I need to add new location.  how do I do that.

I am setting up a new database with relationship tables and am having a
problem with one particulaly large table, I am getting an error when saving,
the table has 120 fields within it.
does anyone know the maximum number of fields allowed in a table.

I am new to VBA so please bear with me.  I am trying to update a table
through a sub-form and am trying to use a sql statement to do this for
me.
When I run this code --

how do I close open ports

I'm looking for a good book on access do have does anybody have any
recommdations and could you explain your reasoning

I have been told that, over time, data held in a db will
degrade (either be lost or or unnoticed).
Is this true, and if so to what extent?
Also, is there a fix?

I am trying to create a power point presensation and i would like to play the
same song continously for all the slides in the presensation.  If anyone  can
help me please email me.
Thanks

I have a membership database where the date of leaving is recorded.
If I take a query and as for all records where that field Is Not Null
I lose one record.
Visual inspection sees and empty field. I have used delete and back

I have been continuing to work on a my query to show the total hours worked in an area.  Here is my expression, I used the expression builder for this.   Expr1: [SumOfWorkAreaHours]/12.  It returns the number I want but when I run the query, I get a pop up window which says ...

Hi people.
Someone put two values together that I didn't want put together, I don't
know how it was done, and I need to take the field back apart.  Problem:
In the column in question, each cell looks like this:  123:456  Sometimes

To update some records I am calling following querry, which is working OK :
UPDATE Microwave
SET Far_RAUType = Forms!frmEditMicrowave!Near_RAUType
WHERE Microwave!Far_SiteID=Forms!frmEditMicrowave!Near_SiteID