Search results

Hope this will help. The code on the subforms some wont be applicable as I have had to remove some of the tables etc

Hi I think I have attached the pictures correctly. The first picture shows SubformA. This is to be filtered using the fropdown menu. The second print screen shows SubformB which is to be filtered using the textbox. SubformA will update the table, as does SubformB. I have put the relvant...

Thanks for your reply SubformA and subformB have no common fields. so how can I set a filter for the recordset?

Hi All I hope you can help I have a navigation form which has two subforms on it (ie 2 tabs linking to different forms). I have got aq filter working for one of the forms but not on the other. This is using If IsNull(Me.txtoperationscontract) Then MsgBox "Please type a contract number...

Hi The error description is The expersion you entered refers to an object that is closed or doesn't exist. In response to the docmd.setwarnings. I put that in to try and stop the error box occurring because if you press end on the error box it actual applies the filter as I require.

Hi all I am running this code: DoCmd.SetWarnings False Me.makealterationsubform.Form.Filter = "

Hi all I have a form which adds in details of components Sometimes I will need to add a number of components What I would like to do is add a new line of the textboxes below the orginal when a button is pressed. In my head I see it working in a similar visual sense to adding multiple...

Hi all I have this code Me.type01.Value = DLookup("Type", "tblDesign", "[Line]='" & Me.Line01.Value & " AND Contract='" & Me.Contract.Value & "'") contract.value is updated when a button is clicked that has a macro in it Can anyone please tell me where this code is going wrongm and also...

Hi all I know I am doing something wrong and it will be staring me in the face I have a 2 unbound text boxes 1 populates the id number from a table. I want the other to display the first name where this id occurs. I amm currently putting this in the control source of the seconded...

How can I then run the query that I want Could do a sql as have the basis but how would I pull column values into the sql. This is what I have: SELECT Count(*) AS Expr1 FROM tblSummary WHERE (((Year([DeliveryDate]))='2014') AND ((Month([DeliveryDate]))='11'));

Hi All I hope you can help I have a table that displays the year and month and another field that I want to calculate how many id have that month and year from another table can anyone help please

My apologies I have sorted out the query and it is working. How can I apply this into vba? thanks for your help

Hi And what would be the best way in which to do that and then apply it?

Hi all I have a table which specifies the delivery date I have a from that allows you to choose a year and a month. I have an unbound textbox which I wan to display the count I want to be able to count all the records from a table with the year and month specified in the comboboxes and...

This is the code I currently have. It is not allowing me to update the second column. When I tae this line out it works how it is supposed to Dim ContractSQl As String ContractSQl = "UPDATE tblContracts " & _ "SET Order='" & Me.conOrder.Value & "' " & _...

Hi One record that is specified in another column

Hi all I have an sql which is used to update a table I am wanting to update the column1 with the value of an unbound texbox on a form can anyone help?

Also I have looked through the link you posted about update queries, how would I put this into a vba code?

No I am unable to load the data that matches the id number. then I want to alter the unbound textboes that have found data from the table and update it

Thanks for the reply. The reason why not is because I want the user to click a button to save the information, also I want this form to update other fields in other tables eventually