Type: Posts; User: Bobbles
Search took 0.02 seconds.
I am a bit pressed for time, so I cannot quickly find example code for you.
If I were you I would evolve away from using a rs to do your update.
I use ACTION queries instead.
Using those, you can...
I believe your mention of .move etc still implies binding ?
Better if you describe a need you have (not how you will solve it), and we will then describe how to solve it with pure ADO code.
One day you will realize that -
- Use ADO
- Don't use Data Control
- Don't use binding
When that day comes (and it will), yell out, and I will help you use the printer object.
I will sleep easier if you change your naming conventions -
Shirley, there are some of your VB6 programs that will run in W7 ?
Knock up a couple and try it.
If they work, then knock up a couple more that have similar dependencies to your initial 'non...
98% of professionals do NOT use Data Controls,and 90% of them would be using ADO (instead of DAO)
MS does little enough to help VB6 programmers with the latest controls, why make life difficult for...
Is that DAO ?
Why not use ADO ?
Have you tried obtaining a DB created with the older version of Access.
Does that give the same error ?
Knock up a tiny project with the bare minimum to...
DAO and ADO are the way we connect to Data Bases such as Access which comes with MS Office Pro.
Since you are not using them, then the switch to VB6 will be a piece of cake for you.
I purchased my...
The differences between 5 and 6 were really minor, and were improvements/additions rather than changes.
There will be no learning curve to use it.
Your VB5 projects, can be opened in VB6, and then...
Regarding your first point, I am confused, as every version of Windows since W98SE is supposed to have the runtime.
I must confess that I have not tried running one of my programs on W10 yet.
Try keeping the other form visible, BUT move it left or right, so that it is off screen.
I have never distributed the VB6 runtimes, as they are present in every windows since W98SE
The earlier PCs (eg some XP PCs) may only have the runtime for SP5, but I have stuck with SP5 in my...
I use Bang's all the time, just because I love them.
This may not meet every need you have, but are you aware that you can create public Subs and Functions in a .bas file, and pass a reference to the form, etc into the Sub/Function
I would sleep much...
You should not be using -
"data control and visual data manager in VB6"
What you have said there, is incorrect.
Everything is not enlarged.
Only the text is enlarged.
I am old so my memory does not work.
- I think we have disagreed on this in the past (I recall suggesting someone should set it to 9x magnification, and see how well you can program to fix that)...
Add one line to your code -
If rs.State = 1 Then rs.Close
sql = "SELECT * FROM tblHallBook WHERE book_complete='0' AND book_status='1' ORDER BY book_date ASC"
rs.Open sql, cn...
I have not read all the posts (thoroughly), but here is something to consider.
MS have allowed in most versions of windows for the user to change the DPI setting away from normal (make the text...
If that were in our codebank/utilitybank (hint, hint)
I would be one of the first to download it
I agree with DataMiser post 2 (mainly because I don't know any other way to do it)
I have a program, that is set up like Datamiser said.
A couple of users with their own EXE's, and the DB on a...
Thanks for the feedback Elroy
I believe there are two versions of 2013 - purchased(installable), and leased (possibly web based ? ?)
Will it matter which version he gets ?
I have a friend who uses a program I wrote for him, which automates Excel.
I have been begging him to NOT upgrade to 2013, as I am frightened that MS will break backwards compatibility in the 2013...
It does not work fully in XP (not complaining, just remarking)
Color changes are not applied. However I can change the Font to say Arial Black, and make it larger. Can't do much else.
I then ran...
I am 73, and my memory is 100
I was confusing your .frx with the controls .ctx
The ver 3.0 lacked a .ctx, whereas the replacement did have a .ctx which I dropped in with it.
And then my 100...
I noticed that the ver 3.0 did not have a companion .frx There was just s single .ctl file
Thanks for assistance/advice,
IT IS SOLVED I just replaced my isButton.ctl ver 3.0 with isButton.ctl ver 3.7.2
Steve made me re-look at ver 3-7-2 (Even though I had tried it before, I may not have gotten around to retrying it...
It is not a program I sell.
Even though I am Scottish, I never have the heart to charge friends for anything (PC Help, Electronics help, and this program that I have written for a friend). The...
After my main program crashed, I went through a series of experiments to narrow down why it was crashing. I had a gut feeling it was one of my user controls (my main form uses about 5...
I was hoping for a tweak to isButton.ctl, so that I did not have go through the whole project replacing controls.
That would be a massive task, plus many Forms have frames etc floating above them...
I am just about to try your isButton_ver_3-0_New
My big project only has isButton.ctl (there are no other assisting files or classes)
There is no extra subclassing code in my project (no...
PS I am about to image my drive, so will be offline for a couple of hours
$50 AU (via PayPal) to the person that can fix this for me
I had a bash at inserting the code LaVolpe mentioned, but it still crashes (I may not know what I am doing)
The actual version of the...
As I mentioned, I have no experience with UCs, and I have avoided subclassing in my own code, like the plague.
Would this info from the crash dialog, help those (more knowledgeable than myself), to...
There is an excellent User Control (.ctl) at -
It is called -
"isButton 3.6.2 the multi style button"
I have the Oct 2000 version, and I have had to (I thought) live with it set to the entire collection, for over a decade.
I am curious about two things -
- What is the need to detect W7 (just in case any of us have a similar need in the future)
- Why VB5 ?
The changes from VB5 to VB6 were fairly minor (Split/Join,...
Did you do as I suggested in post 2 above -
First place your query into a string variable, and debug.print it before executing it ?
And if you did, Shirley you would have pasted that here as well ?
I could not find the download link (s) on that page
Instead of reading in the test file line by line, you can read it all in in one chunk.
Then use vbcrlf (or whatever) to split the lines into an array (one line in each element of the array).
Click Here to Expand Forum to Full Width
Survey posted by VBForums.