I have a binding navigator which I have not altered from the basic settings.

The problem I am having is that the database is set to auto number from 70000, but the binding navigator is starting...

I will be looking at this over the weekend, so will let you know how I get on. That you for pointing me in the right direction.

I have a table showing the results of a search (colated from a number of other tables).

I would like to be able to drill down so that the whole entry can be seen.

Can anyone point me in the...

I have managed to get everything solved.

Thank you for your help.

This looks fun. I will try and get my head around these.

Thank you for all you help binoj_daniel.

Thank you for your suggestion, if only I had been thinking this would have been obvious.

I also found some sizing problems.

Can something along the lines about be used to pick up the row...

binoj-daniel, have just tried adding the code you gave me, but am still showing the same error.

When I had a few spelling mistakes I was give the error showing that there wasn't X column.

Do...

Thank for this binoj_daniel, will will start typing.

Is there anything in the copy I am using that would allow the colour of rows to be able to be picked up?

I need to be able to pick these up...

I have a new problem now!

I am trying to use bulk copy to import the excel spreadsheet, but I keep getting the following error:

The given ColumnMapping does not match up with any column in the...

I am trying to import and export to/from excel.

This needs to be able to be done on a weekly basis.

I have managed to find a couple of ways of doing this, but I need a way to set column width...

I have been working on this for a while.

Using the stored Procedure from the link QVeen72 provided I have been able to get the search results I want with in SQL.

My problem is getting this to...

apchidara, please can you let me have a fully working link - I am working on an application that needs to do a lot of work with Excel.

Thanks Veena.

This will enable everything to work.

Thanks once again.

Michael

I have had a chance to test the code and it works well, not all I have to do is to work out how to get the result into a format that will be useful to me.

Time to try and put my thinking cap on.

There are five tables, and I imaging in total about 5,000 records (once completed).

Thank you for the link, that looks great.

Have a look at the following link as it shows what the different versions do and do not have. Also do not forget that each version has the option of having an MSDN subscription included.
...

QVeen72, I am using SQL Server Express edition at the moment, but do have full standard version available if needed.

Vee, well put that is what I want.

I know this seems strange, but the old DB (propitiatory) can do this and they want to keep that functionality.

Thanks once again iamthwee.

I am busy today, but will have a look in details later.

Is this better?

I quite agree with you, but it is what the person wants.

Is it possible to rename tabs on a regular basis?

Please find the information below, thanks for you help.

What I mean is that the tabs are going to show details from a SQL table.

The use wants to be able to only show the tabs necessary for the main record shown, so this may need to change as the users...

The tables are one table linked to three or four others (each of these are not link to each other)

Does this help?

I would be grateful if anyone could let me know of an easy way of searching multiple tables for information.

I would like to display any found results in a grid alowing the user to choose the...

That looks like it will help with the creation of the tabs iamthwee and I will try this later.

Does it allow for different tabs for each file?

I am currently working on a project and need to allow the user to create tabs. This I have managed to do although the solution (to copy from another hidden tab).

The problem I have is that I need...