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

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

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

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