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.
==============================================
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....
:
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.
==============================================
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....
:
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.
==============================================
I have found this
http://support.microsoft.com/default.aspx?scid=kb;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....
:
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.
==============================================
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....
:
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| 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....
