Search results

As a followup to this, after much searching, I found this link: http://www.ureader.com/msg/105420330.aspx In which someone talked with MS on this issue and apparently you need to use the local version of Dev tools to be able to use a different install language. In my case that would be Russian.

Hello, My Access 2010 installation is in English and I have installed the Russian language pack. When running the Package Solution Wizard and I try to change the install language to Russian, I just get a link beside it that says 'Add support for more languages' which takes me to the MS site...

This is a bit of a minor thing, but I didn't find any info on it. I am using the 2010 package solution with the option to require runtime to be downloaded if it is not installed. Everything is great except that the link that it provides is to download Access 2007 runtime even though the...

This is the first time I'm working in Access 2010, so maybe I'm missing something simple. In my program I preview all reports and the user prints if needed. There is a form to choose report options and then a button to preview the report. On one particular report, if it is the first one...

Hi, I have a Product form that includes a delete button. Before deleting, I want to make sure that this is an unused product id so I have set up several stored queries to check tables for records using this product. In the queries, I am referencing the field ProductID on the current form. If...

I have had to deal with this a couple of times in the past, and as I remember, I think that you can get some lines and things to work, but you are limited pretty much to just horizontal lines. At least that's as much as I could get to work. What I would suggest is to take out all of the lines...

Yes ... Exactly. I don't want to do that, so I need to duplicate the format of the pivot for the report. It is possible to use a form/subform on a report, but the formatting is not desirable. Tom

I have a pivot table on a form working just like I need it to, and I need to include it on a report so I want to make a crosstab query exactly like it so that I don't have all of the label and heading formatting. The problem is that I can't get the crosstab to do what I want. Is it possible to...

Thanks I haven't gotten that far yet, but I am going to have to print it out. Thanks for the heads up. Tom

Perfect! Yes, that worked! To clarify what I did: I changed the form to show a Pivot Table instead of the Pivot Chart. Then I could right click on the label and choose properties where I could edit the label (you don't have that option in the chart). Then I changed it back to a chart and it...

Does anyone know if it's possible to change a category label in a pivot chart? I can read the category names, but if I try to change it, I get a message that it is read-only. Maybe I'm missing something simple, but I am making a radar chart and to get it to display correctly, I end up with...

I asked the customer for a little clarification and I think that I will end up having to do it all with code. I thought maybe I was missing something with a query that I could do. What they are looking for is a best 5 day 'rolling' average. So, if we are looking at the production for...

I've looked thru a lot of posts, but can't seem to find the solution. It seems like this should be something I could figure out, but so far have not. I have a table that is showing a production number for each day. What I'm trying to show is the best 5 day average production over a period of...

Figured it out - I had a routine to requery everything that was running before it got to the save routine.

In a form I have a control that references a total from a subform. The controlsources of the total is: =Sum(IIf([dept]="DMH" And [Shift]=1,[Hoursdown]*0.938,IIf([dept]="BCDMH" And [shift]=1,[hoursdown],0))) The records on the subform are for 3 shifts and this gives me the total for shift 1...

Rich, Actually that is what the original problem was - no matter what I did, when I opened the form, it would remove the [Event Procedure] from Before Update in the property sheet. I even tried building some code for another procedure and that one worked. Of course I didn't try closing...

Thanks Doc Man, Your suggestions give me some places to start looking. As a temporary fix, I just made the control in question required. I just wanted a little more graceful message than the standard one you get with that. When I find the culprit, I'll post back. Thanks again, Tom

I am making some changes to an Access97 database that I didn't build. It also uses a lot of macros, of which I know little. On one particular form, I want to check and make sure a date was entered before saving the record. I have built the code in the Form_BeforeUpdate sub. I clicked on the...

Actually, as I think about it, if the user hasn't got Excel, there is no need for the function, so I'm probably better off checking to see if Excel is installed before running this function, then setting the reference at that time. Tom

I have an application which includes a process that creates an excel sheet with some data. For this I have set reference to the excel object library. I am now packaging a demo of the application with Office Developer and including Access runtime. The question is what to do about this...