Search results

Okay, so now that we know it isn't the length of the string :) (Each email address is between 7 and 40 characters long, there are around 100 email addresses so no more than 4000 characters in the string, plus 99 commas and spaces, so figure no more than 5000 character in the string at any one...

gratzie! :)

Anyone know why, when I run this code, it will only create a string of a limited number of email addresses? Anytime I select more than five items in my list box and ask it to create the string and pass the variable to my procedure (see end of code snipet) it only gives me the username part of...

Anyone know how to force a carriage return in a concatenating string in VB? I have a long list of names that my code gathers from a list box and I want to force a carriage return inbetween each one. I searched the forum but wasn't able to find the answer on here (although I probalby just...

Okay, solved the problem. Here's how I did it: Created a concatenated string of the values in the list box separated by commas, passed that string to the SendTo line of the email procedure. Simple right? :) ___EDIT____ Then again... In order to get Lotus Notes to send an email to multiple...

And here is the answer: http://www.access-programmers.co.uk/forums/showthread.php?t=32186&highlight=bulleted+list

Now that I'm not so sure about. I'm sure someone on this forum can find a way... unfortunatley I'm not that person. Hopefully one of the more experienced Access programmers will be able to help with this one.

If i understand your question correctly, you are using a text box on your form to create this? There is a property for text boxes called "Enter Key Behavior." It is exactly what it sounds like. Set it to "New Line in Field." That should take care of it! :)

Okay, is this for a class assignment? If so, can you do this another way? What if you created a combo box on your form that is bound to two fields in your table: Field1=Customer ID and Field2=Customer Name (which can be either first name, last name or the concatenation of the two). If you...

Put this code in the After Update event of your combo box Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ComicBookNumber] = " & Str(Nz(Me![Combo12], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark For ComicBookNumber above enter the name of the field that stores your...

I have a module of code that sets up a Lotus Notes email and brings the user to the notes email window. I have a form where a control calls the module. The module works just fine, except that i can't get the email addresses to show up in the To: field in lotus notes. I have on the form a list...

Anyone have any suggestions for really good resources for learning more about programming security into your databases?

Okay, if my understanding is correct you have the field in the parent form already set up to display the field from the table. You would like the same field from that table to also display on the child form? Is this accurate? If so, then you can either bind the field in the child form to the...

Neil, Thanks for your advice. I searched as suggested and your answer now makes a whole lot more sense. I don't think I could have come up with all the problems that result from storing a calculated value unless I got to the point where I needed to create a database that utilized this...

Data type mismatch error For some reason when I try to run the query now I'm getting a "datatype mismatch error" message. Could this be because I am trying to filter a Date/Time field in a table using a Text Box field on a form?

How adept are you at visual basic programming? Behind each of the buttons the wizard sets up is an on_click event that triggers a few lines of code, which enable the filtering action to happen. Chances are these buttons are filtering both the form and sub form because the code is not specific...

If I understand you correctly you want to make it impossible to enter any data into the fields that are automatically calculated. If this is the case then simply set the Locked property of these fields to "Yes" and the Enabled property to "No". This will prevent anyone from being able to put a...

Can you post the code you are using to have it change the source? Is it possible that you simply have a spelling error in the name of the new control? I know this sounds stupid, but I've spent days trying to fix lines of code in databases only to find out that the problem was a stupid spelling...

I'm trying to create a query where the informaiton returned is based on a date where the month (and only the month) is the month (tblMeetingInformation.dtmMeetingDate) immediately prior to the month entered on a form (frmSendList.txtDateSelect). In other words, if the date selected is in march...

Just have an unbound field on your form for "quantity" and set the on update property of that field to an event procedure that adds the value of that field to the value in the table for the quantity of that item, then returns the new value to the table in place of the old one (not sure if my...