Search results

Thanks Doc, I am asking about the events which I have used.

I have solved through the following codes, Kindly suggest is this the correct way or suggest the best. thanks Private Sub Form_Current() Me.ItemsFK.RowSource = "SELECT ItemsPK, ItemsListName FROM tblItems ORDER BY ItemsPK;" End Sub Private Sub ItemsFK_GotFocus() Me.ItemsFK.RowSource = "SELECT...

On which event I have to call for inactive items so that it could show the previous records of transactions with main and subform. The screenshot is attached herewith for your info please.

Thanks CJ for your best cooperation and suggestions.

thanks Minty, solved as per the suggestion of CJ.

No, I had changed before, I am talking about the opening of form for data entry in a normal way through dashboard. Private Sub NavigationButton_Receipt_Click() DoCmd.OpenForm "frmTransactionsMain", , , , , , "<=2" End Sub Private Sub NavigationButton_Transfer_Click() DoCmd.OpenForm...

Thanks a lot CJ giving me your precious and valuable time , I have implemented what you have suggested but "Case Is" is not responding. I don't know why.

Kindly see post # 3 of the form code.

I know it works only on Receipt but what about transfers and adjustment because it opens blank record so therefore i have tried in this way.

Not possible to remove RecordSource in frmTransactionsMain. I want to open a specific record as per the document number on the summary form. The screenshot is attached in post #1. Suggest other solution.

Thanks,

Thanks @MarkK, The code of the "frmTransactionsMain" is as under; Private Sub Form_Open(Cancel As Integer) Select Case Me.OpenArgs Case "Receipt" With Me .lblReceipt.Visible = True .lblTransfer.Visible = False...

Thanks @theDBguy , As I am beginner and learner so I don't have any idea how to work through recordset. Anyhow, I am studying how to work through recordset as i will understand how to perform tasks through recordset then i will try again through recordset.

I am trying to open form on a specified record with openargs condition but it is opening the form on 1st record of the form and not opening on the specified record. The code is as under Private Sub DocumentNumber_DblClick(Cancel As Integer) If Me.TranTypePK <= 2 Then DoCmd.OpenForm...

I have solved but I want it in simplest way. Is it any simplest way then let me know. I have applied criteria in query as per the combo box selection in the form. The combo box has been made as a value list. The code is as under SELECT TranTypePK, TranType, ItemsListName, PackingSize...

I have made export through the following code. DoCmd.OutputTo acOutputQuery, "qryListExtended", acFormatXLSX, , True It exports the query data to excel but I want to export data as per the form filtered data. I have also applied expression in query as : [ Forms]![frmListExtended]![CboEntity]...

Thanks @theDBguy, I want to make criteria in query as per the filtered data in the form

I want to export data to excel as per the form view filtered data but it is exporting all data available in the query. On the other hand, I want to export in the same workbook with new worksheets. The screenshots are attached herewith. Kindly suggest.

Thanks a lot Pat, I was also thinking to make it more simpler and I will try to make it more simpler as you have suggested now and will update you. You know I am just a beginner and learner so it takes time to get the results.

T Thanks Minty, I have changed to before Insert event, now it's working.