Memo field 1

[hoofit]

I'm working on design for a check sheet used for maintaining equipment. As a unit is inspected, various things like fluid levels, air pressure are checked and recorded on this sheet. I decided to use a memo field for the mission. I want to end up with an 8-1/2" x 11" printable sheet (no lines etc.) Not sure how this is done. Do I start with a simple form and memo field.

thanx

 

[dhookom]

A memo field? Apparently you don't want to use the information for anything useful. Why not just use Word?


Duane
Hook'D on Access
MS Access MVP

 

[hoofit]

That is correct. Simply a printable checksheet. Data is not stored. I'm not familiar with using Word with Access. Can you elaborate?

 

[dhookom]

I wasn't even thinking of using Word with Access. If you only want a non-saved checksheet, why not build it in Word of even Excel. You haven't provided any information about any tables in Access that are needed.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Do you want to type things into this document (fluid levels, air pressure) and then import the data into Access?

 

[MajP]

If so

http://msdn.microsoft.com/en-us/library/aa155434(v=office.10).aspx

 

[hoofit]

MajP,
Thanx for responding. I have a single table used as a lookup. It contains an equipment preventive maintenance (PM) name and description. For simplicity let's say PM1, PM2, PM3 etc. Each PM is different and each has a description. It is the description that I need as the form or checksheet. So, PM1 will include, for example, items that need to be checked weekly. PM2 could include things that need to be checked annually. PM3 could include things that get checked every 150 hours. PM4 could include things that get checked every 3000 miles etc. I will provide, in the application, several samples of these 'checksheets' and will allow a user to create his / her own. BUT, once a sheet has been created, no data is entered into it. The creation of a sheet is a one shot deal. It is simply a printable checksheet. So, mechanic "A" wants to complete PM3, prints out the sheet as a guide and elsewhere in the application it is noted that PM3 was completed on such and such a date. What I need is to know how to create this sheet.

hoof

 

[PHV]

Why not simply create the checksheets with any application you want, store the pathname in yor table and then use the FollowHyperlink method to display it ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hoofit]

PHV,
I see where I can use a command button to run an application - Word. I'm not familiar with the process you describe. Currently, I have a single table with 2 fields: PMName and Description. So I create and save a document called PM1 Description and save it in My Documents\PMDescriptions. Where do I go from here?

hoof

 

[hoofit]

PHV,
I see the process and it is superior to a memo field on a form.

Thank you,

hoof

 

[hoofit]

Continuing on, I've set up a simple command button and completed the hyperlink address line. I've put together a sample checksheet in Word and saved it in c: It tests fine. The next step is to determine which checksheet to select - there will be several.

My form includes a textbox indicating the PM name assigned to a particular piece of equipment. Is the hyperlink something that can be referred to in code? If so I was thinking...

if tbx.value = "PM1" then
hyperLinkAddress = c:\checksheetOne
else
if tbx.value = "PM2" then
hyperlinkAddress = c:\checksheetTwo

Or is there another way to accomplish this.

Thank you

 

[MajP]

The hyperlink or the address should be in a field
FYI:

http://allenbrowne.com/func-GoHyperlink.html

 

[dhookom]

I would create related tables for the PM to perform and at what interval. You may need some junction tables to determine which PMs are performed for which type of checksheet. Users can add more PMs and/or checksheets and junction records.

Then you use Access as a relational database and fantastic report builder.

Duane
Hook'D on Access
MS Access MVP

 

[hoofit]

Hi dhookum,
Yes, essentially this is my current design. As you note users have an endless selection of PM's and descriptions from which to select or create and assign to a particular unit. Rather interesting. For the purpose of the thread I'm trying to keep it simple as the db is nearing 30 tables. MajP I will explore the 'field' location as you suggest and how it can be distinguished from another.

hoof

 

[hoofit]

MajP,
The field location works great! I've created an excel file (more to come) for a link. When excel fires up, is there a way to just see the form or must all the other garbage be there? No big deal, just aesthetics.

hoof