Warehouse Inventory Project

And we have reached 100 posts :)
 
In a month, I have learnt a lot through this forum and still learning.

The people in this forum: some are very cooperative, some are moody, and some have very odd moods. Any how, In short, you could resolve your issues in a shorter period of time through professionals experts suggestions and advices.
 
how to make a filter on a form as per select the case OpenArgs, In simple terms I want to see only those records which are related to "Receipt" and so on.

on the other hand, i want to stick in the same stack as under

Code:
Select Case Me.OpenArgs
        Case "Receipt"
            With Me
                .lblReceipt.Visible = True
                .lblTransfer.Visible = False
                .lblAdjustment.Visible = False
                .EntityFK.Visible = False
                .EntityFK_Label.Visible = False
                .VendorsFK.Visible = True
                .VendorsFK_Label.Visible = True
                .TranTypeFK.RowSource = "SELECT TranTypePK, TranType from tblTranTypes WHERE TranTypePK<=2"
                .TranTypeFK.ColumnCount = 2
                .TranTypeFK.ColumnWidths = "0;1cm"
                .TranTypeFK.DefaultValue = 1
            End With

kindly suggest
 

Attachments

  • Capture.GIF
    Capture.GIF
    35.9 KB · Views: 116
Last edited:
I see references that you have attached a copy of your database, but I do not see any attachments.
Also, in your related post you mentioned that you had it working.
Can you be specific in what exactly is the status?
And attach a sample database (zip format) with only enough data to highlight any specific issue and instructions to show same..
 
Last edited:
I have three conditions in OpenArgs Case: Receipt, Transfer and Adjustment.

I want to see only those records as per the OpenArgs Case but it's showing all records of other cases.

The database file is attached herewith for your info.
 
I am looking at your database. I see no instructions on the Dashboard.

Can you provide step by step instructions to highlight specific issues?
We're at post #105 and I am not familiar with your set up. Can you take a specific record or "something" and guide me to an issue along with your expectations vs the current issue?
 
Your code does not modify the recordsource of the form, only the rowsources of the comboboxes.
 
example
Code:
     Case "Receipt"
            With Me
                .lblReceipt.Visible = True
                .lblTransfer.Visible = False
                .lblAdjustment.Visible = False
                .EntityFK.Visible = False
                .EntityFK_Label.Visible = False
                .VendorsFK.Visible = True
                .VendorsFK_Label.Visible = True
                .TranTypeFK.RowSource = "SELECT TranTypePK, TranType from tblTranTypes WHERE TranTypePK<=2"
                .TranTypeFK.ColumnCount = 2
                .TranTypeFK.ColumnWidths = "0;1cm"
                .TranTypeFK.DefaultValue = 1
            End With

probably need something like
.Recordsource = "Select * from tblTransactionMain where transTypePK <=2"
 
example
Code:
     Case "Receipt"
            With Me
                .lblReceipt.Visible = True
                .lblTransfer.Visible = False
                .lblAdjustment.Visible = False
                .EntityFK.Visible = False
                .EntityFK_Label.Visible = False
                .VendorsFK.Visible = True
                .VendorsFK_Label.Visible = True
                .TranTypeFK.RowSource = "SELECT TranTypePK, TranType from tblTranTypes WHERE TranTypePK<=2"
                .TranTypeFK.ColumnCount = 2
                .TranTypeFK.ColumnWidths = "0;1cm"
                .TranTypeFK.DefaultValue = 1
            End With

probably need something like
.Recordsource = "Select * from tblTransactionMain where transTypePK <=2"

.Recordsource = "Select * from tblTransactionsMain where TranTypeFK <=2"

Thanks MajP, It has fulfilled my requirement thanks
 
Last edited:
Saving of record with Main and Sub Form:

I want to save record with save button on main form but after finishing data entry on Main and Sub Form.

Kindly suggest possible solutions.
 
Kindly suggest possible solutions.
Use a different platform or create unbound forms.

In a relational database, you CANNOT enter child records before creating a parent record. Therefore, you cannot do this with bound forms.

Don't get the impression that I am recommending unbound forms. I am not. I am suggesting that you rethink the requirement. I'm not reading all the posts in this thread to confirm but I'm pretty sure I explained to you how Access saves records.

Next time, please start a new thread for a new question. The length of this one is unwieldly. No one is going to read it.

If you add another question to this thread, I will lock it.
 
Saving of record with Main and Sub Form:

I want to save record with save button on main form but after finishing data entry on Main and Sub Form.

Kindly suggest possible solutions.
Why would you want to press any button to save a record? Why are you trying to enter a main record and a subrecord at the same time? This sounds all wrong to me.
 

Users who are viewing this thread

Back
Top Bottom