Replies

modified registry to exclude space. Now double clicking internet shortcut produces the following pop p form.. see attchd

Regards

Jason

Followed your directions as best as I know how… Double clicking on an internet shortcut produces the same result as before (which is that IE6 opens and diplays text refering to the details of the link info)the new result from your vb script is [indent]

---

File Extension Details
The File Type is: Internet Shortcut

The File Type Name is:
The Default Command is: Open (default)
The Default Command Path is:
The Default Icon is:
——————————————————————————–
The MIME Content Type is:
The MIME Extension is:
The MIME CLSID value is:
The MIME CLSID Name is:
The MIME CLSID ProgID is:
The MIME CLSID InProcServer32 is:
The MIME CLSID LocalServer32 is:
——————————————————————————–
The File Type EditFlags are: ( no value )
The File Type CLSID is:
The File Type CLSID ProgID is:
The File Type CLSID LocalServer32 is:
The File Type CLSID InProcServer32 is

---

[/indent]

Attached is the new registry file

Thanks

Jason

Followed your directions as best as I know how… Double clicking on an internet shortcut produces the same result as before (which is that IE6 opens and diplays text refering to the details of the link info)the new result from your vb script is [indent]

---

File Extension Details
The File Type is: Internet Shortcut

The File Type Name is:
The Default Command is: Open (default)
The Default Command Path is:
The Default Icon is:
——————————————————————————–
The MIME Content Type is:
The MIME Extension is:
The MIME CLSID value is:
The MIME CLSID Name is:
The MIME CLSID ProgID is:
The MIME CLSID InProcServer32 is:
The MIME CLSID LocalServer32 is:
——————————————————————————–
The File Type EditFlags are: ( no value )
The File Type CLSID is:
The File Type CLSID ProgID is:
The File Type CLSID LocalServer32 is:
The File Type CLSID InProcServer32 is

---

[/indent]

Attached is the new registry file

Thanks

Jason

Thanks Hans
ill give it whirl and report back

RE: your thought…
[indent]

---

A phrase like “probably changes when an inventory adjustment is made” is dangerous – what if it isn’t changed consistently?

---

[/indent]
What I meant was that I do not really understand how the field is used because 1) I did not write the application and 2)I do not use the inventory functionality so I could not discern a consistent pattern from the values that are in that field other than that the date values seem to reflect the date when a given product was added to the db.

I still think this date field will work for me the way you propose. Thanks a lot

Truly,

Jason

Thanks Hans
ill give it whirl and report back

RE: your thought…
[indent]

---

A phrase like “probably changes when an inventory adjustment is made” is dangerous – what if it isn’t changed consistently?

---

[/indent]
What I meant was that I do not really understand how the field is used because 1) I did not write the application and 2)I do not use the inventory functionality so I could not discern a consistent pattern from the values that are in that field other than that the date values seem to reflect the date when a given product was added to the db.

I still think this date field will work for me the way you propose. Thanks a lot

Truly,

Jason

Hans.

Answers.

1) the mysql table has a date added field and a last modified field
The Access table has a stock-take date which seems to default to the date a product is added and probably changes when an inventory adjustment is made (this field could serve fairly well since I do not use the inventory functions for which this date field is intended)

2) There is a products model number field in both tables that should be unique although it is not the primary key in the mysql table as it has a an autonum id field as primary.

Hans.

Answers.

1) the mysql table has a date added field and a last modified field
The Access table has a stock-take date which seems to default to the date a product is added and probably changes when an inventory adjustment is made (this field could serve fairly well since I do not use the inventory functions for which this date field is intended)

2) There is a products model number field in both tables that should be unique although it is not the primary key in the mysql table as it has a an autonum id field as primary.

thank you

here is the registry file

Regards

Jason

thank you

here is the registry file

Regards

Jason

Thank you for your reply

Folowing is the result to your instructions

Regards.
Jason

[indent]

---

File Extension Details
The File Type is: ft000002

The File Type Name is:
The Default Command is: Open (default)
The Default Command Path is:
The Default Icon is:
——————————————————————————–
The MIME Content Type is:
The MIME Extension is:
The MIME CLSID value is:
The MIME CLSID Name is:
The MIME CLSID ProgID is:
The MIME CLSID InProcServer32 is:
The MIME CLSID LocalServer32 is:
——————————————————————————–
The File Type EditFlags are: ( no value )
The File Type CLSID is:
The File Type CLSID ProgID is:
The File Type CLSID LocalServer32 is:
The File Type CLSID InProcServer32 is:
——————————————————————————–

If you were not prompted for a file extension or there is no text above, then your security settings might be blocking the script.

---

[/indent]

Thank you for your reply

Folowing is the result to your instructions

Regards.
Jason

[indent]

---

File Extension Details
The File Type is: ft000002

The File Type Name is:
The Default Command is: Open (default)
The Default Command Path is:
The Default Icon is:
——————————————————————————–
The MIME Content Type is:
The MIME Extension is:
The MIME CLSID value is:
The MIME CLSID Name is:
The MIME CLSID ProgID is:
The MIME CLSID InProcServer32 is:
The MIME CLSID LocalServer32 is:
——————————————————————————–
The File Type EditFlags are: ( no value )
The File Type CLSID is:
The File Type CLSID ProgID is:
The File Type CLSID LocalServer32 is:
The File Type CLSID InProcServer32 is:
——————————————————————————–

If you were not prompted for a file extension or there is no text above, then your security settings might be blocking the script.

---

[/indent]

Thank you for the response Hans.

In an ideal world the synch would be 2 way, but I could live with a one way…

Regards.

Jason

Thank you for the response Hans.

In an ideal world the synch would be 2 way, but I could live with a one way…

Regards.

Jason

Hans

Thanks. I am on my way.

Truly.
Jason

Charlotte

I got your attachment on linking images and it is exaclty what I want to do. Thank you.
It applies to a form. How Can I do it on a report?

Jason