Recent content by yorrick

Unfortunately there is no primary key on the table, so this method doesn't work.

I can't get this to work! Train_No Station Passengers 8000 GER 100 8000 FRA 120 8000 ELA 80 9000 GER 25 9000 FRA 200 9000 ELA 50 All I want is to return the...

thanks, but i don't have that ability. Right clicking gives Format Control. And within that there is Size, Protection, Properties, Web, Control Properties only contains Object Positioning.

How do you change the font size of a combo box from the Forms menu. Whenever I right click on the box all font properties are greyed out.

Great thanks Guys

Makes no difference unfortunately.

I am trying to insert a Combo Box so that when the user selects an option it returns a number into another cell. Sounds easy right? However, when I insert the combo box from the Toolbox it plants the box but it is embedded. =EMBED("Forms.ComboBox.1","") This means I can't edit the Input...

ignore me -worked it out - talking jibberish!

Help!! i used to get this post to work but now after I've selected the range and done menu command Edit/Goto/Special/Blanks press "=" and then uparrow it selects Formulas in the Goto Special Menu! and therefore when I do ctrl-enter it simply says "no cells found" and does nothing!

Thanks xlbo, Unfortunately this brings back a Run time error #9. Subscript out of range. Also how do I put the cursor on startrng?

apologies for this question in advance! I have a macro that has a loop within it. I want the loop to run through several times, and each time I want a new starting point within the spreadsheet. I have been using Range("C2") as the starting point. but for the next iteration it needs to be...

Hi, got a spreadsheet that looks like Harry 23 34 33 45 Larry 23 12 45 12 What i want is Harry to be next to each of his scores. So it looks like Harry 23 Harry 34 Harry 33 Harry 45 Larry 23 Larry 12 Larry 45 Larry 12...

I have a Spreadsheet with External Data queries that link to an Access DB and pull data from an Access Query. All Good. However, if I want to change the location of the database it is not so simple. This is because I can find nowhere that tells me (even though I know) where the Spreadsheet...

I have inherited a reporting suite and several reports use an external query to import data from Access into Excel. There seems to be no problem, it brings the data in ok on refresh, however when I try to edit the query (just to see exactly where it's coming from) I get an error message...

By the way, I know you can look at the link in Design mode, but I want to look at the source when the source is not available i.e. find out where on the network it should be coming from if the network is inaccessible!