Search results

Brilliant, I will try that, thank you!

Hi there Hope someone can help. I am linking from Access to an Excel file. It is a very simple, one-table database (at this point). I have set the formats for the columns in Excel (eg two decimal points). When I do the link to Access it pulls some of the columns across correctly, and some not...

Thank you so much!!

Thanks again for the help. I do not think the file is protected. I have attached it so hopefully you can work out what I am doing wrong. Thank you!!!!

Thanks for getting back to me. This is what I mean. When I click on the bit you have marked as 4. on your image, it won't let me select, it just does nothing, as though the button is not active. Or do I have to go via the button on the ribbon bar? I normally go via preview and then set up all...

Hi there Hope you can help. When I print in Excel 2007 I go to setup and I would like to have my headings appear at the top of each page. I know where to do this, but when I click on that bit, it does nothing. It won't let me select the cells to repeat at the top of each page. Is there some...

Ah, thanks so much for the help. I think you may be right that I am being hugely overoptimistic in my own ability here. I think I will have to find someone to do it for me. Thank you anyway for helping out so much.

Ok, I don't understand where to put the code. Do I just open windows and stick it on the desktop and then how do I run it?

I don't know how to set up the loop, or where, sorry, not very technical.

I'm afraid I don't see how any of those will strip out the email addresses only.

I have them saved in a folder in Outlook, but have no idea how to do a loop like that.

Not sure if this is the right place for this question, hope so. Bit difficult to explain, but I will try. We use Access 2007 and Outlook 2007. I have just done a massive email mailer from one of our databases. I used Outlook to send (via Word). A LOT of the emails bounced. What I would love to...

Hi there I am trying to do a report. I have created the query and the report and they work fine. I would like to also put this in graph form, but can't get it right. Here is the info My query is: Field 1 - calculation to get requests completed by due date (summary) Field 2 - calculation to...

Any ideas on how to do this? I keep trying, but just can't work it out. :o

Sorry, I don't understand. I have a button which allows the user to select the folder. Once the folder has been selected (path put into the hyperlink field) then they can come back on another day and click on the hyperlink field and get back to the folder. I can get the button to work and get...

I am trying to create a query where I am firstly selecting only the records that have activity. I have a lookup list of all the departments in our company and the user selects from this. Then I want to do a report that will show the activity, but only want to select those departments/sub...

Hi there I am trying to do two reports. I have created the queries and the reports and they work fine. I would like to also put these in graph form, but can't get it right. Here is the info My query is: Field 1 - calculation to get requests completed by due date (summary) Field 2 -...

Hi there I have created a button (Browse) which you click on to select a folder which is stored in a hyperlink field. The idea is that you can access the linked folder from the form. However, the button works fine, I can select the folder, but when I click on the hyperlink, nothing happens...

Is there a way to graph this? Also trying to do the following: Department, Sub department - number of requests received, how many days to reply, how many late Department and Sub department are in a table called department I would again like to report and graph and would like only the...

Brilliant, thank you!