Search results

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

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

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

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

Hi there There is a report I need to create and I don't even know where to start. :o I tried creating a query, but am not getting that right. Here is what I want to do: I have a Due Date and a Completed Date field. I want to know the number of instances (records) where the...

Hi there I have downloaded Stephen Leban's Calendar and have got it to work beautifully! Only one small issue, my date field is on the edge of the form (the right hand edge) and the calendar pops up to the right of the field, so it is almost all off the screen. Is there a way to get the...

Here's what I am trying to do - I have a hyperlink field. Next to the field I want to put a command button. When the user clicks on this it will open explorer (or similar) and the user can browse to the correct folder, then select it. And this will be stored in the hyperlink field. How on...

Hi there I have tried searching this forum, but I must be searching on the wrong words or something and I can't find what I am looking for. I would like to have my main form open without any records showing, and then the user can type in information in one of the fields and click on search...

Hi there I have a field on the form where I would like to have a default value which is the Due_Date minus 1 working day. What I have managed so far is: =([Due_Date]-1) But two problems, first - this is not working days (i.e. weekdays) and secondly - the default value doesn't work. On the...

Hi there I have been creating a form and I have added some buttons to it, but have not at this stage programmed them (still trying to figure out how). Anyway, everytime I change something on the form, like adding a button, the form stops working. Last time there was a bit of code left after I...

Hi there I want to know if it is possible to do this, and if so, how. I want to have a report appear on the switchboard when the programme is first opened. Please see attached for an idea of what I mean. Thanks!

Hi there I hope someone can help before I tear my hair out. I have a combo box that contains a number of fields, but displays only the first in the form (when you select they all show but only the first is shown in the field). Then I have a text box where I want to display the information in...

Hi there This is what I need to do: Date Field - 2 days and Date Field - 1 day Easy enough, but I need the 2 days and 1 day to be working days only (Monday to Friday). In other words, if something is due on 9 June, then two days prior would be 5 June, not 7 June. Hope this is not too...

Hi there, hope you can help! I have to design a database in which one of the activities required is to ensure that the information was sent to a number of people. If it was not sent, it should be done. From the user's point of view, they need to be reminded to do this but the completion of...

I have a field in my table that needs to contain a hyperlink. What I would like to do is to allow the user to Browse and Select the folder related to the record when the record is created (or create a new folder). Then when the record is browsed, the hyperlink can be clicked to open the folder...

Hi there I have a lookup table that will be used in a combo box on a form. Is it possible to add a function to the dropdown list that says 'Edit'. Basically, when the user gets to that point in the form they discover that the item they need from the dropdown list is not there and they want to...