Search results

Hello Group, I need to create a customer satisfaction survey summary report. Each question is a group control with 6 check box choices. There are 10 questions. A question looks like this on the form. Question 1 excellent good fair poor very poor N/A The values for the...

Hello group, I have a runtime application developed with Access 2007 on a 32-bit Vista machine. The app uses a customized ribbon. The references include Microsoft Office 12.0 Object Library, Microsoft Access 12.0 Object Library, OLE and VB for Applications. The MS Office 12.0 Object Library...

The following message does appear, I just don't know where it comes from. "Execution of this application has stopped due to a run-time error. The application can't continue and will be shutdown." I have looked for missing error trapping but haven't found any yet. Bill

JHB, PublicVaraible9 is declared as a Variant. TblDocID is the key field for the record that contains the physician key, which gets me to the physician's name. The user is running the runtime version of Access 2007. I don't have access to their computer. The error does not occur in...

bob, the message says, "Execution of this application has stopped due to a run-time error. The application can't continue and will be shutdown." Bill

Hello group, I have a user experiencing a runtime error when the Print button is clicked on one form within the application (Access 2007). There is no error number assocatiated with the runtime error message. After clicking OK on the message Access shuts down. All of the VBA modules have...

Lagbolt, my upgrade process is similar to yours. I found a solution to the new tables in the BE not accessible from the FE. I discovered the issue when I right-clicked on one of the "linked" new tables in the FE and selected Link Manager. The new tables had a path to the BE in the install...

In the upgrade code, I delete the current links and then after the new tables are added, tabledef is refreshed and inks rebuilt. The result is the same - the BE database has all the changes (new tables and new fields) but I cannot open new tables from the FE. Here is how the upgrade process...

Lagbolt, that helped. But still have a problem. When I look at the Backend database directly the new tables are there and display (both data and in design view). When I open the FE the new tables are in the table list and appear to be linked to the FE. But when I try to look at them I get the...

Yes, I am trying to create the tables in the backend. What do I need to do to accomplish that? Thanks, Bill prior to the call to the subroutine the db is set to the location of the BE db. In development this all works fine (adding tables to a standalone BE).

Hello group, I have an application that runs Access 2007 (runtime package) at remote locations. I want to add several tables to these existing databases. The code below creates a table and adds the primary key field. When I run the code it creates an entry in the table list, but when I...

Boy, what service! The original question was posted in 2006. I used IIkhoux's solution to the original post. But, this new approach will work on a new project I have. Thanks, Bill

The user has a Windows 8 laptop with touch screen. They disabled the touch screen feature and the buttons work correctly. The two buttons that produced the error have the same properties as all the other buttons in the system. The VBA code behind the buttons is the same as other buttons used to...

Hello All, I have a customer who is running MS Access 2007 runtime on a Windows 8 laptop. The "MS Access has stopped working" error message occurs when the user clicks 2 of 5 buttons on one form. Access then shuts down. After restarting the software all data is present. All other forms...

Thanks John, the Before_Update works for the fields on the current record. I also need to be able to do detect, based on the Treament Code value (e.g., 97001) on one record, that a record with Treatment Code 'G8988' exists. Bill

Hello, I have a continuous sub-form on a main form. I need to be able to validate the data entered on each row of the sub-form as well as perform contextual validation between rows, including when a row with specific values is not present. I also want to ensure when a validation error occurs...

We found the problem. The software installed and worked correctly on two other PCs that had only MS Word and Excel. The PC that had the problem (.accdr assocated with Internet Explorer) had MS Office 2010 with MS Access. When MS Access was uninstalled the problem went away. Bill

Alan, thanks for the information. As a result of the application install, MS Access runtime should be on the PC. I expected to see MSAccess.exe in Program Files/Microsoft Office/ Office12. But the customer tells me nothing is there. Is there some other location we should be looking? Thanks...

Hello, I distribute an Access 2007 application to custmers using the Runtime version. I have been doing this for several year without encountering this type of problem. The customer has installed the application successfully on other Windows 7 PCs. The customer installs the application on a...

Hello group, I have a form with a subform. The common situation is information is entered on the form / subform and the report/subreport prints correctly. However, there are times when the user wants to print a blank report so a patient can fill-out the information on paper. Since no...