Recent content by Marckas

It does not let me select Group. Gives me a message "cannot group that selection".

I just want to change the values of cells that contains date like "01/14/2009". I wanted to feed the list into a pivot table but I wanted to change the values of the date to just month and year like changing 01/14/2009 to Jan 2009. I know I could use the format cells thing, but when I feed this...

Thanks a lot guys for your answers. It was really helpful...

I am trying to drop a temporary table but I get this error message. This same script used to run in SQL Server 2000 and now we upgraded to 2005 and its not working. I am not sure if it is a permission issue or not. ERROR MESSAGE Cannot drop the table '#outline_codes', because it does not exist...

I have got 4 offshore resources in India that are trying to connect to Project Web Access (Project Server) via VPN. Project Web Access is set up to pick up their windows ID and log them in automatically. 1 of the offshore resource gets to the homepage and then when he clicks on a link it routes...

That worked! Thanks a lot! Remou

I have a form with some VBA coding behind a command button. This form has a combo box drop down where I select the resource name and hit the command button and it will retrieve the report for that resource. So it is one report at a time. Now, I want to combine all the reports that I multiple...

For some reason, one of my users that is using an access application that creates pitvot tables forms is getting this error message " There isn't enough memory to complete the automation object operation." There are around 40 users that use this effectively and dont have a problem except for...

For some odd reason,2 of my resources went to log in their actuals via project Web Access only to find out there were removed from the assignments. They also got an email notification "Your project manager has altered the project so that you are no longer assigned to work on the task(s) listed...

For a task that has only one resource with no duration. No work hours have been scheduled and no actuals have been logged but for some reason there are negative costs entered for three months. At the summary level for the task, the negative costs are showing up, but at the task level where the...

I have an access application that has linked sql server tables invoking a username and password. There is an event procedure on the opening form that has the following vba command. DoCmd.OpenQuery "Delete_Outline_Codes" DoCmd.OpenQuery "Append_Outline_Codes" When I distributed the application to...

Where do you put this code. I have been trying to put it on the sqith board On open procedure and it is giving me an error on the first line.

I have an access application with existing linked tables to SQL Server. I just added another linked table from sql server using a file dsn. Now, the problem is everything is working fine on my computer but when I go ahead and distribute it to other users, it seems to not work. I know why...

yes I do. BTW thank you for your response. I have a DNS setup. I am getting the field from a DQL server table. I created a linked table in access to the table in SQL Server. I then created a quesry in Access that feeds of the pivot table. I know it would be so much easier to just do it directly...

well, the probelm is I created the pivot table from the MS Access Pivot table wizard with a heavy query that is made up of licked SQL Server tables. When I try going thru hitting the back button in excel located in the pivot table wizard, I get an error after I select the external data source...