Search results

Will give it a try - cheers.

OK - using the hyperlink() function I can get a link to changing pictures. Is there any way excel will automatically open links?

Fixed It Ok - fixed it using the indirect() function. D

Guys I am building a s/sheet to display data relating to multiple stores. I want the user to pick a store code and all the data to change, which I'm fixing with the offset function. However, I want a picture of the chosen store to display. Is there any way I can get excel to display a picture...

Hi guys I'm trying to create a master s/sheet that will populate data from any number of other s/sheets. I want the user to pick a store number on the master, and excel lookup data from a matching different file. I've tried saying ='C:\My Documents\'&c2&'.xls' but it doesn't work. Any help...

Will look at that cheers.

Cheers Guys First of all - I looked at the DCount help file and don't understand the make-up. I tried DCount( QueryName, Field, >0) and it didn't recognise the queryname. secondly, is it only able to count table rows? If I have a seperate form then for adding to the database - but the form in...

Guys I've searched the database and found similar problems but don't understand the replies (mainly DCount()). I have a control form where a user can search the database by entering information. The form asks them to type some text that will appear in a description field, and match any records...

Cheers All Not a brilliant Access user and some of the suggestions I couldn't work out. However, I added the new fields to the query I was populating via main form and when I popped up the new form, I sent the related values to the new form, and then when closing the pop-up, sent the values...

Guys I've built a database and now need to add more fields. The screen is alreday full so I want to pop-up a new form just to capture these new fields and then go back to the main form. However, I can't get the 2 forms to link together. The new form is opened by a form open button. I...

Call me stupid but I tried the conditional format route again and it's working fine now. Yippee. Something else you may be able to help me with, in the same report I have conditional formatting changing cell colours to red, amber, or green depending on the text value of the cell. However, those...

Will give these a go. Thanks.

Tried the formula is and it didn't work - only in the actual cell b2 not the row. I suppose I could conditional format each cell. Blimey. Yes, code would be nice - would that then need a run macro command. I thought about macro's, but the row could move weekly so I'd need to do a global edit...

Guys I'm trying to automate a report in excel. The company like a thin grey row to seperate a range of rows that vary weekly depending on a data file being uploaded. Basically, the grey row needs to move automatically. I've set up formulae to set a cell in column B to say 'Grey' when the bar...

Sorted It Thanks for your help. Rather than coding the concatenation, I've set up two different if(and)'s in other hidden columns and looked up on a concatenation of them instead. Thanks again.

I use concatenated fields with sumif functions all the time and can't see how this might help me here. I have a seperate sheet for each area manager, then in column A I set the first area manager and in column B then lookup on a concatenated field of number 1-13 and area manager name. Then in...

Lied - replied to the wrong post. If I use transferspreadsheet, even though all 4 columns in excel are text, access sets them to number and deletes those rows with text in. Any other Ideas?

Hi I have a s/sheet for each of 4 Area Managers. They each have upto 13 managers working for them, and they in turn have upto 13 stores they are responsible for. I've set up my lookup's to find all matching stores for one manager and then offset to the next manager when it reaches the end...

Cheers Changed it to TransferSpreadsheet and it's working again.

I'm trying to link an excel s/sheet into a database, however the link wizard doesn't give me the option of setting field types (text, double etc). It's skipping that screen. I've changed the s/sheet so that all cells are text but on linking the table sets 2 fields to number and I'm losing some...