Search results

Hi All, I do not understand why this is not working. I have a Parent Form that has subforms. On the parent form I have two search fields that represent different forms. The first filter works correctly. However the second does not work and I am getting the run time error. The code is...

Morning All, I'm in the middle of a project and I've hit a bit of a wall. I have created a database which allows me to hold our engineers training requirements, details, and a list of all our jobs on site. I Want to be able to create a appointment calendar which lets me store data on what...

Hi All I am ot sure whether this is possible or not. I want to set the expression of a dlookup to be a text field on the form. This will allow me to be versatile on the form if I can do this. Is this possible Thanks in advance

Hi All I have done this before but having a blank moment. I have constructed this vba sqk statement and it will not work. I believe it is due to the WHERE Clause. Can anyone see any issues with it? UpdateOrderSQL = "UPDATE tbltest " & _ "SET [Supplier]='" &...

Hi All I have a chart that I have created using a query. All works fine, however it does not fill the whole area. Does anyone have ideas on how I can sort this out? Thanks

Hi All I have a form where I want to return the grandparents form name. The code is as below: If Me.Parent.Parent.Name = "frm_Operations" Then 'Operations form Forms!frm_Operations!txtoperationscontract = Me.Contract ElseIf Me.Parent.Parent.Name = "frm_Engineering" Then 'Form...

Hi all I hope you can help I have a chart the needs to show how many products I have sold in a month/year. The problem is that I have 10 products that I look into. Access chart wizard says that I can only have 6 items (this includes the axis information) Does anyone know how I can get...

Hi All I hope you can help me again I have an SQL statement in vba. UpdateKPISQL = "UPDATE tbl_ActuatorMonth " & _ "SET ['" & Me.Text129.Value & "']= '" & Me.Text125.Value & "' " & _ "WHERE [ActuatorYear]='" & Me.Text110.Value & "' And...

Hi All I hope someone can help and see my error I have a dlookup criteria that is to add a value into a choice of products depending on when the delivery of the product is going to be. Me.Text114.Value = DLookup("[Me.Text92.Value]", "tbl_ActuatorMonth", "[ActuatorYear]='" &...

Hi All I hope you can help I have a subreport, when I go to update the report through vba code, it refreshes the form so that it is blank, hence I lose all my data. Has anyone had this occur before in something similar? Thanks in advamce for your help

Hi All I hope you can help I have a form with a subform. I have a button to perform a search. On 2 off my forms the search works great. One one, it is coming up with this run time error. 'The search key was not found in any record' is the description of the error. Can anyone enlightening...

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

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

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

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?

Hi All I have a form, which has a search box. This allows you to search through the id numbers of each record. Once an ID has been selected a bound textbox displays the id number. Other unbound textboxes then display other information from the table with the relavaent record. What I want to...