Can you use frontpage to update a Database record.
and if possible if a record doesn't exist add it.

would it be easier if i just continued to add records, create a routine in
Access which deletes older duplicate record entries, which i could run once a
month.
If so how would i do it.



Al....

Yes
See FP Help on Database

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"Sproul" <(E-Mail Removed)> wrote in message news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
| Can you use frontpage to update a Database record.
| and if possible if a record doesn't exist add it.
|
| would it be easier if i just continued to add records, create a routine in
| Access which deletes older duplicate record entries, which i could run once a
| month.
| If so how would i do it.
|
|
|
| Al....

Can you be specific as to where in the FP help.
As i keep going round in circles with the same information which is no use
to me, the only thing i can find out about updating is for webpages and not
data in a database.
Having recieved plenty of useful information from you before, i know that
you will of course be right, but unless you know the correct questions to ask
the online help then like me your kinda stuck.


Al....

"Stefan B Rusynko" wrote:

> Yes
> See FP Help on Database
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Sproul" <(E-Mail Removed)> wrote in message news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
> | Can you use frontpage to update a Database record.
> | and if possible if a record doesn't exist add it.
> |
> | would it be easier if i just continued to add records, create a routine in
> | Access which deletes older duplicate record entries, which i could run once a
> | month.
> | If so how would i do it.
> |
> |
> |
> | Al....
>
>
>

Look at help regarding using any of the database components. You would create a web page via the
database component that would then update a specific record in the database, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Sproul" <(E-Mail Removed)> wrote in message
news:4FB48A3F-54E7-4FCA-A939-(E-Mail Removed)...
> Can you be specific as to where in the FP help.
> As i keep going round in circles with the same information which is no use
> to me, the only thing i can find out about updating is for webpages and not
> data in a database.
> Having recieved plenty of useful information from you before, i know that
> you will of course be right, but unless you know the correct questions to ask
> the online help then like me your kinda stuck.
>
>
> Al....
>
> "Stefan B Rusynko" wrote:
>
>> Yes
>> See FP Help on Database
>>
>> --
>>
>> _____________________________________________
>> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> "Warning - Using the F1 Key will not break anything!" (-;
>> To find the best Newsgroup for FrontPage support see:
>> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> _____________________________________________
>>
>>
>> "Sproul" <(E-Mail Removed)> wrote in message
>> news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
>> | Can you use frontpage to update a Database record.
>> | and if possible if a record doesn't exist add it.
>> |
>> | would it be easier if i just continued to add records, create a routine in
>> | Access which deletes older duplicate record entries, which i could run once a
>> | month.
>> | If so how would i do it.
>> |
>> |
>> |
>> | Al....
>>
>>
>>

I have found this
http://support.microsoft.com/default...b;en-us;240090
but cant get it to work

I keep getting an error on the Update.asp Page.
Even if i do get it to work it's still not what i'm looking for.

What i need to do is track equipment.
if its out for use you scan the page when it's out for use
if it's in for repair then you use tha page to scan out for repair
if it's at a vendo you use the page to scan it to a vendor

all of the equipment has barcodes, i want the user to select the page
required for the equipment that they want to scan, i don't want any
conformation pages or extra pages, just scan the item, then scan the next
item.

I currently have a database that stores this information and looks at the
last entry per item, but this causes the database to get bigger and bigger,
then takes longer to query. so i need to just update the required field and
not look at the last entry as i'm doing now.

I hope i've explained it.


Al....


"Thomas A. Rowe" wrote:

> Look at help regarding using any of the database components. You would create a web page via the
> database component that would then update a specific record in the database, etc.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Sproul" <(E-Mail Removed)> wrote in message
> news:4FB48A3F-54E7-4FCA-A939-(E-Mail Removed)...
> > Can you be specific as to where in the FP help.
> > As i keep going round in circles with the same information which is no use
> > to me, the only thing i can find out about updating is for webpages and not
> > data in a database.
> > Having recieved plenty of useful information from you before, i know that
> > you will of course be right, but unless you know the correct questions to ask
> > the online help then like me your kinda stuck.
> >
> >
> > Al....
> >
> > "Stefan B Rusynko" wrote:
> >
> >> Yes
> >> See FP Help on Database
> >>
> >> --
> >>
> >> _____________________________________________
> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> "Warning - Using the F1 Key will not break anything!" (-;
> >> To find the best Newsgroup for FrontPage support see:
> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> >> _____________________________________________
> >>
> >>
> >> "Sproul" <(E-Mail Removed)> wrote in message
> >> news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
> >> | Can you use frontpage to update a Database record.
> >> | and if possible if a record doesn't exist add it.
> >> |
> >> | would it be easier if i just continued to add records, create a routine in
> >> | Access which deletes older duplicate record entries, which i could run once a
> >> | month.
> >> | If so how would i do it.
> >> |
> >> |
> >> |
> >> | Al....
> >>
> >>
> >>
>
>
>

Why do you want to use FP to do this?

You need a custom written application that can process input from barcode readers, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Sproul" <(E-Mail Removed)> wrote in message
news:30F87F2B-1BA4-4D51-9B81-(E-Mail Removed)...
>I have found this
> http://support.microsoft.com/default...b;en-us;240090
> but cant get it to work
>
> I keep getting an error on the Update.asp Page.
> Even if i do get it to work it's still not what i'm looking for.
>
> What i need to do is track equipment.
> if its out for use you scan the page when it's out for use
> if it's in for repair then you use tha page to scan out for repair
> if it's at a vendo you use the page to scan it to a vendor
>
> all of the equipment has barcodes, i want the user to select the page
> required for the equipment that they want to scan, i don't want any
> conformation pages or extra pages, just scan the item, then scan the next
> item.
>
> I currently have a database that stores this information and looks at the
> last entry per item, but this causes the database to get bigger and bigger,
> then takes longer to query. so i need to just update the required field and
> not look at the last entry as i'm doing now.
>
> I hope i've explained it.
>
>
> Al....
>
>
> "Thomas A. Rowe" wrote:
>
>> Look at help regarding using any of the database components. You would create a web page via the
>> database component that would then update a specific record in the database, etc.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Sproul" <(E-Mail Removed)> wrote in message
>> news:4FB48A3F-54E7-4FCA-A939-(E-Mail Removed)...
>> > Can you be specific as to where in the FP help.
>> > As i keep going round in circles with the same information which is no use
>> > to me, the only thing i can find out about updating is for webpages and not
>> > data in a database.
>> > Having recieved plenty of useful information from you before, i know that
>> > you will of course be right, but unless you know the correct questions to ask
>> > the online help then like me your kinda stuck.
>> >
>> >
>> > Al....
>> >
>> > "Stefan B Rusynko" wrote:
>> >
>> >> Yes
>> >> See FP Help on Database
>> >>
>> >> --
>> >>
>> >> _____________________________________________
>> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> >> "Warning - Using the F1 Key will not break anything!" (-;
>> >> To find the best Newsgroup for FrontPage support see:
>> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> >> _____________________________________________
>> >>
>> >>
>> >> "Sproul" <(E-Mail Removed)> wrote in message
>> >> news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
>> >> | Can you use frontpage to update a Database record.
>> >> | and if possible if a record doesn't exist add it.
>> >> |
>> >> | would it be easier if i just continued to add records, create a routine in
>> >> | Access which deletes older duplicate record entries, which i could run once a
>> >> | month.
>> >> | If so how would i do it.
>> >> |
>> >> |
>> >> |
>> >> | Al....
>> >>
>> >>
>> >>
>>
>>
>>

I'll explain again

We curently use a barcode scanner that emulates a keyboard and connects to
the Keyboard PS2 port, this scans the label with our information on it, this
is entered into the field on the webpage that is used to input the data to
the Database. (scanner is a IT3800, Hand Held Products, for anyone who's
remotely interested)

Currently all changes are entered as a new entry into the database, I use a
query that shows the last entry per Equipment ID, If equipment comes in for
repair, or a checkup, it is scanned in to our lab, when it's repaired, tested
good it is scanned out of the lab, if it needs to go to an external vendor
for repair then we scan it to say it's at an external vendor. After a while
we have multiple records for the same piece of equipment, but we only need to
know the last entry, hence the query. But the more records we have the longer
the query takes, therefore i need to be able to update a record or add it if
it doesn't exist.

Is it possible to do the above?



Al....

"Thomas A. Rowe" wrote:

> Why do you want to use FP to do this?
>
> You need a custom written application that can process input from barcode readers, etc.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Sproul" <(E-Mail Removed)> wrote in message
> news:30F87F2B-1BA4-4D51-9B81-(E-Mail Removed)...
> >I have found this
> > http://support.microsoft.com/default...b;en-us;240090
> > but cant get it to work
> >
> > I keep getting an error on the Update.asp Page.
> > Even if i do get it to work it's still not what i'm looking for.
> >
> > What i need to do is track equipment.
> > if its out for use you scan the page when it's out for use
> > if it's in for repair then you use tha page to scan out for repair
> > if it's at a vendo you use the page to scan it to a vendor
> >
> > all of the equipment has barcodes, i want the user to select the page
> > required for the equipment that they want to scan, i don't want any
> > conformation pages or extra pages, just scan the item, then scan the next
> > item.
> >
> > I currently have a database that stores this information and looks at the
> > last entry per item, but this causes the database to get bigger and bigger,
> > then takes longer to query. so i need to just update the required field and
> > not look at the last entry as i'm doing now.
> >
> > I hope i've explained it.
> >
> >
> > Al....
> >
> >
> > "Thomas A. Rowe" wrote:
> >
> >> Look at help regarding using any of the database components. You would create a web page via the
> >> database component that would then update a specific record in the database, etc.
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> ==============================================
> >> If you feel your current issue is a results of installing
> >> a Service Pack or security update, please contact
> >> Microsoft Product Support Services:
> >> http://support.microsoft.com
> >> If the problem can be shown to have been caused by a
> >> security update, then there is usually no charge for the call.
> >> ==============================================
> >>
> >> "Sproul" <(E-Mail Removed)> wrote in message
> >> news:4FB48A3F-54E7-4FCA-A939-(E-Mail Removed)...
> >> > Can you be specific as to where in the FP help.
> >> > As i keep going round in circles with the same information which is no use
> >> > to me, the only thing i can find out about updating is for webpages and not
> >> > data in a database.
> >> > Having recieved plenty of useful information from you before, i know that
> >> > you will of course be right, but unless you know the correct questions to ask
> >> > the online help then like me your kinda stuck.
> >> >
> >> >
> >> > Al....
> >> >
> >> > "Stefan B Rusynko" wrote:
> >> >
> >> >> Yes
> >> >> See FP Help on Database
> >> >>
> >> >> --
> >> >>
> >> >> _____________________________________________
> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> >> "Warning - Using the F1 Key will not break anything!" (-;
> >> >> To find the best Newsgroup for FrontPage support see:
> >> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> >> >> _____________________________________________
> >> >>
> >> >>
> >> >> "Sproul" <(E-Mail Removed)> wrote in message
> >> >> news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
> >> >> | Can you use frontpage to update a Database record.
> >> >> | and if possible if a record doesn't exist add it.
> >> >> |
> >> >> | would it be easier if i just continued to add records, create a routine in
> >> >> | Access which deletes older duplicate record entries, which i could run once a
> >> >> | month.
> >> >> | If so how would i do it.
> >> >> |
> >> >> |
> >> >> |
> >> >> | Al....
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

You need to create different entry forms to handle each type of action (create or modify existing
record, etc.)

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Sproul" <(E-Mail Removed)> wrote in message
news:6A397FD4-7270-4179-9DA6-(E-Mail Removed)...
> I'll explain again
>
> We curently use a barcode scanner that emulates a keyboard and connects to
> the Keyboard PS2 port, this scans the label with our information on it, this
> is entered into the field on the webpage that is used to input the data to
> the Database. (scanner is a IT3800, Hand Held Products, for anyone who's
> remotely interested)
>
> Currently all changes are entered as a new entry into the database, I use a
> query that shows the last entry per Equipment ID, If equipment comes in for
> repair, or a checkup, it is scanned in to our lab, when it's repaired, tested
> good it is scanned out of the lab, if it needs to go to an external vendor
> for repair then we scan it to say it's at an external vendor. After a while
> we have multiple records for the same piece of equipment, but we only need to
> know the last entry, hence the query. But the more records we have the longer
> the query takes, therefore i need to be able to update a record or add it if
> it doesn't exist.
>
> Is it possible to do the above?
>
>
>
> Al....
>
> "Thomas A. Rowe" wrote:
>
>> Why do you want to use FP to do this?
>>
>> You need a custom written application that can process input from barcode readers, etc.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Sproul" <(E-Mail Removed)> wrote in message
>> news:30F87F2B-1BA4-4D51-9B81-(E-Mail Removed)...
>> >I have found this
>> > http://support.microsoft.com/default...b;en-us;240090
>> > but cant get it to work
>> >
>> > I keep getting an error on the Update.asp Page.
>> > Even if i do get it to work it's still not what i'm looking for.
>> >
>> > What i need to do is track equipment.
>> > if its out for use you scan the page when it's out for use
>> > if it's in for repair then you use tha page to scan out for repair
>> > if it's at a vendo you use the page to scan it to a vendor
>> >
>> > all of the equipment has barcodes, i want the user to select the page
>> > required for the equipment that they want to scan, i don't want any
>> > conformation pages or extra pages, just scan the item, then scan the next
>> > item.
>> >
>> > I currently have a database that stores this information and looks at the
>> > last entry per item, but this causes the database to get bigger and bigger,
>> > then takes longer to query. so i need to just update the required field and
>> > not look at the last entry as i'm doing now.
>> >
>> > I hope i've explained it.
>> >
>> >
>> > Al....
>> >
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> Look at help regarding using any of the database components. You would create a web page via
>> >> the
>> >> database component that would then update a specific record in the database, etc.
>> >>
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> ==============================================
>> >> If you feel your current issue is a results of installing
>> >> a Service Pack or security update, please contact
>> >> Microsoft Product Support Services:
>> >> http://support.microsoft.com
>> >> If the problem can be shown to have been caused by a
>> >> security update, then there is usually no charge for the call.
>> >> ==============================================
>> >>
>> >> "Sproul" <(E-Mail Removed)> wrote in message
>> >> news:4FB48A3F-54E7-4FCA-A939-(E-Mail Removed)...
>> >> > Can you be specific as to where in the FP help.
>> >> > As i keep going round in circles with the same information which is no use
>> >> > to me, the only thing i can find out about updating is for webpages and not
>> >> > data in a database.
>> >> > Having recieved plenty of useful information from you before, i know that
>> >> > you will of course be right, but unless you know the correct questions to ask
>> >> > the online help then like me your kinda stuck.
>> >> >
>> >> >
>> >> > Al....
>> >> >
>> >> > "Stefan B Rusynko" wrote:
>> >> >
>> >> >> Yes
>> >> >> See FP Help on Database
>> >> >>
>> >> >> --
>> >> >>
>> >> >> _____________________________________________
>> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> >> >> "Warning - Using the F1 Key will not break anything!" (-;
>> >> >> To find the best Newsgroup for FrontPage support see:
>> >> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> >> >> _____________________________________________
>> >> >>
>> >> >>
>> >> >> "Sproul" <(E-Mail Removed)> wrote in message
>> >> >> news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
>> >> >> | Can you use frontpage to update a Database record.
>> >> >> | and if possible if a record doesn't exist add it.
>> >> >> |
>> >> >> | would it be easier if i just continued to add records, create a routine in
>> >> >> | Access which deletes older duplicate record entries, which i could run once a
>> >> >> | month.
>> >> >> | If so how would i do it.
>> >> >> |
>> >> >> |
>> >> >> |
>> >> >> | Al....
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

I kind of thought that, what i'm looking at doing is just keep adding the
records from the different pages, I've alread got a query that selects the
latest records, i've also got a query that does an unmatched query between
the original table and the enties that i require. now i just have to figure
out how to delete the ones that i dont want.
So if i get this going i can run it once a month and that'll greatly reduce
my problem.


Al....

"Thomas A. Rowe" wrote:

> You need to create different entry forms to handle each type of action (create or modify existing
> record, etc.)
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Sproul" <(E-Mail Removed)> wrote in message
> news:6A397FD4-7270-4179-9DA6-(E-Mail Removed)...
> > I'll explain again
> >
> > We curently use a barcode scanner that emulates a keyboard and connects to
> > the Keyboard PS2 port, this scans the label with our information on it, this
> > is entered into the field on the webpage that is used to input the data to
> > the Database. (scanner is a IT3800, Hand Held Products, for anyone who's
> > remotely interested)
> >
> > Currently all changes are entered as a new entry into the database, I use a
> > query that shows the last entry per Equipment ID, If equipment comes in for
> > repair, or a checkup, it is scanned in to our lab, when it's repaired, tested
> > good it is scanned out of the lab, if it needs to go to an external vendor
> > for repair then we scan it to say it's at an external vendor. After a while
> > we have multiple records for the same piece of equipment, but we only need to
> > know the last entry, hence the query. But the more records we have the longer
> > the query takes, therefore i need to be able to update a record or add it if
> > it doesn't exist.
> >
> > Is it possible to do the above?
> >
> >
> >
> > Al....
> >
> > "Thomas A. Rowe" wrote:
> >
> >> Why do you want to use FP to do this?
> >>
> >> You need a custom written application that can process input from barcode readers, etc.
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> ==============================================
> >> If you feel your current issue is a results of installing
> >> a Service Pack or security update, please contact
> >> Microsoft Product Support Services:
> >> http://support.microsoft.com
> >> If the problem can be shown to have been caused by a
> >> security update, then there is usually no charge for the call.
> >> ==============================================
> >>
> >> "Sproul" <(E-Mail Removed)> wrote in message
> >> news:30F87F2B-1BA4-4D51-9B81-(E-Mail Removed)...
> >> >I have found this
> >> > http://support.microsoft.com/default...b;en-us;240090
> >> > but cant get it to work
> >> >
> >> > I keep getting an error on the Update.asp Page.
> >> > Even if i do get it to work it's still not what i'm looking for.
> >> >
> >> > What i need to do is track equipment.
> >> > if its out for use you scan the page when it's out for use
> >> > if it's in for repair then you use tha page to scan out for repair
> >> > if it's at a vendo you use the page to scan it to a vendor
> >> >
> >> > all of the equipment has barcodes, i want the user to select the page
> >> > required for the equipment that they want to scan, i don't want any
> >> > conformation pages or extra pages, just scan the item, then scan the next
> >> > item.
> >> >
> >> > I currently have a database that stores this information and looks at the
> >> > last entry per item, but this causes the database to get bigger and bigger,
> >> > then takes longer to query. so i need to just update the required field and
> >> > not look at the last entry as i'm doing now.
> >> >
> >> > I hope i've explained it.
> >> >
> >> >
> >> > Al....
> >> >
> >> >
> >> > "Thomas A. Rowe" wrote:
> >> >
> >> >> Look at help regarding using any of the database components. You would create a web page via
> >> >> the
> >> >> database component that would then update a specific record in the database, etc.
> >> >>
> >> >> --
> >> >> ==============================================
> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >> ==============================================
> >> >> If you feel your current issue is a results of installing
> >> >> a Service Pack or security update, please contact
> >> >> Microsoft Product Support Services:
> >> >> http://support.microsoft.com
> >> >> If the problem can be shown to have been caused by a
> >> >> security update, then there is usually no charge for the call.
> >> >> ==============================================
> >> >>
> >> >> "Sproul" <(E-Mail Removed)> wrote in message
> >> >> news:4FB48A3F-54E7-4FCA-A939-(E-Mail Removed)...
> >> >> > Can you be specific as to where in the FP help.
> >> >> > As i keep going round in circles with the same information which is no use
> >> >> > to me, the only thing i can find out about updating is for webpages and not
> >> >> > data in a database.
> >> >> > Having recieved plenty of useful information from you before, i know that
> >> >> > you will of course be right, but unless you know the correct questions to ask
> >> >> > the online help then like me your kinda stuck.
> >> >> >
> >> >> >
> >> >> > Al....
> >> >> >
> >> >> > "Stefan B Rusynko" wrote:
> >> >> >
> >> >> >> Yes
> >> >> >> See FP Help on Database
> >> >> >>
> >> >> >> --
> >> >> >>
> >> >> >> _____________________________________________
> >> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> >> >> >> "Warning - Using the F1 Key will not break anything!" (-;
> >> >> >> To find the best Newsgroup for FrontPage support see:
> >> >> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> >> >> >> _____________________________________________
> >> >> >>
> >> >> >>
> >> >> >> "Sproul" <(E-Mail Removed)> wrote in message
> >> >> >> news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
> >> >> >> | Can you use frontpage to update a Database record.
> >> >> >> | and if possible if a record doesn't exist add it.
> >> >> >> |
> >> >> >> | would it be easier if i just continued to add records, create a routine in
> >> >> >> | Access which deletes older duplicate record entries, which i could run once a
> >> >> >> | month.
> >> >> >> | If so how would i do it.
> >> >> >> |
> >> >> >> |
> >> >> >> |
> >> >> >> | Al....
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Ok, why are you trying to do this from a web page vs. just doing this directly in Access?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Sproul" <(E-Mail Removed)> wrote in message
news:48A09873-D69C-45D6-9061-(E-Mail Removed)...
>I kind of thought that, what i'm looking at doing is just keep adding the
> records from the different pages, I've alread got a query that selects the
> latest records, i've also got a query that does an unmatched query between
> the original table and the enties that i require. now i just have to figure
> out how to delete the ones that i dont want.
> So if i get this going i can run it once a month and that'll greatly reduce
> my problem.
>
>
> Al....
>
> "Thomas A. Rowe" wrote:
>
>> You need to create different entry forms to handle each type of action (create or modify existing
>> record, etc.)
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Sproul" <(E-Mail Removed)> wrote in message
>> news:6A397FD4-7270-4179-9DA6-(E-Mail Removed)...
>> > I'll explain again
>> >
>> > We curently use a barcode scanner that emulates a keyboard and connects to
>> > the Keyboard PS2 port, this scans the label with our information on it, this
>> > is entered into the field on the webpage that is used to input the data to
>> > the Database. (scanner is a IT3800, Hand Held Products, for anyone who's
>> > remotely interested)
>> >
>> > Currently all changes are entered as a new entry into the database, I use a
>> > query that shows the last entry per Equipment ID, If equipment comes in for
>> > repair, or a checkup, it is scanned in to our lab, when it's repaired, tested
>> > good it is scanned out of the lab, if it needs to go to an external vendor
>> > for repair then we scan it to say it's at an external vendor. After a while
>> > we have multiple records for the same piece of equipment, but we only need to
>> > know the last entry, hence the query. But the more records we have the longer
>> > the query takes, therefore i need to be able to update a record or add it if
>> > it doesn't exist.
>> >
>> > Is it possible to do the above?
>> >
>> >
>> >
>> > Al....
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> Why do you want to use FP to do this?
>> >>
>> >> You need a custom written application that can process input from barcode readers, etc.
>> >>
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> ==============================================
>> >> If you feel your current issue is a results of installing
>> >> a Service Pack or security update, please contact
>> >> Microsoft Product Support Services:
>> >> http://support.microsoft.com
>> >> If the problem can be shown to have been caused by a
>> >> security update, then there is usually no charge for the call.
>> >> ==============================================
>> >>
>> >> "Sproul" <(E-Mail Removed)> wrote in message
>> >> news:30F87F2B-1BA4-4D51-9B81-(E-Mail Removed)...
>> >> >I have found this
>> >> > http://support.microsoft.com/default...b;en-us;240090
>> >> > but cant get it to work
>> >> >
>> >> > I keep getting an error on the Update.asp Page.
>> >> > Even if i do get it to work it's still not what i'm looking for.
>> >> >
>> >> > What i need to do is track equipment.
>> >> > if its out for use you scan the page when it's out for use
>> >> > if it's in for repair then you use tha page to scan out for repair
>> >> > if it's at a vendo you use the page to scan it to a vendor
>> >> >
>> >> > all of the equipment has barcodes, i want the user to select the page
>> >> > required for the equipment that they want to scan, i don't want any
>> >> > conformation pages or extra pages, just scan the item, then scan the next
>> >> > item.
>> >> >
>> >> > I currently have a database that stores this information and looks at the
>> >> > last entry per item, but this causes the database to get bigger and bigger,
>> >> > then takes longer to query. so i need to just update the required field and
>> >> > not look at the last entry as i'm doing now.
>> >> >
>> >> > I hope i've explained it.
>> >> >
>> >> >
>> >> > Al....
>> >> >
>> >> >
>> >> > "Thomas A. Rowe" wrote:
>> >> >
>> >> >> Look at help regarding using any of the database components. You would create a web page
>> >> >> via
>> >> >> the
>> >> >> database component that would then update a specific record in the database, etc.
>> >> >>
>> >> >> --
>> >> >> ==============================================
>> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> >> ==============================================
>> >> >> If you feel your current issue is a results of installing
>> >> >> a Service Pack or security update, please contact
>> >> >> Microsoft Product Support Services:
>> >> >> http://support.microsoft.com
>> >> >> If the problem can be shown to have been caused by a
>> >> >> security update, then there is usually no charge for the call.
>> >> >> ==============================================
>> >> >>
>> >> >> "Sproul" <(E-Mail Removed)> wrote in message
>> >> >> news:4FB48A3F-54E7-4FCA-A939-(E-Mail Removed)...
>> >> >> > Can you be specific as to where in the FP help.
>> >> >> > As i keep going round in circles with the same information which is no use
>> >> >> > to me, the only thing i can find out about updating is for webpages and not
>> >> >> > data in a database.
>> >> >> > Having recieved plenty of useful information from you before, i know that
>> >> >> > you will of course be right, but unless you know the correct questions to ask
>> >> >> > the online help then like me your kinda stuck.
>> >> >> >
>> >> >> >
>> >> >> > Al....
>> >> >> >
>> >> >> > "Stefan B Rusynko" wrote:
>> >> >> >
>> >> >> >> Yes
>> >> >> >> See FP Help on Database
>> >> >> >>
>> >> >> >> --
>> >> >> >>
>> >> >> >> _____________________________________________
>> >> >> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> >> >> >> "Warning - Using the F1 Key will not break anything!" (-;
>> >> >> >> To find the best Newsgroup for FrontPage support see:
>> >> >> >> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
>> >> >> >> _____________________________________________
>> >> >> >>
>> >> >> >>
>> >> >> >> "Sproul" <(E-Mail Removed)> wrote in message
>> >> >> >> news:023867E6-B32A-408A-96DD-(E-Mail Removed)...
>> >> >> >> | Can you use frontpage to update a Database record.
>> >> >> >> | and if possible if a record doesn't exist add it.
>> >> >> >> |
>> >> >> >> | would it be easier if i just continued to add records, create a routine in
>> >> >> >> | Access which deletes older duplicate record entries, which i could run once a
>> >> >> >> | month.
>> >> >> >> | If so how would i do it.
>> >> >> >> |
>> >> >> >> |
>> >> >> >> |
>> >> >> >> | Al....
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>