SQL usually does not do that. It wants to keep the same ID for the same record in perpetuity.

The easiest way would be to delete the numbered column, then add it again as an autonumbering field....

You don't send an email with a button.

You send the temporary file to the manager as an attachment. Then the manager does the appending.

Excel has a "Save as web page" option in the File menu. Do all of your calculations with ranges, so you can insert a column and they still work. Be sure to use the correct cell addressing modes, so...

What about distributing the changes at night?

How about using a network server for one shared file?

Export the data to an Excel spreadsheet.

Or better, open the file into Excel (use the file type dropdown in the Open window), then save it as an Excel spreadsheet.

You need two tables. One is for the temporary file sent to the manager. The other is the permanent table, under the control of the manager. The manager then merges the record into the main table.

This is a place where you should use a query. With it, you can display data from different tables in the same screen.

You can also use a query.

That's to keep you from accidentally deleting an unsaved feature.

You need a for or while loop to repeat all of the records.

But why don't you just use the export function under File.

I come here only once a week.

Check to see if they have Microsoft Excel export and import in common.

What you need is one table with a list of all of the products, and more fields for the different kinds of products to link to the original tables you have.

Did you use the name of the field the query produced?

I got it to work, using the name of the field produced by the summary data function.. But you can't use data from both a table and from a...

Make two different forms, one for each purpose.

Use the OLE type to display an image. You can put a one pixel image in for a nonimage question if the process needs an image. Create an image of the equation using Word and Ctrl-PrintScreen. Paste...

Try asking if the field equals "".

You can also use the lookup wizard, which is a lot easier. It is a type in the Access table design view. But first, you must create a relationship between the tables.

Store pictures in an OLE type field.

Do you want to display the formula, or execute it?

Datasheet view shows the data in the database. It also allows you to enter and edit the data. It does not let you change the format of the database, other than minor changes (such as displayed column...

Export the data using Access, then use the application to open that.

Go to Design View on the form, and insert the header as needed.

This might work better if you export the Access table as an Excel spreadsheet, then add it to your existing Excel spreadsheet as another sheet tab.

You can use quoted strings in both the condition...

It appears to be closing the login session after each use. You need a way to keep the session open, and a way to log out when you are done.

Make Faculty ID the primary key in the Faculty table.

Form one-to-many associations between Faculty table and the other two tables.

Sort of.

I used the exact language required by Access.

Make student-id the sorting key of the students table.

Form one-to-many relationships from student to tests, and from student to assignments, using student-id as the key.

Columns of what, in what kind of file?

You can use a 1D array as a 2D array.

Just count the first 15 elements as line 1, the second 15 elements as line 2, and so on.

You will probably need a combination of PHP and MySQL.

If I understand what you are saying, I think you need to link the tables together with a key field (account number?).

Why do you need a tree structure? What's wrong with the list structure provided?

Please elaborate. What is the purpose of the tree?