Search results

Hi I am practising splitting my data base read lots of info on the forum but cant find the answer to this. I have split the data base Added a new table to the back end .But do not know how to update it to the front end

Hi mising link How do I get this to run is it linked to an event on the text box

Hi missing link Thats Great I will try now I am trying to learn code is it pos to show how this works If it takes to long dont worry Many thanks

Hi I have a form That takes quite a bit of filling in At the botom there is a field that alows the user to document any Hazards with notes If notes are entered here I would Like to auto populate a field at the top of the form with the Word Hazard In red . Is this possible I am new to...

Thanks very helpfull

Hi Ihave Form called surveys which contains survey info. I want to populate this form with the customers details from the customer details Table . Iam using a combo box to select the customers surname but when clicked it only brings across the surname and no other dtails such as address

Hi just split a practice database to see how to do it .All seems okuntill i decidd to apply passwords The back end works ok But when i open the front end it ask for password which is supplied it opens the front end but when i try to open any form a mesage box pops up saying invalid password ry...

I have a querie that shows a customer name and there order .Is it possible to click on the customer name and display there customer details

Problem solved you were right rural guy Thanks for your help and thanks to everyone else John

THanks will let you know tomorrow

Thanks Rural Guy I will try this tomorrow when I have tw..o computers on the go so I can follow the pictures .Is There something that access does not like about this code

Hi i have had a look at trusted locations seems a bit daunting .Why would this couse my prolem and what folders would i be looking for

Thanks for your help

Hi Thanks for the reply I am new to Access dont know what you mean by trusted locations

I have a form that has a on click event t0 run code to make it inviisible but it will not work .I am using Access 2010 Option Compare Database Option Explicit Private Sub ok_Click() Me.Visible = False DoCmd.OpenQuery "show customers order", acViewNormal, acEdit DoCmd.Close acForm, "show...

Advise please I have a customers list that i am always ading to .I need to run a query to see what individual customers have ordered . I have the query that works great when i manually insert the customers Surname .but i want the combo to do this job .Is it possible ,or should i be doing...

Thanks Paul will it a go

Thanks Paul do you mean i have to take the underscore out

Hi It still does the same .Originally i did not have the colon at the end .but thought that was my error.So put it in .I will take it off but it still puts up the same error

Hi All This is my first try with VBA and it will not work Help Please In my program i have acombo box to select products .The idear is if the product is not in the list the code should put up a message box and ask do you want to add product .If the answer is yes it should open the products...