Search results

This is the code that works and filters onto my subforms correctly: Me.NavigationSubformContract.Form.Filter = "[Contract]='" & Me.txtcontractsearch.Value & "' " Me.NavigationSubformContract.Form.FilterOn = True This is the code that doesn't work correctly...

Hi Thanks for your response. This has not worked. I have tried them both separately and together. Any other ideas?

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

I know that this is not the normal way to use a dlookup I know the first part of a dlookup is the field that you want to lookup. The name of the field will be the same as the value in the textbox, hence wanting the textbox value in that part of the dlookup

Thanks for your reply - Its not what I quite meant Its Dlookup("me.text","tbl_Help","[Name]='" & me.name & "' ") where me.text is the textbox but the name of the column heading

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 I have altered those and it still does not work

Hi That is what it is doing It just I want to update the supplier for the order number and the part number in the table

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 Yes I have it makes little to no difference

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

Thanks for your response I thought you would be able to manual edit it - but I am not sure how to do it? Do you have information on how to do this?

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

Brilliant thank you - it always something simple

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