Search results

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

Ah the old NZ im guessing im to use to programing in VB 6 :(

Hello all its me again, quick easy one this time i want to use this code its self explanatory at what it does If Me.Company_Repeat.Value = "Yes" Then Me.lblDelete.Visible = True Else Me.lblDelete.Visible = "false" End If "Company_Repeat" is a yes no box i need to know what...

Hes alright just wants it how he needs it lol

to be honist i did notive it and i designed the database so it had 1 feild but the boss wanted first and last name separate which made life a bit intresting lol.

whats happend is that the old database is a ACT one, ive been asked to replace it with a new one to handel things diffently. so i designed the database and added 200 records by hand to test it making sure the database worked ok, then i had to import the act records over, how ever act only has a...