Recent content by funderburgh

The point I am trying to make is that this is a working query and has not changed for perhaps a year. It is working on every workstation except mine. Of course I could put on my programming hat aand mess with the query, but the facts presented here make me suspect that there is an environment...

I am getting a 3306 "Query Too Complex" message on a query in my application. This is a 10 year old distributed application in our private school. The database is on my computer and everyone, including myself accesses the data through the network. I was brought a question about a particular...

Thanks for the response. So have you generally disabled the ribbon, but use code to have certain controls show when relevant? No, it has been so long since I created the application I don't remember explicitly disabling ribbons (there were no "ribbons" when I started). And I am not using...

I have recently updated to 2010 (Wow!) and I have a long running distributed application that I have raised from a troubled child. The conversion went smoothly except for one issue (so far). I have an option on my reports menu to view a report in preview mode (acPreview) and in 2007 the report...

Thanks, I did not have that option showing, but I found that my add-in was "inactive" I got it active, but frankly, I don't know how. I appreciate the attention.

I have just upgraded to 2010 and was careful on the installation to include the packaged solution add-in, but when I open the program I can't find a way to execute the packaged solution wizard. I have an "add-ins manager" control but it does not list anythin in the drop down. Well, duh, any...

I have a report that show what students are in what classes. the student data and the class records are in separate tables. the query for the report looks like this: SELECT Classes.[Class Name], Classes.[School Year], Classes.[Teacher Name], Classes.Period, Classes.Days, Classes.[Room...

Thanks for the attention. No, but I am not distributing the ADCCR. I have a split database configuration and using developer to create a distributed application with a .msi and access runtime. This configuration has been in place for some years and was not changed in connection with the...

I recently added production of an Excel report to an application I have developed and maintained over a series of years. The version works great (finally) on my development platform. When I make a distributed version and install it, I get a run-time error saying that a specific DLL is not...

I can view the SQL string when I open the query in design view and select the SQL view. I don't need to copy it here to show that the school year data is included, it is, and the query (there are actually two queries, one for high school and one for middle school) work perfectly when run...

Exactly. Of course this is not new in my application. I have many reports that are derived by school year (almost all). Report cards and transcripts for example. This application is about 7 years old. When the Print form is open and there is data selected in the combo school year box, one...

I appreciate your response, but in order to run the module that writes to Excel the Print Form must be open, that is where the control is to execute the module. The module that writes to Excel is not a report, it is VBA code. It is not necessary for me to create the SQL string - I have a...

I maintain a grade book application that uses many queries whose results are determined by "school year". Most of these are reports and I have a combo box on the Print form for that allows the user to select the school year. The criteria field of the several queries derived by school year is...

I manage an Access application that in many instances uses data selected from a combo on a form for variable criteria. In this instance it is in the form of: [Forms]![Main Navigation]![Print Menu]![SchoolYear] I recently wrote a routing that exports to Excel based on a record set derived...

I maintain a distributed application and I occasionally get run time errors when I introduce a new version or process. Almost always it is because the app cannot access some resource it needs, like I failed to link a new table. The error does not produce an error number or log I can use to...