Search results for query: *

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

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. ************************************************************...

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

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...

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...

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

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...

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...

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]

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]

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...

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]

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...

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]

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...

That sounds good to me,I'll give it a try. Thanks [bigsmile]

Hi Again, Have you any ideas on the SQL statement I should be using ? I have been trying INSERT INTO and SELECT INTO. But neither of these ahve the desired effect and i can't seem to find the statement to help. anything would be greatly appreciated. THANKS [bigsmile]

Thankyou Hymn, I'll give that method a try. Getting to the stage where I can't see the wood for the trees. Cheers again [smile]

Thank-you foolio12. I would have put them in the same table except that some of the people will have mutiple locations which would create problems. The database will also have the potential to be very large and doing it De-Normalised may cause problems. I'll try what you said with the...

Hi, I am trying to create a contacts database I have created a form with personal details such as Name, Tel, Fax etc and on this form I have included a subform with Location (Address 1, 2, 3 Postcode etc) In order to create 1:M instead of M:M (People may have many locations and locations will...