Recent content by Zara D

Hello Mark, No, it doesn't unfortunately :-(.

Hello, I am facing an issue with the print preview of a report. The report has 12-13 records but the print preview is showing only 6 of them (and half of the page remains empty!) :banghead: Do you have any ideas why that may be? Thanks a lot! Zara

Hello, I need your help wrt. the attached data base please. If you open the Entry form, you will see three cascading combo boxes (Procure 21, Contract and Contract Sub-type). There is a code, which sets the Contract and Contract Sub-type to " " every time Procure 21 is changed. It is all as it...

Hello, Thank you all for your help. Just one final question, hopefully. As we populate the combo boxes, I am trying to make them empty, if the first combo box (Procure21) is changed for a second time. I have used this code and it works just fine. Private Sub cboProcure21_Dirty(Cancel As...

A BIG AND VERY SINCERE THANK YOU!!! This is exactly what I needed and now I can go on with the rest. As I want to learn from that, may I please ask why the Criteria for the queries feeding the combo boxes are set up this way and not the way I had done it? I watched so many tutorials and yet...

Hello Pat, I created all the tables and tried to do the connections but now the combo boxes are empty!:banghead: I checked obvious reasons, such as bound column, column width, etc. and all seems to be OK. Do you have any idea why it is not working? I am attaching the modified file. Thank you...

Hello Pat, Thank you for your guidance. I will be trying again tomorrow. Just a question please. Since the JCT option in Contract should be always be enabled (for both Procure 21 values) does this mean that in the contract table there should be two JCT rows - one matched to the Procure 21 "No"...

Hello, Please disregard above post. I am attaching the zipped file, so that it is easier for you to see. In the Entry form, I am trying to set up the Contract and Contract Sub-type combo boxes based on the following logic: If Procure21 = "Yes", the only option for Contract should be "JCT"...

Hello, Thank you both for your input! I have been through so many sample databases, codes, etc. but without success. Apparently, it will be a steep learning curve. I have changed the approach and now I am trying to get the values of the 2nd and the 3rd box from separate tables and I have...

Hello, I am a newbie in Access and working on my first data base (cannot attach, as size exceeds limit). Basically, upon opening, a form representing the main user screen should pop up and users should be able to add project records on a blank form. On the entry form there are three...