Search results

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...

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...

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...

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 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...

I learned about late binding to an Excel object today when I tried to distribute my slick new version of the application I maintain to workstations with older versions of Excel. Well I have late binding working (it seems) but I am getting errors on a couple of formatting statements that were...

I have a need to move the back end database of a distributed Access application to a more secure location. I have developed this application over the course of several years. I have moves the tables that are linked and updated the location in the front end. I can verify the location in the...

In the private school where I toil, I have developed an Access application which is widely distributed as an executable. A student recently "discovered" a security hole in our LAN that allowed students to access the shared folder containing the Access database used by the distributed...

I have an application I have built for our private school. The application uses shared databases and is installed on workstations through the school. The database is stored on a public file on my computer. Recently I added a table to the database and tested its functionality on my development...

I have a report that shows a schedule for a student. It draws data from a table of students and a table with class schedule information and a table that is used to sort class records by weekdays. I have added a table of static text descriptions for a list that appears on the schedule. These...

This problem is self inflicted. My report is a school transcript. The data is drawn from a make table query. Each time the report is run the table is re-created with the data for the student in question. Not all class records in the table are showing on the report, and the condition of the...

I am developing a small application and I have public functions and variables defined in a module. My first feature works well: Form1 opens Form2 which puts a value in pubVar1. Form2 opens Form3 which uses the value of the public variable. I am having a problem with my second feature using...

I am writing a little swipe card application. My "Main Menu" has an event to allow the user to swipe their card. The form I created to prompt the action is very simple with only one label on it. When it is displayed, it is blank. The only success I have had is to set the Docmd OpenForm...

I manage a distributed application with split databases - multiple users, one server. I have added a function to the application that requires the deletion and re-build of a table through a make table query. The test version of the application does not create linked tables in this process...

The version of Visual Basic in my Access 2007 is 6.5. I am adapting some code for smart card processing from Visual Basic 2008. I am getting an overflow error on Integer variables, here is an example: PublicConst SCARD_PROTOCOL_RAW As Integer = &H10000 This works in the 2008 compile. If I...

I'm new to DAO and walking through my manual. I want to use the execute method to run a query in VBA (the SQL is really big), but I can only find a description of how to create a QueryDef "from scratch". Can I create a QueryDef from a query which exists in the Access workspace? Any help is...

I have a query that is selecting students from a student table, keyed with an id. I want to only select students who are seniors in a certain year. The grade level (i.e. senior, junior) is contained in another table with ID, Year and Grade Level fields and is related to the student table...