Search results

Thank You GaP42 for your suggestion, I am sorry for the misunderstanding We want to see the records as follows; Show the SERGEY records that are marked WATCH and the INVESTIGATE records that are marked YES and the SECTOR records that contain no value and the SUB-INDUSTRY records that contain no...

Could we please receive help in advising us how to show the NULL records; If the fields contains Watch and field contains Yes and EITHER of the other 2 fields are null Your assistance is appreciate. Nicole

Thank you TheDBguy for your question. We thought of using word for our reports, but have decided to use Access Reports, as the Access reports are DUPLICATES of our Data Reports, but without data. Nicole

Could we please have assistance in helping us choose the quantity of empty report pages that we require? The reports that we will be printing contain NO DATA and are manually filled in prior to entering the data into our computers. Your assistance will be appreciated. Thank you. Nicole

Thank you Ebs17, your suggestion works.

Thank you, GaP42 for your suggestion, which works.

Could we please receive a suggestion on how to print reports with 2 extra pages? How can we print this report when investigate is Yes and then AFTER the report is printed, "Yes" in the table will be changed to No? Thank you for your suggestions. Marlyne

Thank you GaP42 for your note. 1 = we copy the data base before running the compact and repair function every Friday, as a matter of routine. The Analyst Company is only used on this form, The Sector is an attribute of the Analyst The database application is on a single computer We will never...

Thank you Mike60Smart. Do you suggest removing the auto number field and than it will be replaced by Analyst_Name? Crystal

Thank you GaP42 for your note. Could you please advise me if the controls on our form are wrong, as we have Order by; Analyst_Company, Analyst_Name on our form? The ordering function is fine. The query Analyst_Updating_Q, just opens the field for review. All data is typed directly into this...

Thank you, The Doc Man. We are going to have Access 2007 removed from the machine with both 2003 & 2007 access and place 2007 on a sperate machine. ? Should we set Access 2007 to Always compact on close? Thank you Nicole

Thank you arnelgp for your note. We had placed a note in the local University's newspaper, twice and received no replies for assistance in converting the Access databases. All of the Access 2003 databases have been converted, but now we are working on 2 stubborn conversions, of which we have...

Thank you the DBguy for your note. I followed these instructions, "To convert an Access 2003 database (.mdb) to the .accdb file format, you must first open the database by using Access 2007 and then save it in the .accdb file format. The above instructions have worked fine for 7 of the...

Thank you "The Doc Man" for your note. We installed our Office 2007 Access from our original Microsoft Disk, but have left Office 2003 Access on their machine. Should we remove Access 2003? Crystal

Thank you for your note, tvanstiphout. The Charity that I Volenteer at has so many old Access legacy databases, that they want to upgrade each old version to their next version to ensure that their data is not lost.. Currently we are converting their 2003 to 2007 than when all of their 2007...

Our boss has asked us to convert many of our Legacy Access databases from Access 2003 to Access 2007 and we have received the following errors. On one of the data bases; being converted. The Expression On Timer you entered as the event property setting produced the following error. The...

Thank you June7, plog and Pat Hartman for trying to help us, but we have had no success in this project and will just give up. Nicole

2023_Jul13, we thank you for your suggested code. The three volunteers in our office I think have followed your instructions but with no results. Please look at the attached database and tell us what we have done wrong? Yes_1 and Yes_2 works as originally sent in, BUT we can not get, Yes_3 on...

2023_07_Jul08 Thank you Pat Hartman for your note. Can you please look at the main menu form and advise me why; the function at “Clear_Yes_3” still does not change the “Yes” to “No” in the table and an error message occurs after changing the code to your suggestion? The other 2 Yes to No’s...