Search results

Mmmmm v interesting...... where do I put this code? Just in the text box on the report itself?

Im just nipping for lunch as its a friends birthday, I'll be back. Cheers, M

Oh, the columns are absolutely fine, as you say, v easy "=sum" at the bottom and they work great. Its the row totals that are the issue, and its these that I currently am using dsums for.... So the total for emp1 = 7 emp2 = 4 etc...

sorry - typo - that should read ** I cant see how I would get it to work**

Just looked at you example.... Im not sure it would work with my structure detailed above....? I can see how I would get it to sum (in a report) with the conditions I need to specify... Thanks for you help KenHigg, its always appreciated! Mandy

Mmmmm.... my issue with doing that is that I have a manager with employees... Looks like this: ____________________Sales1____Sales2_____Sales3____Sales4____Total_Sales Manager1____Empl1_____1________4__________2________0___________7...

whoops, posted before I'd finished typing: Sales £1 £2 £2 £4 and then total column = £9 Thanks,

I would love to be able to do either of these things..... I can sum columns easily in teh report, but not rows... Is it possible to do a row sum within a query? I thought a dsum in the report was my only option, but I'd be a very happy chap to learn of other solutions(!!) So you have any...

Hi all, I have a normal query which cross tabs my data and then populates a report. The user wanted a "Total" to sum up the row table so I added a DSUM based on the underyling table which all of the queries are run off. the DSUM works and gets the correct total. The problem is that the...

ah.... Tis working fine, I'd chosen a message with ' ' in the title and hence access was confused. Normally titled messages work great. Thanks again, M

It is brilliant, does exactly what I am looking for, except it does not like emails. When I save an email into the folder I get a debug error: Syntax error (missing operator) in query expression "mandy.msg" and the debug error is on: DoCmd.RunSQL "INSERT INTO tblFoundFiles ( FilePath ...

I changed it and it was quite happy. Do you have any code that will enable me to auto create a folder using the auto number of the issue when a new issue is created. Thanks, Mandy

"My Location" is currently pointing to an area of my C: drive. Is it ok to change that to a shared drive that all users will have acces to? Thanks, M

Wow... This looks brilliant.... Im going to spend some time going through it all now (esp the VBA which looks quite tricky!). Thanks so much. Mandy

Good afternoon All, I have created an issues database (v basic) and the user would like to be able to attach "issue related" files to the particular isue so they can access them all from one place. These could be emails, word docs, excel etc etc. After reading through some posts on this...

Hi MSAccessRookie... I think that this query would only bring back results where the manager is <NULL> I actually want to ignore the filter in this case. Usually I want the report to run for all employees where the manager = "Sam Smith" or "John Jones". the user wants to be able to query...

Afternoon all.... I have a form with a combo box which filters all of my queries. When a user selects a "manager" they get a list of all of the employees associated with that manager. This is because the user wanted to be ble to send individual "manager" reports to the managers concerned. I...

me.visible=false is working a treat..... and prints fine, Thanks, Mandy

yeah... I though that also, but I cant find a "visible = false" control in teh properties of a form.... Is there any other way of hiding it? Thanks, Mandy

I realise that my problem is something quite different. When I open the report using the button, the macro open's the report and then I closes down the form that holds the combobox. Hence my problem is actually when I am trying to print the report, the report prints out blank as it must...