search records (1 Viewer)

mikekal

Member
Local time
Today, 01:02
Joined
Jun 24, 2017
Messages
114
What I do wrong in the code and it does not make me search
 

Attachments

  • Desktop Inventory (2).zip
    4.2 MB · Views: 99

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:02
Joined
May 7, 2009
Messages
19,246
i added code to Module1 for the Start of the Week (sunday).
see Filter table for the modified "filter code".
 

Attachments

  • Desktop Inventory (2).zip
    3.8 MB · Views: 71

mikekal

Member
Local time
Today, 01:02
Joined
Jun 24, 2017
Messages
114
When im filtering with combo box do nothing.Why
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:02
Joined
May 7, 2009
Messages
19,246
only "This Week's Addition" has records.
today is 26-april, you don't have recorded data
for today's date so "Today's Transaction" will not show anything.
 

mikekal

Member
Local time
Today, 01:02
Joined
Jun 24, 2017
Messages
114
I want to search only if i want for product or for Transaction type or for date or all together
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:02
Joined
May 7, 2009
Messages
19,246
which Form are we talking here. I am referring to "Inventory Transactions List" form.
 

mikekal

Member
Local time
Today, 01:02
Joined
Jun 24, 2017
Messages
114
Im sorry im not tell you the form.I want filtering in form1
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:02
Joined
May 7, 2009
Messages
19,246
see the code (filtering) of form Form1.
 

Attachments

  • Desktop Inventory (2).zip
    4.2 MB · Views: 50

mikekal

Member
Local time
Today, 01:02
Joined
Jun 24, 2017
Messages
114
Is it right.I mean is it without problems.The code from old database
 

mikekal

Member
Local time
Today, 01:02
Joined
Jun 24, 2017
Messages
114
Because when im searching for a product,returns nothing
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:02
Joined
May 7, 2009
Messages
19,246
the code has problem (i commented them out).
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:02
Joined
May 7, 2009
Messages
19,246
see the file on post #8, it has already been fixed.
or use this one (i cannot open the Original form1, so i copy it to new db).
 

Attachments

  • new.accdb
    5.7 MB · Views: 69

mikekal

Member
Local time
Today, 01:02
Joined
Jun 24, 2017
Messages
114
Thank you very much.Its working fine.Thank you
 

mikekal

Member
Local time
Today, 01:02
Joined
Jun 24, 2017
Messages
114
I have another question.How can delete ticked records from combobox selection "delete"
 

Attachments

  • Desktop Inventory (3).zip
    4.3 MB · Views: 70

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:02
Joined
May 7, 2009
Messages
19,246
here try and test.
see the code on cmdDelete button.
 

Attachments

  • Desktop Inventory (3).zip
    3.3 MB · Views: 60

Users who are viewing this thread

Top Bottom