Search results

nope its a accsses database :(

sorry forgot to say that i need to make the feilds say all is there a way to add paramiters to the title: Trim(Left([Contact FName],InStr([contact FName]," ")-1)) to say something like if contact fname has 2 X " " then its has "MR J Blogs" move MR to TITLE Move J to FNAME and Move Blogs...

ok i have 3 fields in my database ~Contact Title ~Contact FName ~Contact LName how ever when i ported data using a ammend quary from the old database the name was in one feild now as this database was in action for a bit there is a mix of data in the feilds for example it could be...

Thank you vbaInet for your time :)

it was mudding the data up so i changed it to strSource = "SELECT [ContactID], [Contact FName], [Contact LName] FROM tblContact WHERE [ContactID] = " & Nz(ID, 0) & " ORDER BY [Contact LName], [Contact FName];" ad now it seams to be working ok

Private Sub Form_AfterInsert() Dim strSource As String strSource = "SELECT [ContactID], [Contact FName], [Contact LName] FROM tblContact WHERE " & me.ID.Text = Nz([ContactID], 0) & " ORDER BY [Contact LName], Contact FName];" MsgBox (strSource) Me.Combo137.RowSource = strSource Me.Combo137 =...

the code i just posted produces the folling error The record source 'false' specified on this form or reort does not exist the name of the recordsource may be misspelled, the record source was deleted or renamed or the record source exsits in a diffrent database in the form or report...

ok that creates errors like no tomorrow, i cant seam to get my head around the record source so im gonna change it to make it easyer i want to just display the first name and last name of the current customers contacts now as the contacts id is linked to the customers autonumberID...

ok now im lost, there is no customer combo box, its just a single combobox that im trying to list the customers contacts on the frount page for the mailmerge buttion.

nope im with u and that 0 at the end is the value it replaces it with if the value is null? ok right so this is the code all put togeather Dim strSource As String strSource = "SELECT tblContact.ContactID, tblContact.[Contact Title], tblContact.[Contact FName], tblContact.[Contact LName]...

ok i can see the code i keep seeing nz what does that mean? and when you tell me please be gental lol

oh it hasent posted it right the contact table has the following ID Autonumber CustomerID (for linking to [Customer]![ID] using a relationship with the join and child/master setup) Title FName LName ECT thats how its ment to be right so that there are MANY Contacts to ONE Customer Right!?!

ok i understand this Dim strSource As String strSource = "SELECT City " & _ "FROM Cities " & _ "WHERE State = '" & Me.cboState2 & "' ORDER BY City" Me.cboCities2.RowSource = strSource Me.cboCities2 = vbNullString how ever iwould need it to do this Dim...

ok ill try and word this the best i can this is the last probleam i have, i have a form and on the form is a tab control tabpage one is customer, tabage 2 is contacts for that customer, they are set up in a relationship whey by there can be many contacts for one customer. tabpage2 is a subform...

CHeers that bugger was annoying me for days XD

its a number, not to worry i think i have sorted the probleam its was the relationship i set up i used the wrong join prop DOH, but it seams to be ok now fingers crossed this database is giving me a headache :(

cus im a noob lol, cheers i will give this a go XD

ok im using this code Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[tblCustomer]![ID] = " & Str(Nz(Me![lstCustomer], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark how ever i still cant select 1725 of the records i did notice that in the navigation bar that it...

ive taken a look at the example you have provided it is good and what im looking for how ever there will be about 1500 records in this part of the database and thats a lot to search though even with the search critia enabled, is there no way a list box can safely be used?

will do right now ta for the fast responce