Recent content by cybertyk

oh dont worry i fixed it XD

ok i have a datasheet and on the datasheet is the company name, when i click the company name a form loads with the detials of the company Private Sub Company_Name_Click() DoCmd.OpenForm "frmCustomerDetails", , , "[ID]=" & Me.ID End Sub is the code i use to run this, how ever after i alter the...

ok that worked but now when i use the full code i get another syntex error can anyone see why i need some fresh eyes strsql = "SELECT tblCustomer.[Company Name], tblCustomer.[Company City], tblCustomer.[Company County], tblCustomer.[Company Postcode], tblCustomer.[Company Catagory]...

ok i have got this so far strsql = "SELECT tblCustomer.[Company Name], tblCustomer.[Company City], tblCustomer.[Company County], tblCustomer.[Company Postcode], tblCustomer.[Company Catagory], tblCustomer.[Company Employee Size] FROM tblCustomer WHERE (tblCustomer.[Company Name])= Like *" &...

ok i have 6 text boxes which for thi example i have named text1 - text6 will this code work if i want to change a record source of a lstbox? strsql = "SELECT tblCustomer.[Company Name], tblCustomer.[Company City], tblCustomer.[Company County], tblCustomer.[Company Postcode]...

Me.Company_Next_Contact_Date.Value = DateAdd("m", 3, Date) was the anwser, ok next question. when the forms load they always load stupid sizes so i have to click the form to size buttion is there a way to force this on oading of the form?

how would i go about string = date() + 3months ?

Cheers thanks ever so much

ok got all that working but i just had a brainstorm or its a migrain im not sure, in the critira of a quary can you do something like is null then "Dear Sir / Madam"??

no that code you gave me work perfect thank you for that i supose i can create a copy of the form and then set the record that way i was just tying to keep the number of forms to a min i will just create a copy of the main form and change the record source :) thank you for your help and...

right, ok im with you i could take that approce lets say that i created anew record source the following! SELECT tblCustomer.ID, tblCustomer.[Company Name], tblCustomer.[Company Address 1], tblCustomer.[Company Address 2], tblCustomer.[Company Address 3], tblCustomer.[Company City]...

Ha its sorted this works perfecccct Me.lblDND.Visible = (Nz(Me.Company_Repeat.Value, 0) = -1) Me.imgFlag.Visible = (Nz(Me.Company_Flag.Value, 0) = -1)

ok erm i tryed that code and the lbl and img are always visable when there propities are set to false :S even with the nrecent code verations you sent me. and the other one is, can you select a record from a quary and open it in a form (basicly lol)

thank you kind sir you have been a great help to me over the past few weeks i do have another question about a query i have written then query works a treat how ever is it possable to select one of the rows to load the record source?

ok that works but there is a slight probleam the code is Me.lblDND.Visible = (Nz(Me.Company_Repeat.Value, No) = Yes) Me.imgFlag.Visible = (Nz(Me.Company_Flag.Value, No) = Yes) its making them all flaged and do not disturb unless i tick the box would i need to change it to the following...