Search results

Hi I have a split database I have just created anew table in the back end and created a relationship to an existing table .All done in the backend I have opened up my front end and imported the back end end .But when i check the relationships in front end niether the table or link is there...

Hi I have a continuous form based on a orders table and a details sub form I list all the records in a continuos form in date of order i need to change the colour of a single record based on the condition of a tick box on the original orders form

Hi Im new to access programming.Is it possible to store a variable in one form and then retreive it to auto fill a field on another form . I know hot to Dim and store on the same form but trying to retreive from another form i cant do . I presume the seconf form would be something like this...

Hi cant get my head round this one .I have a continuous form to show all my customers,I have a button that Iclick which auto brings up my main customer form (code supplied by p baldy )That all works great . On my main customer form i have varius buttons which open other forms ,I then have a...

Is there a proper access calender so that events can be entered ect

Thanks for your help but i dont want to use subforms surely there must be some code to do this

I have a continuous Form for my customers,when i click thecustomers Id I am taken to the customers full form ,from that form I can access four other forms .I have a combo on each of these forms to select my customer . I need to automate this so that when i open up one of these four forms it...

Help I can no longer alter my forms in design view when I save them nothing happens i have to press no and then access shuts down .Ihave a feeling this is something to do with the VBA editor that i have been playing with ,but dont understand VBA .It is not all forms .I have a split Data Base

Paul should i change the form name and leave out the space

Hi Paul Cant do that the database has lots of sensitive info

Hi Paul No it didnt THis is the code DoCmd.OpenForm "[customer details]", , , "IDCustomer = " & Me.IDCustomer I checked the name in the data sheet and it was diffrent label 22 so i changed it to customer details but it still brings up the same error

Thank you Paul John

Hi Paul Thanks for your continuing help I will try again would those brackets be square or Normal John

Hi paul I have tried the code but it will not work .This is my code Private Sub IDCustomer_DblClick(Cancel As Integer) DoCmd.OpenForm "customer details", , , "IDCustomer = '" & Me.IDCustomer & "'" End Sub I am in my contiuous form named customer details2 I have attached the event to the...

Thanks Paul will try

Hi Paul Thanks for getting back to me Im not shure if your answer is what i want Basically from my contiuous form i want to be able to select a customers record by dble clicking it and open up there full customer details record I am new to vba i find it very difficult to use the editor...

Hi I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form

Hi Plog thanks for your help think iv got it John

Thanks for your time much appreciated John

Hi plog Thanks for getting back Yes all my existing tables have arrows showing the links but the new table in the back end isnt there .CAN YOU EXPLAIN HOW TO ADD THE LINK MANY THANKS