×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

(OP)
Hello

Sincere regards to you all

Sincere regards to you all. I am a fresher in VBA coding but very much in love with the challenges involved in coming up with a presentable Excel VBA application.

Am trying to construct a Stock and Sales Management System for my business using Excel VBA code and in this regard am seeking for enlightened assistance in dealing with some challenges at hand. I have attached my workbook named STOCK SYSTEM 3.xlms. Please take a look at User form 7. This is a basic Sales Search Form through which I intend to search for individual item receipts, view individual cashier sales based on a start and end date, individual item sales and specific transaction sales whether Retail or Wholesale. For starters the form seems to partially work but despite ceaseless coding changes I am totally confused in figuring out why when I try to filter by start and end date of a specific cashier it is displaying an entire unfiltered list. Second is the clearing or refreshing the battery of text boxes and the List box (List box 1) itself after conducting a search using Command button 6 (Clear Results). It seems to work the first time clearing all contents but also the headers and after that all attempts to clear the text boxes and list box are met with errors. Why is this so? No three can anyone please guide me in constructing a smooth synchronized code that will print (Command button 7) the filtered results in a List box
Will appreciate any available and willing assistance provided.

Cheers
DEBLACKJACKAL

RE: HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

Hi DEBLACKJACKAL and welcome to Tek-Tips.

I hate to say this but are you sure Excel is the right tool to create a system like this? I assume you have looked at off-the-shelf solutions that might cost more but save dollars in the long term? Being an Access developer I would think a database would be better.

If you don't get useful replies, you might try to break your questions into three separate threads.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

(OP)
Hello Dhookom

My hopes that you are fine.

Do appreciate your recommendations.Am based in Kenya. Did do a research of the off the shelf solutions and they are indeed expensive. Further the available solutions require an annual renewal subscription fee. Most of the financial data at business is Excel based that's why I have opted for Excel VBA.

Cheers and Regards from this end of the global map.

DEBLACKJACKAL

RE: HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

If that is the case then I would suggest you break down your question into smaller bites with adequate information. I am far from an Excel expert and can't afford the time to figure out how to answer your issues. I hope someone else can provide solutions.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

(OP)
Do appreciate your views. Thanks all the same.

RE: HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

Many of us are unwilling to download random files, especially macro enabled ones.

Your requirements all seem achievable with Pivot Tables. No VBA required.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close