Generate URL and trigger

[Gretchen Hembree]

Let's see if I even phrase this question correctly. We use an Access DB to
enter appointments for our company. There are hundreds of querys, but in
reality all the information is stored in one Table. (There are other tables
used for drop down info, etc.)

We are going to start using a web based software that will do additional
things for us. We will continue to use the Access DB. The Web software guys
are telling me to have our Access DB generate a URL for each appointment
entered and have it automiatically uploaded to their software using the auto
generated URL.

They acted like this was oh so easy until I asked how to do this in Access.
They have no idea and have never had a user that used Access before.

I am not sure I am using the correct language to explain the problem, but
does the question make sense? We need to know how to have a URL
autmoatically generated when an appointment is entered in a query and then
that URL triggered to upload the info to the web-based software.

Any help would be great. Thanks. ~Gretchen

 

[Douglas J. Steele]

Afraid you're going to have to provide more information than that.

What does the URL look like? What parts of it come would come from data
stored in the table, versus what parts can be hard-coded? What do you need
to do with the URL once you've generated it?

 

[Gretchen Hembree]

Here is what I have from them regarding inputting a work order:
Save Work Order - This service allows a remote system (Our Access DB) to
add or update a work order in the Ibis system.

URL:
https://ibis.agilissystems.com/ibis/rest/[your-company-id]/workOrders/save

They then give a whole list of paramters that apparently would need to be
added to each URL with the paremeters filled in with the information entered
into the query. Of course our feild titles don't match their parameter
titles, but I think that is a whole other issue as well.

Can you tell that I am not the Access guru? However when you are the
entire I.T. department for a small company things outside your area of
expertise tend to fall in your lap!

Thanks.

 

[Douglas J. Steele]

Writing a query to generate what you've shown shouldn't be that difficult.

Assuming you've got a customer table with one row per customer, use that
table to create a query. Add a computed field to the query by typing the
following in the Field row of an empty column:

URL: "https//ibis.agilssystems.com/ibis/test/" & [NameOfCustomerIDField] &
"/workOrders/save"

(replace [NameOfCustomerIDField] with the appropriate field name).

What more you do depends on the format of the parameters that need to be
passed.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Here is what I have from them regarding inputting a work order:
Save Work Order - This service allows a remote system (Our Access DB) to
add or update a work order in the Ibis system.

URL:
https://ibis.agilissystems.com/ibis/rest/[your-company-id]/workOrders/save

They then give a whole list of paramters that apparently would need to be
added to each URL with the paremeters filled in with the information
entered
into the query. Of course our feild titles don't match their parameter
titles, but I think that is a whole other issue as well.

Can you tell that I am not the Access guru? However when you are the
entire I.T. department for a small company things outside your area of
expertise tend to fall in your lap!

Thanks.

Afraid you're going to have to provide more information than that.

What does the URL look like? What parts of it come would come from data
stored in the table, versus what parts can be hard-coded? What do you
need
to do with the URL once you've generated it?

 

[Gretchen Hembree]

By adding just that will it auto load the info to their web software?
Basically I am wondering if just by creating it that it will automatically
try to link to that site.

Writing a query to generate what you've shown shouldn't be that difficult.

Assuming you've got a customer table with one row per customer, use that
table to create a query. Add a computed field to the query by typing the
following in the Field row of an empty column:

URL: "https//ibis.agilssystems.com/ibis/test/" & [NameOfCustomerIDField] &
"/workOrders/save"

(replace [NameOfCustomerIDField] with the appropriate field name).

What more you do depends on the format of the parameters that need to be
passed.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Here is what I have from them regarding inputting a work order:
Save Work Order - This service allows a remote system (Our Access DB) to
add or update a work order in the Ibis system.

URL:
https://ibis.agilissystems.com/ibis/rest/[your-company-id]/workOrders/save

They then give a whole list of paramters that apparently would need to be
added to each URL with the paremeters filled in with the information
entered
into the query. Of course our feild titles don't match their parameter
titles, but I think that is a whole other issue as well.

Can you tell that I am not the Access guru? However when you are the
entire I.T. department for a small company things outside your area of
expertise tend to fall in your lap!

Thanks.

Afraid you're going to have to provide more information than that.

What does the URL look like? What parts of it come would come from data
stored in the table, versus what parts can be hard-coded? What do you
need
to do with the URL once you've generated it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


message Let's see if I even phrase this question correctly. We use an Access
DB
to
enter appointments for our company. There are hundreds of querys, but
in
reality all the information is stored in one Table. (There are other
tables
used for drop down info, etc.)

We are going to start using a web based software that will do
additional
things for us. We will continue to use the Access DB. The Web
software
guys
are telling me to have our Access DB generate a URL for each
appointment
entered and have it automiatically uploaded to their software using the
auto
generated URL.

They acted like this was oh so easy until I asked how to do this in
Access.
They have no idea and have never had a user that used Access before.

I am not sure I am using the correct language to explain the problem,
but
does the question make sense? We need to know how to have a URL
autmoatically generated when an appointment is entered in a query and
then
that URL triggered to upload the info to the web-based software.

Any help would be great. Thanks. ~Gretchen

 

[Douglas J. Steele]

Once you've built the URL, use the FollowHyperlink method of the Application
object to invoke it:

Application.FollowHyperlink strURL

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

By adding just that will it auto load the info to their web software?
Basically I am wondering if just by creating it that it will automatically
try to link to that site.

Writing a query to generate what you've shown shouldn't be that
difficult.

Assuming you've got a customer table with one row per customer, use that
table to create a query. Add a computed field to the query by typing the
following in the Field row of an empty column:

URL: "https//ibis.agilssystems.com/ibis/test/" & [NameOfCustomerIDField]
&
"/workOrders/save"

(replace [NameOfCustomerIDField] with the appropriate field name).

What more you do depends on the format of the parameters that need to be
passed.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Here is what I have from them regarding inputting a work order:
Save Work Order - This service allows a remote system (Our Access DB)
to
add or update a work order in the Ibis system.

URL:
https://ibis.agilissystems.com/ibis/rest/[your-company-id]/workOrders/save

They then give a whole list of paramters that apparently would need to
be
added to each URL with the paremeters filled in with the information
entered
into the query. Of course our feild titles don't match their parameter
titles, but I think that is a whole other issue as well.

Can you tell that I am not the Access guru? However when you are the
entire I.T. department for a small company things outside your area of
expertise tend to fall in your lap!

Thanks.

:

Afraid you're going to have to provide more information than that.

What does the URL look like? What parts of it come would come from
data
stored in the table, versus what parts can be hard-coded? What do you
need
to do with the URL once you've generated it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


in
message Let's see if I even phrase this question correctly. We use an
Access
DB
to
enter appointments for our company. There are hundreds of querys,
but
in
reality all the information is stored in one Table. (There are other
tables
used for drop down info, etc.)

We are going to start using a web based software that will do
additional
things for us. We will continue to use the Access DB. The Web
software
guys
are telling me to have our Access DB generate a URL for each
appointment
entered and have it automiatically uploaded to their software using
the
auto
generated URL.

They acted like this was oh so easy until I asked how to do this in
Access.
They have no idea and have never had a user that used Access before.

I am not sure I am using the correct language to explain the
problem,
but
does the question make sense? We need to know how to have a URL
autmoatically generated when an appointment is entered in a query
and
then
that URL triggered to upload the info to the web-based software.

Any help would be great. Thanks. ~Gretchen

 

[naeem.bari]

Douglas,

The question is that does MS Access have the equivalent of triggers in
other databases?

Gretchen's database has one table that gets updated via hundreds of
different queries.
What we want to do is that every time a row gets added or modified in
this table, we want to create a URL using some of the columns and
invoke it.
I understand the bit about calling Application.FollowHyperlink strURL,
just need to know how to invoke *any* code upon table insert/update...

Hope that makes sense, and hope you can help us!

Thanks,
naeem

 

[hal900]

If they enter their data via a form would it be possible to use VBA in the
before or after update event of the form to dynamically create the url and
then use the follow hyperlink method to send the data after each record
addition? What might the latency be if they did so?

 

[Douglas J. Steele]

Yes. The AfterUpdate event would be appropriate.