In a form there are 3 text boxes – assetid, quantity, amount. When i enter 3 in the quantity and click a save button, assetid should auto increment from com1 to com2,com3,com4 consecutively in access database column and at the same time the amount should be divided equally among the 3 assetid and saved in the database.

Can someone tell me how to pull only certain rows from an Access DB using ASP?

I have one table in my database that allows multiple records with the same data in one of the fields (stockNum). I want to pull only one record for each unique record. So, if there are five records in this table with a stock number of 58025, I only want to pull one record with that stock number.

Is this possible?
Ok, I guess I should explain better what I need. I do want to pull all the data from every record. I have a table on my page and I loop through the recordset to show all the records.

What I’m actually doing is displaying a table on my page with a list of records where I have uploaded images for inventory.

There are 4 columns: id, stockNum,caption,description.

Let’s say I have upload three images for stock number 52805, then there are going to be three rows in this table with the stock number 52805. I only want that row to be shown once in the table.

I am using the stockNum field as a hyperlink in my table on the page to postback to the same page where the images uploaded for that stock number are shown below the table.

I hope that makes sense!

Thanks guys for your help!

So what im asking is.

How can i use my wireless computer to share its wireless capabilities to the wired only computer next to it?

Yes i do have an ethernet cable i just dont know how to “Bridge” the connections.

I have to insert records from the textboxes into a database using a SAVE button. Then using a id I’l be retrieving the data when clicking a retrieve button. Then I’l be modifying the records and update it into the database using the same SAVE button. The problem for me is using the same SAVE button for both inserting and updating.

Using ASP.NET HTTPHandlers, how can I access data that has been posted from third party websites when input tags does not includes any name (or id) attributes?

I want to keep an eye out for my 14 year old sister and see what she is doing on the computer. How can i do this from my computer.

I read that Access will only allow a few concurrent users. So, If I use an Access(mdb) database for a product catalog on my ASP.NET website, will there be a limit to how many people can look at the catalog at one time?

I am in charge of an educational program where there will be a computer with a demo running on it. I need to figure out a way to restrict who ever uses the computer to a single task so they don’t get into other files. I’ve seen computers do this before at retail stores like best buy to run demos for different computer companies. Whoever can answer this is a genius!

I m trying to display the content of the table in the ASP web page. the entire table is getting displayed except for the image field.

It is a simple Employee database, I want to display information like details of each emp along with their photos.

(AND the images are not being displayed)

Plz Help

Is it possible to create a forum on a shared drive without php? This would be just for internal users to add questions to a page. All users have access to the same drive.