Search results for query: *

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!

Just a cheeky quick one! Tools > Add In > linked Table Manager gives you a list of linked tables and their location BUT you can't read the full source of the location if it is a long address. Is there anyway of finding this out in that situation. Finding it very annoying! regards

I have this spreadsheet with several worksheets. I wish to copy some of the worksheets into a seperate Excel file that I can use to distribute to other users. The problem is that when I copy my worksheets they maintain the link back to the original. For example Cell C23 = ='M:\Reports\3...

Hi all, Access FrontEnd, SQL Server 2000 backend. I need to add a Timestamp field to a table what do I do? In baby steps?! Is it a case of going to SQL SERVER and adding the Field in there, because I can't see a way of doing it directly from Access? Is this correct? regards Yorrick

there are no problems with any other apps, it's the darndest thing. Pressing ESC or F8 nothing works - I have just tried it again and it is resolved, now works fine! I have no idea what happened but I am very relieved!Thanks for your input guys

Sorry for the vague subject line, I have never seen this problem before. Whenever I click in a cell in Excel, wherever I drag the mouse it highlights all the cells I've visited. On each cell it will say something like 12R x 3C - rows and columns. I don't want this, it's driving me nuts. I...