i dont see anything wrong with your sql query but i'm not really familiar with ado. but basically here's how would do things:
dim db as database
dim rst as recordset
set db = opendatabase("your_db_here")
set rst = db.openrecordset ("select * from Products where productname like...
when i attempted to do this, i just changed my font to courier new, wherein all characters take up the same amount of space, then i defined a fixed length for each column.
so if you want per column to have a length of 10
cmboMe = dta1 & space(10 - len(dta1)) & dta2 & space(10 - len(dta2)) &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.