Search results

Hi everyone, Another quick question. I am running a system whereby I upload separate excel documents to a sharepoint, the colleagues then fill in the document through the day. The next day I download the work and copy it all into one ‘Master List’. From there I then divide the data from the...

Hi everyone, I’m creating an Excel workbook with Hyperlinks to navigate around the workbook (i.e. on ‘Sheet1’ you can click a cell that will take you to ‘Sheet2’) Well that is easy enough but the problem is I only want to see one tab (the current tab) at a time (I don’t want to just hide all...

Hi everyone, I have just bought a laptop off eBay which I intend on upgrading so I went to my local computer shop to buy some new memory. Now my plan was to instal a 1GB & a 2GB unit but the guy in the shop said I'd be better installing 2 x 1GB units which are identical, this would act or...

Hi everyone, I have a sql dbo qry that extracts data from a server, I then have a qry aligns that data to a hierarchy then saved that data to a tbl which is linked to a sharepoint site. The problem I have is I want the process to ensure any duplicates are removed before it saves the data to...

Brilliant - thank you

Just one more question - What if the field within the record DB is used to link both colleague tbls? When I have treid to apply the above to my DB's it is resulting in everything from one, When I try to apply the same type of join to both colleague tbls, I get an error asking me to perform a...

Hi everyone, Can I just ask for a second opinoin onthe error 'ODBC --call failed'? My understanding is this means there was an error trying to connect to the data warehouse, which I will get randomly when trying to access this specific data warehouse - usually its offline. Am I correct in...

Morning eveyrone, Since I've started using Office 2007 I've noticed Excel has starting saving backup files here there and everywhere. Although I think its a good idea, is there any way to change the detault save location for the backup only? Thanks UN

I'd like to say thank you so much - this is exactly what I was looking for.

Thank you so much! :D

Brilliant, thanks. Would I use that in VBA? If so, how would I phrase it?

Hi Everyone, Quick question... I run daily macros which run queries then exports them, the problem I'm having is as this is a daily export the existing file from the previous day is still in the saved location, so I get a pop-up box asking if I want to overide the previous version (xlsx...

Can anyone help with this? :banghead:

Hi, Thanks for your reply but I'm still showing limited results. So I've loaded the colleage tbl twice (one is showing _1), I've linked both colleagues tbls to the record tbl, the from join from one ID for the colleage and then the second with the other ID for the colleague. These two joins...

Hi everyone, I've got a query that uses a key from one table to pull back records from another. My question is... On the table with the key there is another field that I want to use to pull back data from the same table from above. A bit more info... Table one holds colleagues details...

Hi everyone, I've created an outlook task to export a common query I do every day, is there a way to automate it so it will happen automatically without me pressing Run? I use office 2007 on a company laptop with tight network restrictions (so no Windows Task Scheduler) Any help is...

Hi everyone! I just thought I'd take a minute to introduce myself before I get stuck in with posting & asking questions. I'm known as the 'geek' and 'IT guy' at work but I've found myself needing to search for a Access related questions recently. I've just been promoted to chief analyst and...