Search results

  1. S

    Compile error: Expected: end of statement

    hi all. i am getting an error in my coding that i suspect may have a sinple resolution. the purpose of my form is to send emails and i have the To: and Cc: lines are predetermined. the problem that i am running into is in my subject line. below is a sample of my coding... Private Sub...
  2. S

    Option Group Question

    exactly where in my VBA coding should i place this? your coding makes pretty good sense to me, but in your parenthesis, where it says "group1,0) is that the name of my option groun comma 0 or does that have a meaning?
  3. S

    Option Group Question

    I have a form with two option groups in it. the results of the option button in these groups (three apiece) gets sent back to a table. my goal is to not allow a user to advance to the next page of the form unless a button is selected from both option groups. i have tried required fields in the...
  4. S

    ListBox Question

    I have a listbox on one of my forms what thats function is to search. theres tons of records loaded into this list box and there a text box nearby and when something is typed into it the list box dynamically search for matching values. very neat (got from a sample DB somewhere within these...
  5. S

    Command Button Issues

    thanks for the tip. i will do my very best to provide as much useful information in my requests down the road.
  6. S

    Command Button Issues

    Nah, i try not to share my codes unless it is a last resort as i have to do a lot of editing to it as i am working on databases for my employer. I appreciate the tips as always and will be sure to try the above coding. Thanks!
  7. S

    Command Button Issues

    i have a form with many command buttons tied to list boxes. one of these list boxes allows the user to multi select email addresses and after pressing the corresponding command button places these email addresses into a different text box. another list box as multiple options in it where the...
  8. S

    Filter Forms

    is there any way to incorporate this openform command to make it an event in the onload?
  9. S

    Filter Forms

    i have a form in datasheet view with many records on it. each record has a date assigned to it. what i would like is for on load the records to be filtered to show only those with today's date. thoughts?
  10. S

    form datasheet view

    the problem i am finding that i am running into is that two of my txt fields do not share a record source with the table field. i want those two txt fields to be combined and then go to the table field
  11. S

    form datasheet view

    what i have going on is the user will type values into a text box on the main form, then they are required to type other values in a different text box. they then click a command button and these values then move to the corresponding fields in the subform. Private Sub cmdAddtoBody_Click() If...
  12. S

    form datasheet view

    unfortunately they are editable. they are to be used by people to input certain findings, so i must be sure to keep them available
  13. S

    form datasheet view

    i have taken the continuous forms route. something that is annoying me though is i have a couple of text fields next to each other seperate with a comma "," as a label. the values entered in each of the field varies based on the needs of the end user. wwhat i want is the size/appearance of the...
  14. S

    form datasheet view

    alright, i have changed my form to continuous forms, how is it i make this happen?
  15. S

    form datasheet view

    is it possible to remove the excel/datasheet appearancs from a form while in datasheet view? what i am asking is can i remove the appearance of any grids and just have it as a white canvas?
  16. S

    populating text box based upon list box selection

    ugh, i knew it would be something obvious. thank you!
  17. S

    Email Generating Form

    is there any more to this code that will help move the data into my "txtBody" field? i'm sorry i am just a bit lost on this. i type values into a text box called "txtNumber" and then click on a command titled "cmdAddToBody1" and i am hoping the values entered will then popup in the bodt text.
  18. S

    Email Generating Form

    alright. i have text box A, B, & C. the user will fill in the values of these three text boxes and click on a command button too add to the email body text box. imagine text box A had "Bob", B had "is", & C had "Tall". after the click of the command button, i would like this information to be...
  19. S

    populating text box based upon list box selection

    i have a list box with a command button next to it for the purpose of "Add". the user will make selections in the list box (single or multiple) and then click on the command button to add them to another text box. i have accomplished this. i can add upto two selections at a time. anymore and i...
  20. S

    Email Generating Form

    i have been able to create the command buttons that will populate my To:, Cc:, and Subject lines on this form. i am now runing into the whole populating the Body of the email portion of my question. what i am asking sounded a bit far fetched, but after reading these forums, i have come to...
Back
Top Bottom