Search results

Hi thanks for the reply. I've discovered what's causing it. The query is called as part of a loop as the same report needs to be generated for two different business areas. because I just had the report coming up as acWindowNormal the code was trying to generate the second report when the...

Hi, I'm not too sure what I've done. I'm trying to run a make table query on my database but keep getting the error message that the table is locked becuase it is in use by another user. This is not the case - noone else is currently using the database and I do not have the table open. I...

Hi, I'd already done that, the size of the report itself was fine and anything else on it would print on the greater size by the data area of the chart was being cut off. I found a post on line that said that this is probably the result of a bug with the wondows operating systems, that if...

Hi, I am trying to create a report that will print as A3 landscape, but am having a number of issues. In the page set-up I have set the page to A3 Landscape and my default printer option are the same. 1. Part of the report is a chart that should spread accross the whole width of the A3...

Just to let you know I have found a way to do this by creating another table continaing just fields for Week and ProjectYearID and then populating the weeks for this using VBA and using this week field in the query. The codee I used is shown below. I would still be interested in knowing any...

Hi, I'm trying to create a query that combines the predicted spend that is stored on one table with the actual spend that is stored on another for all weeks for which data is available in either table. The problem is that the duration for which data is available is often not the same on both...

Hi Leigh, That is fantastic, that is exactly what I was after. Thank-you so much. Not sure I completely understand everything that's going on yet, but I will have a closer look at the code to figure it out. Thanks again, Robyn

Hi, I don't actually have any help on this, but the general principle seems to be exactly what I am looking for. Can you recall where you originally got the code from or would someone be able to explain it as the lazy method of just cutting and pasting doesn't work. Basically what I am after...

Hey, Thanks for the reponse Actually that doesn't really answer my question as I was aware that you could enter a path to custom image and that that path could easily be changed through VBA. My question refered to the inbuild reference library of images that you covered in the second...

That's an interesting idea for a work around, I hadn't thought of that. I may actually give that idea a go. Thanks, I had just given up and used text but this is much better. If anyone does not where the images are stored it would still be useful to know.

that sounds logical, I will change the code in line with your suggestion. Thanks

Ooh a responce, I had literally just finished what I think is a solution. What I have done is use a record set with the following code If DLookup("[BusDevMgr]", "Users", "UserID=" & Me.Bus_Dev_Mgr.Column(0)) = False Then Dim SQL As String SQL = "SELECT * FROM Users WHERE UserID =" &...

I have a combobox on my form that lists all the users stored in the database. The data for these are stored in a table called Users. On of the fields in the table is FrequentUser which is of a yes/no datatype. When a user is selected in the combobox I would like to check if the FrequentUser...

I'm aware of the .picture property, the question is how do i refer to the specific images. e.g cbListFilter.picture = ?????????????????????????? where cbListFilter is the name of the button

Hi, I'm wondering if it's possible to change the picture (one of the built in ones) displayed on a command button by using VBA? Basically I have comboboxes in my form that are used to select the person resposible for a certain task. There are a lot of people so I have some people defined as...

ahh, simple. Thanks

Quick one here, I want the title of my report to read "Weekly P&T Spend Report" However I can not get the ampersand to registar as being just a character rather than underlining the next letter. How can I get it to actually display the ampersand as an ampersand. I know I can just write the...

Re: Cumulative total query for chart I tried a couple of variations on the SQL, either by just removing the sections relating to the project ID or by replacing these by the week field, I was either getting the results still separtated by project ID (that is I would get multiple instance of the...

Hi, I know there are several posts already on cummulative totals, but I am quite new to Access so am having trouble relating them to my project so thought I would start my own. Basically, I have a database containing information on several projects, for each project there are two lots of...

Thanks for the responce, sorry for the slow reply, i'm sure nothing has changed except that I use the weekly cost field in the other calculation, but didn't think it should affect that. Thanks for the pointers on the otehr field, i will try that and get back to you