Recent content by sammy204

wow thankyou that works brilliantly. Really appreciate your help Thanks Again :D

The original value on form1 comes from a combo box which shows the records on form2. It might sound odd but I think it needs to be this way because of some of the things I am doing with the form. E.g. there are 3 buttons on form 1, one for new orders, one for current orders and one for prebooked...

Hi Yes I am passing the value from form1 to form2 using openargs Form1 has a button which on the click event runs something like docmd.openform "form2",,,,,,me.text2.value How do I use the filter then? To show only the record where one field has the value of me.text2.value ? It is not the...

Hi Thanks for the reply but I dont know anything about filters to be honest. How should I set the record with a filter? Would this go with the docmd.openform part on the first form? or in the onload part of the second? How do I set up the filter? Thanks

Hi I have a form with a button which opens and passes a value to a second form. The second forms on load event says put that value in combo box 2. Combobox2 when an item is selected will find that record on the form. However because I havent selected it myself, only told access to put the...

Hi thanks for the help I will try that a bit later when I get a chance. However I want to go to a record, then see if that the data in that record = ordering. The textbox1 is a control for one of the fields in a table so I need to go to each record, see if it is ordering, and if it is colour a...

Hi, I put this under the wring topic thing before so I will put it here. I have 10 text boxes and instead of writing the same code for each one 10 times, I wondered if i can run the same code on each one with a for statement. Each textbox has the same code run on it. The code currently is...

Hi about the not sure what code Im running, I thought the person was asking the like type of vb code because he asked what kind is it. So I thought maybe theres different types of visual basic. And it was in the form load because its a form with some coloured labels representing the different...

Hi Thanks but I use the number of the textbox more than once. The code is: DoCmd.GoToRecord , , acGoTo, 1 If Me.textbox1.Value = "Ordering" Then Me.label1.BackColor = vbGreen Else Me.label1.BackColor = vbBlue End If and the same for textbox 2 except all the 1s are now changed to 2s thats why...

Hi thanks guys that works perfectly now. Sorry I don't know what VB Code I'm running, only that it is Microsoft visual basic which runs with Microsoft access 2007. Thats the first problem solved, just one more: I have 10 text boxes and instead of writing the same code for each one 10 times, I...

Hi Thanks but I dont think it works The code i want to run is on the first form. I want to be able to close the second form and run this code from the second form. This is in Access 07 by the way. So where should I put the call form_load code? Thanks

Hi, I have 2 forms On the 1st form I have a form_load event running some vb code on the 2nd form I want to be able to close the form and rerun that vb code. I know the code to close the 2nd form, but not to refresh the load event on 1st form. By the way I want the 1st form to remain open the...

Hi I want to make Access automatically merge two fields together to create another field. E.g. I want the First Name (first letter of it) and the surname to be merged together in a form and placed in a new text box or other field. So if the name was David Wild, the result would be DWild. I...

Ok dont worry I managed to do that using the criteria IS NULL and using the original tables table, and the query of current bookings. Now: My query has a parameter where the user can type in a date and time. This is put as a combo box, so when they click the box the paramter runs and they type...

Hi how can I integrate the queries? 1st query is all the tables which are booked for that day or time etc now I need to query this with all the tables available and show the ones which are not booked? How can I do this second part? Many Thanks for your help