Search results

Why not just use a Main Form and Subforms?

Hi Teri I don't think you need an Update Query You currently have your "qryLessonsTotalCourseDurations" which list the Totals for Each Course. Which table are you trying to update ?

Can you upload a screenshot of the table that contains the SpecialityID showing all fields as well as the table name?

Well as thought the table structure is wrong. Can you upload a zipped copy of the database?

Are you saying that a specific Dr has Many Specialities? If this is the case then your table structure is wrong. Can you upload a zipped copy of the database?

Hi It would depend on whether the table is based on 1 table or Multiple Tables?

Hi Sue Are you able to upload a zipped copy of the database with no confidential data?

Hi Colin It says Alternative

Hi Colin It is in English - Colour vice Color

Hi Colin My build is as follows:-

Hi Colin Mine is as shown below:-

Hi Colin OK I set my language settings as follows:- When I changed to Spanish and then back to English all of my Menu's are in English. Also the Alternate Row button now has Colour vice Color.

Hi Colin OK I changed my settings to those shown in the attached screenshot. And like you the VBE language remains in Spanish.

Hi Colin I believe I have English (United Kingdom) installed.

Hi Colin I added additional languages and defaulted to Spanish. Restarted and both Menus in Spanish. Reset to English and restarted and both Menus now revert to English. Also the Command button reads as Alternate Row Color.

Why do you want to display the same date twice in the same record?

It would help if you can upload a copy of your actual database with some non confidential data

Hi Welcome to the Forum This Link provided by Gasman will start you off

Hi Jill Your problems are down to bad design. The Estimate has many details so you need to structure the Report so that the Main Estimate details are contained in the Report Header with all of the Details in the detail area.

Hi Pat My apologies for not saying what I did. The Op stated that they wanted to select Multiple Records. So I removed the subform and created a Listbox which was set as Multi select