I need to pull some info from a PostgreSQL database into an Excel spreadsheet for reporting purposes. I have created a query that can do it, but I want to create a form that has at least one parameter for the query which is ran when the user clicks a command button.
I am not sure of how to setup the query in VB with the passwords required to access the DB.
Also, does anyone know how to populate a list box from the same database? What I would really like to do is have the form open with a list box full of the parameters right from the database, reducing user error. Then once selected, the main query would run and fill the spreadsheet.
I am not sure of how to setup the query in VB with the passwords required to access the DB.
Also, does anyone know how to populate a list box from the same database? What I would really like to do is have the form open with a list box full of the parameters right from the database, reducing user error. Then once selected, the main query would run and fill the spreadsheet.
