ok....that makes more sense.....I just have a mapped drive to all my development work.....then I can just select the drive from the drop down....no biggy.
Wasn't this your question.....How to set File Dialog Init Dir (not in code)????
Maybe just right click on the CommonDialog and select properties.....you can set it in there. :-)
...There are so many ways to sort data by a field
'''''''''''''''''''''''''''''''''''''''''
Dim sSQL as String
'Ascending
sSQL = "SELECT * FROM YOUR_TABLE ORDER BY YOUR_FIELD"
'Descending
sSQL = "SELECT * FROM YOUR_TABLE ORDER BY YOUR_FIELD DESC"...
never have had to do it.......I have never even seen this done and I have worked on allot of macola sites in the past.
Just seems silly to search by qty and loc.
Good Luck
why on the search screen though. This data is present once you select an item from the search? Im confused.....how does someone search by qty?
Just a word of advice with macola....keep it simple....or be prepared for the worse. :-)
you could always use the recordset and excel object library.
First read the data in....then create the spreadsheet from the recordset.
I would do a search for Visual Basic Excel either here or on google.
lol......thats what we would call a bonus (a mess up)......glad you got it fixed.
Anyways....if anyone else want the hack let me know.
Andy....you'll be gettin it soon.....my email is down for maintence right now.
I don't know for sure....I have never had the problem with this before.
I would try the hack to see if that does anything first.
I just sent it.
Let me know how it goes.
good call.....I never noticed that in OE. :)
Looks like the combo is the way to go.
But this is a good option too...less errors.....less macola flex mess ups too.
You can add your own checkbox......you would have to use Flex though to populate the User_def_fld_X with the data.
In design mode just right click on the screen and Add Special.......that will get you a checkbox.
But I think an easier way would probably be to unhide a user_def_fld_X.....and...
There is a reg. hack to get ADO to work in Flex.....actually I think its more of a license thing.....but if you post your email I can email you the reg. hack.
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.