Jump to content

Recommended Posts

Posted

This isn’t so much of a coding question but an “auto it best practice” question. I have a program that runs a query against an access database that pulls numerous fields, name, total time, status etc… I have a GUI that displays these as individual labels so I have lblname1, lbltotaltime1, lblname2, lbltotaltime2 etc… I also have to register each one individually to catch a mouse click command, so the record will get pulled up if the user clicks name, total time or anything else on that row. I did it this way because I needed the columns to line up and I wanted the user to be able to sort with the appropriate field but now that I have to revise this script I am greatly (GREATLY!) regretting this decision.

I originally wanted the entire query to populate just one label that way I only have to worry about populating 1 thing as opposed to 8 (soon to be 10) but I cannot figure out a good way to display these and still have the user sort, and click on a column. The result “box” (ie group of rows and columns) doesn’t have to be anything fancy and could seriously just be black text over a white background but it needs to have clickable column headers. Hopefully there is a pre made UDF or something very obvious that I am missing because I figure my code is literally 3-5 times longer than it needs to be.

Any suggestions on the best way of going about this?

Hopefully this makes sense.

Thanks

Posted

GUICtrlCreateListView

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...