Search results

No, It's autonumber primary key as an integer.

It works with < or > operator but not not showing results with equal sign operator.

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

thanks, both works, but more systematic with short code and proper management of master forms table as described by arnel.

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

if you will see the second image the id has been generated with the dirty code on subform it's working but making it blanks the combo box. So, I am sure, may be a technique is available to handle this issue.

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

The main warehouse summary is not showing in the crosstab query. 1st want to show a complete picture of store including the main warehouses.

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.

Solved: I would like to share the code. Private Sub Form_Unload(Cancel As Integer) Dim DeleteRecord As String If IsNull(Me.frmTransactionsSub!TransactionsDetailPK) Then If MsgBox("You cannot record a blank transaction. Do You want to exit", vbYesNo) = vbYes Then...

Why the code is not responding properly. Private Sub MainWarehouseFK_AfterUpdate() Me!MainWarehouseFK.RowSource = Me.MainWarehouseFK.RowSource Me.Form.Refresh End Sub Private Sub MainWarehouseFK_BeforeUpdate(Cancel As Integer) Dim delrecord As String If Not...

Thanks @theDBguy , how to make code for delete the records.

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

I have expanded like this for the repositioning of columns issue which have solved the repositioning problem. Private Sub Form_Current() With Me CategoryName.ColumnHidden = False CategoryName.ColumnWidth = 3500 CategoryName.ColumnOrder = 1...

I have made as like this which fulfills the requirement. Private Sub Form_Current() With Me CategoryName.ColumnHidden = False CategoryName.ColumnWidth = -2 CategoryNameArabic.ColumnHidden = False CategoryNameArabic.ColumnWidth = -2...

Is it possible to maintain a min and max width of a column?

Thanks @MajP , Thanks @CJ_London I am trying to implement as per my requirement and will let you know.

Thanks CJ, I am talking about after turning off the scrollbar as I resize the column width the scrollbar appers as it goes more than the screen width or form width. Yes, I want to prevent user from hiding or unhiding the columns.

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.