Search results

Actually I fixed my own problem by creating an error handler. Here's what i did if anyone else ever has this problem. ' Search utility for Social Security Private Sub FindSS_AfterUpdate() On Error GoTo Err_Execute Dim RS As Object NameSearch.Value = Null Set RS = Me.Recordset.Clone...

I have a combobox that has a query in it based on a Participant ID. I wrote this little search tool to find the Social, but if the record is not found and I backspace it generates an error. Actually let me be more clear on what I want to be done. First I want the user to be able to type in...

The link doesn't seem to work correctly for me. Not sure if its my work blocking the site or not. I opened it up on my smartphone (what would we do without them haha). I'll give it a run and let you know if it works the way I want. Thank you!

Thanks for the quick reply. I am using a textbox which is using a Text DataType.

I currently have a field on a form thats indexed (no duplicate values). What I want, is if the user types a existing social in the field, that it lets them know the social is in use and that the record will not save. I believe this will have to use the before update event for my...

I have a form that has 4 checkbox controls on it. I want these to be an On/Off switch for subforms in a report named "rptMainReferralForm". I'm pretty sure I have the basics down. Do i need to add a subform control on the report and set the visibility to False? Then when the checkboxes are...

Thank you for both of your responses. I will look more into what both of you have posted. @jzwp22 Ya I figured something like that. I'll give what you said a shot. I know those are reserved words too, I just didn't type them here with the actual names RSDate, etc.. haha. @jdraw I'll look...

I currently have a form with 2 combo boxes on it. One combo box has a list of participants that is pulled from a participant table. The other combo box are referrals, which a participant can have many of. When you have both combo boxes selected there is a "Report" button that displays the...

So your saying you have a Form with an Attachment. What type of attachment are you opening?

Ok after looking at this for an hour, I realized that this was a dumb mistake on my part. I have a table with all the paths to each employee folder. Well my test folder wasn't sent to the correct path. I always ask questions before I investigate thoroughly. Thanks though guys.

Hello, I am trying to generate a report to save as a PDF and concatenate different fields into the file name. This file will be saved in a individuals folder depending on a field called CareCoord. On a form a user can click a combo box for a person who they want a report generated upon. There...