Recent content by BLD

To all, Thanks for your comments. Yes it is not normalized. I am working with an excel questionnaire of about 50 questions and I am trying to compile all of the answers. I would have to write too many formulas in excel and wanted to move the data into access. I am thinking about creating...

All, Is there any way to increase the Default size of a Table Field Name of 64 characters in Access 2016? I know this is the default but was hopeful it could be done somehow or a work around other than limiting the import field names I am working with. Thanks, BLD

Thanks, it will work in the before_update event but it does not prevent the user from disregarding the message and closing the form and saving the record.

I am using access 2007 and I am trying to get the code below to verify if 2 fields on the form are blank before closing. I tried using this in the close event and unload event and it does not work, just closes regardless of the fields. If [field1] = "" and [field2] = "" then Msgbox " You...

Thank you for your reply but I can't seem to get that to work. I set this up on the click event of the check box where if the box is not checked it will add up the next 2 fields. If the box IS checked it will add up only the second field. The only issue is if both boxes are excluded how to...

I am hoping I can explain what I am trying to do sufficiently. I have a form with 4 text fields for each txt_TOTAL POINTS POSSIBLE txt_TOTALS POINTS RCVD txt_Exclude , Check box to exclude points if checked At the bottom of the form I am totaling up the Points Possible & Points Rcvd. I want...