Help

C

CNB

How would you write a macro like that?
-----Original Message-----
Have you tried creating a macro, and activating this macro
with a button?
Hope this helps.
Fons
-----Original Message-----
Hello, all.

I hope you are having a good day. I, myself, will be
doing much better once I have figure out this problem
that I am hoping you could help me with.

I created a table which contains a field by the name
of "Attachments". The data type is OLE Object.
Afterwards, I started construction on a form. I created
a text box for the Attachments field with the aid of the
wizard.

Here are the characteristics of my box:
Size Mode: Clip
Auto Activate: Double Click
Display Type: Icon
Update Options: Automatic
OLE Type Allowed: Either
Visible: Yes
Display When: Always
Enabled: Yes
Locked: No
On Updated: =GetObject([«filename»],[«class»])

All of the other characteristics are blank or relate to
format.

The purpose of this field is to allow my clerks the
ability to attach related documents to the record.

As it is currently designed, if I double click on the
field in form view, I get an error message that you
cannot edit a bound object frame if the field in the
underlying table doesn't contain an OLE object. Embed or
link an OLE object into the bound object frame using the
Object command on the Insert menu.

The way it works now, I can only add a document to this
field if I go to Insert Object on the toolbar or I right
click on the field and hit Insert.

Now, this might sound silly, but I have been asked to
simplify this process. People can't remember to right
click or use the menu. Don't get me started. I need to
put some sort of button on the field that, when pressed,
will take the person to the insert window or I need to
make it automatically appear when it is clicked. If I
could get the field to automatically go to "create from
file", even better.

Can you guys think of a better way to attach a document
to a record? All advice is welcomed and appreciated.

Thanks gang,
.
.
...
 
F

Fons Ponsioen

Sorry for nor responding sooner. The way you may want to
start is open a new macro, and than review the various
options. I think a good one to start with is the Run
Command, than you will see the command block at the
bottom. As soon as you click in this block the will be a
pulldown. Selecting this pull down shows various options
to open various commands. You can enter a series of
commands on subsequent lines. This will in effect act as
if you are clicking the various menu commnands.
Macros are very usable once you get familiar with it.
Hope this gets you going.
Fons
-----Original Message-----





How would you write a macro like that?
-----Original Message-----
Have you tried creating a macro, and activating this macro
with a button?
Hope this helps.
Fons
-----Original Message-----
Hello, all.

I hope you are having a good day. I, myself, will be
doing much better once I have figure out this problem
that I am hoping you could help me with.

I created a table which contains a field by the name
of "Attachments". The data type is OLE Object.
Afterwards, I started construction on a form. I created
a text box for the Attachments field with the aid of the
wizard.

Here are the characteristics of my box:
Size Mode: Clip
Auto Activate: Double Click
Display Type: Icon
Update Options: Automatic
OLE Type Allowed: Either
Visible: Yes
Display When: Always
Enabled: Yes
Locked: No
On Updated: =GetObject([«filename»],[«class»])

All of the other characteristics are blank or relate to
format.

The purpose of this field is to allow my clerks the
ability to attach related documents to the record.

As it is currently designed, if I double click on the
field in form view, I get an error message that you
cannot edit a bound object frame if the field in the
underlying table doesn't contain an OLE object. Embed or
link an OLE object into the bound object frame using the
Object command on the Insert menu.

The way it works now, I can only add a document to this
field if I go to Insert Object on the toolbar or I right
click on the field and hit Insert.

Now, this might sound silly, but I have been asked to
simplify this process. People can't remember to right
click or use the menu. Don't get me started. I need to
put some sort of button on the field that, when pressed,
will take the person to the insert window or I need to
make it automatically appear when it is clicked. If I
could get the field to automatically go to "create from
file", even better.

Can you guys think of a better way to attach a document
to a record? All advice is welcomed and appreciated.

Thanks gang,
.
.
...




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top