Search results

text boxes on the report

TRANSFORM Sum(tblPayments.fldAmtPd) AS SumOffldAmtPd SELECT tblPayments.fldType FROM tblPayments GROUP BY tblPayments.fldType PIVOT Format([fldPostDate],"mmm-yy");

I have a report based on a crosstab query that I thought would be easy to do. It basically shows the information in the query and then puts a grand total at the bottom. Piece of cake until it asks for a percentage to be calculated off a portion of the detail. Example of Data on Report...

actually.. never mind. I've decided to go back to accounting. Thanks for all your help guys.

GalaxiomAtoHome, I tried doing this and ran into errors "user defined type not found" I am not sure I can work with ado libraries very well. I think the person I am developing for in on Access 2007,but don't know what OS they have. Can you suggest a good excel forum to get some help from? I...

Thank you for the input

lol.. I love that opinion. Unfortunately, I don't get to make the decisions...... yet For the moment I have it linked and it appears to work great. But I have that feeling like there is something I am not aware of that will cause an issue later.

I wanted to set it up in Access, they wanted it in Excel for the moment. Its going from Excel, to Access -reformatted -then back to Excel. I think its more of a time issue than anything at the moment

Just a quick question I have an Access database that when a button is clicked it will open an Excel spreadsheet for entry. When the entry is done it will call an Access function which will run some calculations and update a specific table stored in Access, then it will close the excel...

Well Simon... that is an extremely good question that I, unfortunately, don't know the answer to.

Would you be interested in a contract job since you know about this so well? and yes.. I am being serious

yeah.. just wish there was an easy way to convert the forms from one to the other without having to redo all the code that is A LOT of work. some of the code I used for creating the reports is sql. Will that be ok to use?

:( oh geez... I knew it sounded too easy. Gotta be a bright side to this, lol I may need lots of help!

Got it set up and it worked great until I got to the very end and it said I had to select a form to display when it goes to the website. My option to select a web display form is greyed out. Would you know why?

I had to go look found this note posted for someone elses question. Our SharePoint® Hosting has not been upgraded to the 2010 version as of yet Not sure when that was posted but I imagine that is the problem. I guess I will need to google sharepoint 2010 hosting

It occurs when I go to publish. I get that it is compatible but it won't publish to the site. Its a hosted site. 1and1 I have a feeling I will need to create a server partition on my laptop I have their technical support on the phone and will be calling microsoft in a moment

ok.. I got an error that says "An error occured while initializing the Access Services Database" This will be a setting on the website and not the database?

Thanks.. this is gonna be one of those times when I say... "There has got to be a better way!"

Just when I though I was done.....I have been instructed to Web Enable the database I am using to a sharepoint server. Looked easy enough. I ordered some server space and ran the compatability check. Had a few issues which are easy to resolve, but one I don't think I should have to and was...

I just want to tell the guys that helped me out thank you. You were very patient with my brain dead questions. The database is being distributed next week and works very well. I am to a point now where I am not putting in so many hours at work and have some free time.... umm... at least for a...