Search results

I have found it. Sorry, I panicked! :o In 2003, select the cell then Data, Validation. That was a great solution btw.:)

This type of thing is what I'm after for a project of mine. The problem is that I cannot figure out how to replicate it. How did you do it? I can see the named ranges in the Selection sheet but I cannot find how the dropdown is populated. A step by step guide would be very useful (and not just...

Change this For J = 2 To (Sheets.Count) ' from sheet 2 to last sheet This seems to work ok. With this I don't get two copies of the last sheet.

Good job he wasn't an 'American' or all hell could have broken loose!

What new American owner? Did I miss the announcement?

I beleive he said 'Scunthorpe United' :)

I have neither an iPod or MP3 player. I use an FM Transmitter together with a USB Flash Drive (plugs into the cigarette lighter outlet - no wires). Its a VR3 VR9FM. You can find them on ebay. UK Link - http://www.raysmith.co.uk/AV-Products/AV-Accessories/FM-Modulator/MP3VR9FM_Modulator/ US Link...

Also, what happen to Kraj? Has he gone?

Solved it. Used a scatter chart.

Given this data (shown below) how can I create a single line chart showing both lines? Is it even possible? Height Load 2.2 14 2.1 80 1.4 137 1.27 215 1.19 292 Height Load 2.19 14 1.89 80 1.38 137 1.21 215 1.12 285 Thanks

Have you tried turning on Sharing? In Excel, Tools, Share Workbook. This will allow multi-user access and changes at the same time. The user will be informed if any changes they have made impact another users changes when they save the spreadsheet.

Do you have an example of this VBA code?

A Pivot Table? You mean like I suggested earlier?:)

This is the Excel section.:confused: rainman89's suggestion would work in Access. Have you tried using Autofilter or creating a Pivot table? Edit: Woohoo 100 posts!

LinkFound this link that might explain. It may be a long shot though.

I get the same as you but using this: color_index = Selection.Cells.Borders(xlEdgeTop).ColorIndex returns the answer. Of course you have to select the cell first.

I have to remove the table as the name changes with each run (per user) so I cannot just remove the contents. I just discovered this: DoCmd.Close acTable, tmp_table If I run this prior to the DeleteObject cmd it works fine. Don't know why I didn't think of it earlier.:o

I have a set of queries to gather data from some tables and create a new temporary table that is used as a recordsource for a form. Once the form is closed the data gathered is appended to another table. Ok, this may not be the best method but it works. My problem is that once the data has been...

Windows has fax capability built-in. Could you use that? I admit its not brilliant but it works.

I'll remember it too. If only I could find that button. No, really. Where is it? Edit:Ooops! Found it. Sorry.