Recent content by dionicia

Hi. My boss asked me to create a database which will email out to individuals their performance results, but he doesn't want everyone to see each others results. He ultimately wants to enter the information, hit a button and have the results be sent to that individual via email without having...

Hi. I am trying to get a formula in a query to calculate the percent from two different fields and if the results are greater than 100%, just show 100%. I'm using the follow formula: IIF([Not Accepted]/[Count of Entry]< 100, [Not Accepted]/[Count of Entry], 100) The only problem is that...

The main reason I was looking for reference material is I need to build code into a form I created on Excel. A user will enter information which will be sent to a range of cells in a spreadsheet or directly to the Access table. I would use Access for the form, but Sharepoint doesn't exactly like...

Thank you for the direction. This will come in very handy.

Hi. I need to find a reference book to keep at my desk at work for Visual Basic. Sometimes I may not be able to search for a specific code online and I was hoping to have a reference book I can turn to for direction. I found so far Holy Macro! It's 2500 Excel VBA Examples: Every Snippet of...

I'll check that out now. Thank you.

Hi. I am trying to set up a button on form as a means to search for information. The user will enter a number and the matching data from the table will load on the form. Is there a VB code I can use to do this as I have not found anything on the button wizard or a macro that can do this. I...

I will try that. Any ideas about the first part of my question with someone pre-filling information on the form and then emailing it out to the person taking the survey? Thank you.

Would you be so kind as to elaborate on how to use the permissions please? I tried to set up permissions using the security wizard and I locked myself out. Luckily I made a back up and was able to use that.

Oh, I'm still looking through the other threads on here for direction. If anyone knows a really good thread for surveys, I would really appreciate it. Thank you again.

Hi. I have been working on a general survey that will be applied towards different survey questions in the future. I have it done (I think) for the most part. The only problem I am running into right now is that before the survey is sent out, I want to set it up to allow someone to go in and...