Search results

Does anyone have any idea on how to export this?

Thank you all. Eugene, The me.Name worked perfectly. On to the next conundrum!

Sorry I haven't responded, I got waylaid with other parts of the db! So, here is a screenshot of the selection form. When I click on Select Orders, it takes me to the next form where display my filtered records. By using the following code, I populate the StatusSearch field which is picked up...

Sorry I'm obviously being very obtuse tonight. In Form 1, I have the following code: Private Sub AddNewItemBtn_Click() Dim CustomerInputID As Variant CustomerInputID = Me.CustomerID DoCmd.OpenForm "NewStockItemF", , , , acFormAdd, , CustomerInputID End Sub In FormA - New...

Thanks Eugene-LS but I don't see how that passes the form name through. On Form1, when I click on a button, it opens FormA. When I am in FormA, I have some code that says: IF coming from Form1 THEN Do something ELSE Do something different END IF The Tag doesn't pass between the two...

A bit more research for me then as I haven't used Tag or TempVars

Hi, I call a FormA from several forms - e.g. Form1, Form2 and Form3. I want to code some processing in FormA dependant upon which form has called FormA. Is the only way to get the calling formname by passing it in OpenArgs? If I already pass an OpenArg, do I have to concatenate a string...

The problem is still that I need this to work in a query as I am using this query to export to excel.

I get how this would be useful in writing sql but, in this case I am hoping just to pass the field to the query. As soon as I set the field in the variable, it stops working.

Hi, I have a Status field that can contain the numbers 1 - 5 which relate to various statuses. I have a form with check boxes that allows users to select one or more of these statuses. However I can't work out how to word the criteria in the query. I am creating a StatusSearch field in my code...

OK, I've got the report sussed by setting If statements at the correct place: Private Sub ReportType_Click() Dim OrderID As Integer OrderID = Me.ID If IsNull(ReportType) Then Exit Sub If ReportType = "OrdersR" Then If IsNull(Me.SearchField) Then...

Will do - what are code tags? I realise that I have to make sure about closing the form.

So, my search field is fairly broad as follows: Code Tags Added by UG Please use Code Tags when posting VBA Code Please read this for further information:- https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/ Please feel free to Remove this...

Hi, I have a form which lists orders. I have a Search button which filters the orders in the list. How can I then print these filtered lines? Do I have to create a report and pass the filter as typed in by the user to it? Is there an easier way to do this? Thanks Debra

Solved this by adding a query update in the Close statement

Sure. So I actually had two events - one if they hit the Save button and there were no lines is the order and a Cancel button. The Save event is: Private Sub SaveBtn_Click() Dim POIDInput As Variant Dim OrderLinesCount As Integer Dim Response As Integer Dim query As String...

There are other statuses that are only allocated at OrderHeaderT level (Invoiced and Paid). Will I have to do an sql update to update the OrderHeaderT record? Allocating the data to a bound field on closing the form gives me an error message 'You can't assign a value to this object'. Private...

Thanks. I have done this by deleting the header records if there are no line items. Thanks for your help.

So I've got it to display the correct data on the Main Form. However, what I really want to do is change the value of the field (OrderHeaderT.StatusID) with this passed data.

OK, so I've worked out the logic - how do I get the main form to reprocess a field once something in the subform has changed? Is it a case of re-querying the form?