Search:

Fantastic Hans

Thanks

Steve

Thanks Hans

I will implement this now

Cheers

Steve

Evening all

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...

Good afternoon

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...

Thanks Rudi

I will try that

SP

Good morning

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

SP

Good morning

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...

Mark

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

Stephen

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...

Good afteroon

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...

Good afternoon

I though this was quite simple but I must be doing something wrong somewhere

=IF(A11<20,D9=20,IF(A11>20,D9=A11,"")

Any help appreciated

Stephen

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.

Thanks...

Hi all

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

Good morning

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...

Hi all

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...

Hi all

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

http://[www.fontstuff.com/access/acctut17.htm]

Maybe this will help

Stephen

Good afternoon

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

Thanks again

Steve

Good afternoon

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...

Thanks Hans

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

Cheers
...