Search results

HOLY CRAP!! UMMM, PROBLEM!! I have the following in place: Select Case Me.MARITAL_STATUS Case Is = "SINGLE", "DIVORCED", "WIDOW", "WIDOWER" Me.SPOUSE_ADDRESS.Visible = False Me.SPOUSE_CELL.Visible = False Me.SPOUSE_CITY.Visible = False Me.SPOUSE_E_MAIL.Visible = False...

Now that I have that working correctly, I have another question. Is there a way to add "sub-categories" to this type of application? Explaination: Now that I have these criteria defined and hidden when appropriate, I am adding more functionality. I also have a toggle button for “Spouse...

You, sir, are a genius. Thank you very much for the help. IT WORKS!!!

What would one do if they would like the same ouput for multiple selections in combo box? Here is waht I have, but it does not work. I am rather new at coding. Do I have to list the true/false for each selection? Select Case Me.MARITAL_STATUS Case Is = "MARRIED" Or "SEPARATED"...

I have had my DB split for quite some time. Initially, it was just myself and one other accessing the DB at a time, so when I needed to update the BE I just had my co-worker log out and I would make the changes. Now, I have more people using the DB and this option is much more difficult. I...

I have no idea how to accomplish this. Can you help me? I would appreciate it very much.

I am, once again, begging for the help of the DB geniuses on this forum. I am trying to split my db and am getting the errors you see in the screen shots. Please help! Thank you in advance.

I have a form that I have created using Mail Merge. It draws from a qry in my db. When I open the qry in Access, data is displayed, yet when I hit the merge button in Word, it tells me there is not data that matches. I have verified all of the fields in the MM doc and that they all exist in the...

That was my question...I am not sure how to write the function. I know nothing about VB and I fear that is where my answer lies. I would rather write the code myself, but I am not quite sure how. Any help would be greatly appreciated.

I have a tbl that stores all my training dates. Some training items require multiple dates be recorded (i.e. quarterly recertification). My quandary comes in the form of most recent date selection. I have multiple qrys that need to return only the most recent date for a given training item...

My way works for my application, but might not act correctly in other applications. Good point! Thank you for all of your help!

I think the delete query idea is best. My next question would then be, is there a way to create a command button that will initiate the file import. It should open a file selection window (standard open file box) where the proper file can be chosen, then automatically import data into a...

I did exactly what you described and now understand the "why" behind the what. Thank you very much for your time in explaining. I will continue to research the types of quries and applications therein. Again, thank you for your time and help.

This answered my question, thank you. However, after tinkering a bit I figured out another way with less steps. In the video, do everything exactly like it says right until the time that you close the query you had opened from the properties box. Once you have selected the columns (data to be...

I have a tbl (tblDATA_TRNG) with the following fields: TRNGDATAID (PK) TRNGID (FK) DATE SCORE CODE REMARKS My situation: the data entry team will receive reports (Excel format) from supervisors which they will have to enter. The easiest way I can see is to have a tbl (tblIMPORT_TRNG) for the...

I have a subform that containes a combo box which is bound to a table other than the table the subform was created using. Not sure if that makes sense so: tblPERSONNEL tblPOSITION qryPERSONNEL -NAME -EMPL# -POSTITION subPERSONNEL (based off query to return only personnel in certain...

I am understanding normalization more and more and I think I have a grasp, but am still not quite there. I understand the thinking around contact info and emergency contacts and the like since they are a one-to-one type data set. The problem I can't seem to figure out in the quest of...

Thank you for the help; however, I do not understand. Can you please explain in more detail what the advantage of the scoring system you outlined is and how to employ? I am really new to this. I will combine all into one table, but am not sure what to do with the check digit. Thanks again...

I am building a portion of my DB for training tracking. Variables in training to be tracked are two-fold: date contstraints and training type. Date constraints: One time certification Fiscal year re-certification Calendar year re-certification Semi-annual fiscal year re-certification...

Now I understand. Thank you for taking the time.