Search results

I am trying to filter data as per the dates selected in form and the data is based from crosstab query I have attached the db file kindly suggest. thanks

How to make the monthly sequence sorting order in crosstab query. I have attached the screen shots of the query. The criteria which have been used for the query is as under; TRANSFORM Sum(Stock_In_Out) AS SumOfStock_In_Out SELECT ItemsPK, ItemsListName FROM qryTransactionsExtended WHERE...

I am making a stock summary in crosstab query. The criteria is as under; 1. Current Stock should have to be the net present stock, i.e, (Opening+Purchases-Transfers) 2. Branches stock should have to be only current month transfers. how to get this. db file is attached herewith. kindly suggest

I want to make datasheet form or List box but the columns should have to be shown in datasheet form or List box dynamically as per the availability of data in cross tab query. suggest please.

My datasheet form check box selection is working normal before filter of data but as I filter data through cascading combo boxes the datasheet check box is not making multiple selections. kindly suggest the solution. The db file is attached herewith.

I have a datasheet form with all fields are locked and enabled field property false except one check field. I want the selection of row should have to work as enabled property false. screen shot is attached herewith. kindly suggest.

I have data entry form with main and subform i.e, subform is continuous form. I have made a button on main form i.e, add multiple items, when the user will click on it, it will pop up another continuous form with the following fields, 1. Check field 2. Items Name 3. Packing Size I want to add...

Is it possible to adjust columns size in reports view?

I am making search form as under 1. added text box named @ txtSearch 2. added find button named @ btnSearch 3. added list box named @Searchlistbox1 I am using the following code to show record in the list box as per the text box. Private Sub btnSearch_Click() Dim sql As String sql =...

I am using two list boxes. On click in listbox1 value the data is shown in listbox2 as per the selection in listbox1. on double click in listbox2, as per the selection the specific record should have to open. Private Sub DynamicList1_DblClick(Cancel As Integer) DoCmd.OpenForm...

I have an option group as under Frame1: Received Returned to supplier Stock Transfer Transfer Return Expired / Damaged Inventory Adjustments with values 1 to 6, I have three case statements working as under as an open args Receipt Transfer Adjustments =============== I want one line code...

I am trying to show results in a list box as per the selection in the list box. for example: List Box 1: Current Stock Received Stock Transferred Stock List Box 2: List box 2 should have to show results as per the selection. I have attached the screenshots. How to get the solution...

I am trying to open different forms as per the selection in the list box. I have tried this which opens the same form on double click. DoCmd.OpenForm "frmItemsDetail", acNormal, , "[MasterTablesPK] =1 " & Me.DynamicList.Column(0) I want to open different forms as per the selection. for...

I am trying to fill main form as data is entered in subform but i am getting error I have applied code in the subform on dirty event as under. Private Sub Form_Dirty(Cancel As Integer) With Me.Parent If IsNull(!RefPK) Then If Me.Parent.lblReference.Caption = "Receipt"...

I want to make stock summary query as per the attached sample jpg.file. The stock summary should have to show crosstab query as per the table entities. I have also attached the database. Kindly suggest. thanks

Is it possible to change columns widths in reports dynamically as like in excel. i.e Dragging the columns widths as per the requirements.

I am trying to delete the records in subform if the user changes mainwarehouse selection on mainform. The code is as under Private Sub MainwarehouseFK_AfterUpdate() If Not IsNull (Me.frmTransactionsSub!TransactionsDetailPK) then MsgBox "Change of warehouse will clear the items, Are you...

1. I am trying to avoid horizontal scroll bar in datasheet form even though increasing columns widths, It shouldn't go beyond the form view. 2. On the other hand, the user should not be able to make zero width adjustment of any column during resizing of the columns. Kindly suggest the ways.

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.

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