Search results

Thanks guys sorry about the code Your help was just what I needed to get it going properly

I have created the temp table from a query, the records in the table are what I want, but when I go to the Set db = CurrentDb I get a data Run Time error 13 Type Mismatch error. I have checked the names of the fields and their type on the query against the temp table and they are fine. Dim...

I am trying to read in a query file so I can do some work on each record (different work for each trans type) but I can't get to that point at the moment because I keep getting the above error. I have checked all the fields in the query and they are the same name as on the table. The query that...

Thanks for all of your input guys. This is the solution, works for all transaction that fall into the variable values. >=[Forms]![AddDdScheduleFrm]![FirstDateFld] And <=[Forms]![AddDdScheduleFrm]![LastDateFld] The SQL is WHERE (((DdSchedDDTrans.TransCode)<>40) AND...

I have used the following in the criteria of the field I'm checking Between [Forms]![AddDdScheduleFrm]![FirstDateFld] And [Forms]![AddDdScheduleFrm]![EndDateFld] I'm testing this away from the form so it prompts me for the date values I don't get any results. Am I using the right syntax I...

I want to calculate interest on a daily bases for a week, fortnight or monthly period. I have a lot of schedules that need their interest updated. I can write some code to check the frequency and do the calculation for 7, 14 or 30.5 days. But how do I trigger that for a schedule that hasn't been...

I have a problem with one form, when I go into it everything works until I try to Exit out or Save and Close or any other On-Click event. My only way to get out is to right click the top border and Save and then Close I haven't been able to find out why this is happening Any suggestions

You were right Microm, The parent form had the same code, I deleted that and all is OK Thanks guys I love this forum:)

I have a delete button on each continuous line that deletes the line when required. My problem is that when I click on any of the fields in the line the action button activates. I have a message box come up asking to confirm that you want the record deleted. respond with NO and it goes away. It...

I have a subform (Continuous) and the last entry on each detail line is my delete button. When the form is open if I click on any of the eight columns across the form it fires the code for my delete button. Only the first click not any subsequent click. I only want delete a record when the...

The continuous is not working. Subform1 has HelpIndexSubform Source Object - HelpIndexSubform Link Master Fields - SubCategory Link Child Fields - SubCategory HelpIndexSubform Record Source - HelpFileIndexQry Record Set Type - Dynaset Default View -...

I want to include a variable date in my query WHERE condition. Not sure of the right syntax

It's OK now. It was 'all Records' locked. Thanks for everything (y) :)

Thanks pbaldy I changed the code to Private Sub tbFilterOrderNumber_AfterUpdate() Dim strNewRecord As String strNewRecord = "SELECT * FROM Orders " _ & " WHERE OrderNumber = " & Me.tbFilterOrderNumber.Text Forms.OrdersFrm.Form.RecordSource = strNewRecord End Sub and got the same result

I have a Parent Form (Orders) and a sub form (OrdersSubform) The parent displays details of the Order and the subform displays details about the relative Items on that order. That's all fine. I want to create a number of search options The first one is to change the parent order. I currently...

Thank you everyone. It was the height of the subform control. So simple but thanks Bob Fitz (y) :) Great being part of this forum Thank you again

A have a parent form and a subform within it. It working as I want. I can flick through the Orders on the Parent form and the Order Items show up in the subform. But only a max of two records show up on the subform and I know that there are a couple of forms have 9+ Order items for an Order. I...

Thanks every one for your input. moke123 made me think about the state of the file. I closed the form down with save and then performed what I needed to and it works fine now Thanks again guys:)(y)

Yes the environment is a multi-user server system. I'm using my development version of the production database and I'm the only user. Just to reiterate - The process here is to be able to bulk move documents between folders in the clients Document Library. The first part of the process is to...

A single file case. Yes verified that if I go back in and run it again the last one is changed. Regards