Search results

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

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

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

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

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

ok im using this code to select a record from a list box so a user can find it faster this works ok how ever after i run a ammend quary on over 1700 records none of them will load (the ammend ones the others are fine) i get a blank msg box, is this due to the code? Private Sub...

good afternoon, i have the following probleam i want to specify a defult location when users click attactments so it opens the add attachment box in a predesigned directory can this be done? and all so i have got some code that opens word with a template how ever can i pass a defult save...

Good afternoon, i shall cut to the chass as they say , my form has a list on it and in the list is a list of companys when a company name is pressed it loads the relevent record fine. how ever i wanted to add a company search box so i put a text box in and called it txtsearch, and added a...