Search results

Hello, I have an appointment scheduling screen for physical therapists with a main form and 5 subforms in the main form's detail section. Each subform supports a single therapist, selected from a dropdown list. Each subform has the appointment times (8am to 5pm, in 15 minutes increments), a...

Hello, I am working on a patient billing statement report that will be mailed once a month to those patients with a balance due greater that zero. The balance due is calculated when the report is created. The sub report lists the charges and payments made for each item then calculates the...

Hello, I am processing a file from another application. All is going well except the date comparison within my application (ActivityDate as Date/Time with an input mask of 99/99/0000;0;_). The date field in the incoming file is text: "20170128". It will always be 8 digits. I want to...

Hello, I am developing an app for a photography competition. I have two tables: Photographer (TblPhotographerKey (primary), name, phone, etc.) Results (TblResultsKey (primary), TblPhotographerKey as foreign key, score for each category.) The Photographers table and Results table have a...

I am trying to use MS Access 2007 on a Windows Vista machine to 'print-to-file' a report that has only text (letters and numbers, no graphics). I am using the "Generic/Text only" printer. I view the resulting .txt file in notepad. Here are 2 examples of the problem: 1) In the actual printed...

I have an Access 2002 runtime application (configured for Windows 7) that is installed on Windows 10. Access 2016 is also installed. I receive an application error on the start screen when I click the button that opens the signon screen. This error does not occur in development. I would like...

Hello, I have a report that is displaying a blank page at the end of the report. Using Access 2007. The last field in the detail section displays correctly about mid-way down the 5th page. Page 6 is blank. Page width is 7.5" with the left and right margins each set at 0.5" The detail section...

Hello group, Medical insurance (in the US) requires a date/time stamp message when an electronic signature is used on a report: "Electronically signed by Jane Doe 7/10/2015 10:05 PM". The message is in an unbound control on the report. When a user does not have an electronic signature only...

Hello group, I have a main report with 5 sub reports. There is a detail page for each company and a totals page at the end. The record source for each sub report is a Union query (combines the detailed information with the total information. One of the sub reports displays currency amounts...

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

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

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

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

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

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

Hello all, I have a form for physical therapists to identify a patient's pain location(s) using option button controls that overlay an outline of a body part (leg, arm, etc.). The associated report needs to display only the controls that are True. Each of the controls starts with "Pain" (Pain1...

Hello group, I have a customer who is receiving a 3021 (no current record) message. The message occurs when the user clicks on a patient's name in a dropdown list. The dropdown is populated with a query accessing the patient table. The information for the selected patient should display on a...

Hello group, I have a multi-user application with split databases (BE/FE). The database is opened in Shared mode, Default Record Locking is set to Edited Record, Open Database by Record-level locking. Each user has their own FE. The users are physical therapists writing their treatment notes...