Type: Posts; User: StephenPaul; Keyword(s):
I will implement this now
I have a cell that returns values on a column that us formatted to curreny £ however sometimes the cell it looks up for the value has an 'on request' entry, is there a way of...
I have an excel workbook which contains all of the first part of the UK's postcodes (eg. AB10, AB11 etc.) in column A I also have the X - Y co-ordinates in columns F and G. I would...
I will try that
I am trying to enter the following formula on a worksheet but it says I am creating a circular reference but I cannot seem to fathom why that is, a prod in the right direction would...
Thanks for the info and the download link but I am still not getting what I need, I will take it home and dabble at the weekend. Have a nice weekend
I would like to insert a background image into a worksheet in which I have hidden all unused cells to the right and below the part I want to have showing. When I use the insert...
I have version 1.1 (Amstrad discs) I will check to see if I held on to 2 or not when I get home tonight
Thank you all for your response
Mark, I have tried your options without success, I have on my PC about 150 movie clips (usually funnies that are emailed to me) and these are in the normal formats...
I have been using Windows Media Player 9 to view movies on my PC, this morning however I can hear the soundtrack and see the icon on the tool bar but can't get to see the movie...
I though this was quite simple but I must be doing something wrong somewhere
Any help appreciated
Thank you Steve
That worked great and returns the mileage for the city selected, in my original question I eluded to the fact that what I was trying to do was to calculate the cost of a 2nd man...
Sorry Hans I have given you incorrect information to work on.
What I did not realise is that cell H1 in worksheet 2 shows the row number (from the master sheet) of the destination selected in the...
Thank you Hans
I have entered this information into a cell and it returns a N/A retsult , any ideas please, also can you please let me know what the ,2, part refers to in your response.
I have a workbook with 2 sheets, sheet 1 = master and sheet 2 = secure
on sheet 2 I have 2 listboxes that calculate a transport rate. Listbox 1 takes its input range from the master...
Thanks for both response,
This is what currently happens and what I would like to happen
FrmAWB has a field Goods that looks up information from FrmGoods using the following on the
On a form I have certain fields (based on lookups from other fields) that I would like the user to be able to enter information into and get a message box asking whether they wish to...
I have used the search feature and have tried a number of the suggestions but I am still having a problem, let me explain
I am trying to convert a very complicated form into an access...
I know how to make a simple 'OK' message box but what I would like to be able to do is to have the user complete a field which is a text lookup field and onexit have a message box asking if...
I am absolutely useless with queries but I do find the tips useful and easy to follow here
Maybe this will help
On a multi field form I have 2 fields that take their values from calculations on the form, I have a 3rd field that I would like populated with the highest value from these 2 other...
Thanks Hans and John
Part 1 is fine, part 2 I am still doing my homework
A question in 2 parts
1. I have used the button wizard to put a print button on a form, can I adjust the code behind the button at all to change the number of copies printed (I...
Fantastic advice as usual, sorry for late response but since being laid of it is difficult for me to access the internet. Also many thanks Steve for your assistance