Search results

i have a couple of problems going right now. the first is i have a list box with many email addresses in it. i want the user to be able to select one or multiple email addresses and then click on a command button that will take the selected email addresses and place them into the "To:" field...

i currently have my form created and set up, i am just having problem with the coding. based on my above post, would anyone have any good ideas as too how i can accomplish my goal?

basically what i am looking for is this... the form has a couple of list boxes. one of those list boxes has many email addresses in it. the user should be able to select one or multiple email addresses (i already have the box formatted to allow multiple selections) and these selections should...

i'm not at all familiar with the vbCrLf . what is the codes primary function/purpose?

i would like to design a form that has a To: field with a dropdown that has multiple email addresses, same with the CC:, and a predetermined Subject line. the body of this email that i would like to generate should be composed by the user entering values in various text boxes. however, where i...

agreed, and sometimes the answer is right there in front of you the entire time.

you nailed it! thank you very much! i had "" instead of Null. so all in all the query was good. thanks again!

i have tried, but i have found that requering the form would be pointless as if i go back to the original query, the numbers are still bad. ius there a way to requery a query from within VBA?

right, i tried the me.dirty=false within the vba code where the command button allows the user to clear the record. but unfortunately that is not resolving the issue. if the record is clear and is still not populating in my query, and i still select the clear button, the query acts as if i had...

unfortunately i am unable to provide a screenshot or any attachments. do you have any siggestions as to how to make these records update? is it possible the problem i am running into is within my table, and the query works fine, but the table information is not updating?

my SQL is: SELECT Tasks.ID, Tasks.Value, Tasks.Completed, Tasks.Number FROM Tasks WHERE (((Tasks.Completed) Is Null)); basically, i have a form that has this qiery as a record source. the form is in datasheet view, and what the end user should be seeing is the list of all the ID's, next to...

i have a query that calculates how many open tasks a person has left in the day and the total value of the remaining tasks. this query functions fine and updates after a user completes a task. problem is that when a user wants to go back and clear all the fields in the form they use to complete...

disregard, i got it fixed

i am getting a run time error of 2465 when i try to reference a sub form on my main from from an on click event from another sub form on that same form. the subform i am trying to reference is not visible until this on click occurs and should be filtered based on what record is clicked. below is...

i appreciate your help, but what i have done is bypass the whole subform portion of it and just copied all the contents of the form i was going to place into the main form and pasted it, and now it all works. thanks for your help though!

i am using the strID as a reference so the value entered in the searcg box (in the header) can reference a control in the main form thus triggering the matching IDs to be filtered in the subform. i probably just confused you with that description, sorry. is there a way you would rewrite that...

thanks for the prompt reply. below is the code i have been using on the form when it is by itself before i drag it into the other form: Private Sub cmdSearch_Click() Dim strRef As String Dim strSearch As String 'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch])...

i have a form with a subform in it. as itself this form features a functioning search function. when i take this form and add it into another form as a subform the search function stops working. any help on this would be appreciated as i have made no changes to it, just simply dragged and...

is there anyway i could get you to integrate this into your current DB in the attached thread? the way you put it makes it sound rather easy, but i am just unsure f my abilities to make it work.

something odd... i am getting an "Enter Parameter Value: Forms!FRM_SearchMulti!SrchText" error. not everytime but sometimes i do. defenitely every time i open the query.