Search results

Hello DCrake, I saw your post from 2010 about a design for an appt scheduler. In one of your responses you included an image of an appt schedule. The appt date was April 1, 2010. It displayed 3 users and a list of appointments for each. I have a similar system, but my system has a subform for...

Access 2016

Thanks for all your replies. The app is used by small clinics (2 - 4) therapists, so there really isn't a need for more than 5. The scheduled times are color-coded so it is easy for the scheduler to spot open times. Each appointment time has the option for 2 sessions. Which allows a therapist...

Wayne, yes they are continuous forms. Bill

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

Thanks Bob and CJ for your input. Sorry for time lag, been away. Let me explain a little better. The end result of this project is to display the average score of each photographer over the many years that each has entered photos. This would be a cross tab report for the most-recent 8 years...

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

Steve, thanks for the information. I will give that a try. Any idea on why this functionality has changed? For instance, in some version of Access after 2007 the default (Shift key) was changed to use the VBA code? Thanks bill

Yes, Access 2016 is installed on the machine.

Mark, thanks for the reply. When I execute the runtime application I get an error message that tells me a table can't be found. The table is part of the install. I want to be able to trace the VBA execution in the startup form to see why the error message is occurring. I have opened a FE.mdb...

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

Thanks, VbaInet but removing the input mask from the table did not help. I then tried adding the input mask on the control but that didn't work either. Then with no input mask in the table or on the control I removed the "AP" Format(Now, "mm/dd/yyyy hh:nn") with the same result. Any other...

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

JHB, this is the table design TableKey (autonumber) SurveyDate Q1 Number (long integer) Q2 Number Q3 Number . Q10 number This is the survey content in the table 1 11/1/2014 2 1 4 2 2 1 2 3 4 1 2 11/2/2014 1 3 4 3 1 3 3 2 3 5 Bill

JBH, The survey information is stored in one table. SurveyDate Q1 Number (long integer) Q2 Number Q3 Number . Q10 number Each of the 10 questions (Q1 to Q10) is formatted on the form as a group control with 5 possible values: 1 = excellent, 2 = good, 3 = fair, etc. A select query to...