Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LittleJess

  1. LittleJess

    Multiple entries from list box.

    Thats great, It works, Thankyou so much for you help. [bigsmile][bigsmile]
  2. LittleJess

    Multiple entries from list box.

    Hi That didn't work, to start with it gave me an error msg of Null value then it just didn't populate the .To box on Outlook with anything. Below is the coding I am using. My list box is called List6 and the form is frmEmailposition. ************************************************************...
  3. LittleJess

    Multiple entries from list box.

    Thats great, I'll give that a try now. Thankyou. [smile]
  4. LittleJess

    Multiple entries from list box.

    Please, please, please can anyone help. I'm sure i have seen the answer to this question somewhere but i cannot find it. I have a list box and I want to be able to select multiple entries from it and send these values to my e-mail. I know that i change the properties from Multi Select - None to...
  5. LittleJess

    Send e-mail from access databases

    Out of interest does anyone know how to send the email when you get the e-mail address form a list box ? I have groups of e-mail that i need to send in one go, i have created a query that creates a table with the selection i choose and then displays them in a list box on the form, I am then...
  6. LittleJess

    Send e-mail from access databases

    Thank you all so much for this (Esp. Nathan 1967), It has helped me with my database and Access knowledge loads. [bigsmile] [bigsmile] [bigsmile]
  7. LittleJess

    Date Query

    You could just put in a parameter value on your query. Field - Orderdate Table - Orders Sort - Sum - Where Show - Check box to show Criteria - Between [start date] And [End Date] Then right click in the grey in the top pannel of the query and go to parameters, in this type start date and...
  8. LittleJess

    Date Query

    in your query you will need to create a field that looks up the entry in the form. This is how i have done it in the past, Field - Expr1:[Forms]![frmDateform]![cboMonthselected] Table - Sort - Show - Check box to show Criteria - [tblYourtable]![Themonth] this will allow whichever value you...
  9. LittleJess

    Send data from one form to another

    Thankyou, Thankyou, Thankyou!!!!!! It works. I had the first form closing and hence couldn't find the field. thankyou again that is really great!! [bigsmile] [bigsmile] [bigsmile]
  10. LittleJess

    Send data from one form to another

    Hi, I have done all that and changed the combo box to a text box and it still comes up with #Name? instead of the name of the "Branch"? would it need to be put into the form properties in VB ? Thanks [dazed]
  11. LittleJess

    Send data from one form to another

    Sorry my mistake, do you mean put the statement into the Default Value of the Properties box ? What would be the row source? I did have this in the row source and it wasn't working. By using a intermediate table I could show just this but the code for it would not be entered into the table...
  12. LittleJess

    Send data from one form to another

    Hi Lonnie, Thanks for that. I feel a bit stupid but what is a branch field? I put the syntax you gave me into the text box i was using and whe i ran it it just said #Name? Thanks for this [dazed]
  13. LittleJess

    Send data from one form to another

    Hi, Anything anyone could suggest here would be greatly appreciated. I am creating a database of a questionaire. On the first form the user will enter their personal details such as name, position and which region within the Uk they work and for which branch. The second form will be for them to...
  14. LittleJess

    SQL statement not working

    Hi LittleSmudge, Thanks for your help. I have tried that and it comes up with a error Run-Time error - 3134 Syntax error in INSERT INTO statement. It seems that most things I try and do on this come up with a syntax error of some sort. Thanks Again [bigsmile]
  15. LittleJess

    SQL statement not working

    Hi, I have the following piece of code in my database, It doesn't seem to be doing anything though. Any ideas why ? Option Compare Database Private Sub Combo0_AfterUpdate() Dim strSQL As String strSQL = "INSERT INTO tblLocation_People(LocationID)VALUES tblLocation(LocationID);&quot...

Part and Inventory Search

Back
Top