Search:
Type: Posts; User: RobCrombie
Search:
Search took 0.15 seconds; generated 50 minute(s) ago.
-
Declare a variable sSQL
Build your 'query' into that.
Then do a Debug.Print prior to executing the Insert.
And post it here.
You will probably see the error before posting it here.
You may be...
-
Thanks guys,
There were a few problems in my code, caused by the changes he had made to the server name, and there were access rights problems (he had not set the same rights in the new server, as...
-
Hi,
My question relates to the 'address' that can be used to find a central databse that is stored on a server.
I have never owned a server, so I am very ignorant in that area.
I have a vb6...
-
Both questions are now resolved
Thank you for quick and informed response.
Rob
-
I am automating Excel from a VB6 program.
I am writing the Column Headers into Row1
I have managed to color them Grey (Would be nice if I could color the whole line, instead of the 10 Columns I...
-
Safe way to use a background image in an email
I am attempting to create an 'email merge'.
(There are not many Google hits on that expression)
User would like the email to be HTML (not plain...
-
Hi,
I suspect that this is in the wrong thread ?
Is there a way that it can be moved to -
Other Languages
XML, HTML, Javascript, Web and CSS
Or can I just post it there, and Delete this ?
-
I HAVE 'MOVED' THIS TO THE 'OTHER LANGUAGES FORUM
(Don't know how to Move properly, so i have posted it there, and added a 'fall back' request -'How to safely use background image from attachment'...
-
It would be nice if it was a VB6 User Control (Nothing has to be registered).
From my quick look, it -
- does not appear to be UC
- requires registering the DLL
- Only for VB.NET
Ah, such...
-
ididntdoit
I tried creating 'your' IP thingy, but the site kept saying my signature was taken.
I instead copied the source from this web page.
Did you know that you can insert the HTML into an...
-
I was just updating my original post (see Edit on the end of post 1)
I will check out your suggestion
Any thoughts on how I can do the LT and GT with my number fields ?
Thanks for...
-
I have an existing application (DB has production data).
I have a need to add more fields, and wonder if I could avoid the hassle of getting the DB's sent to me.(There are DBs for each state, with...
-
I think it was unkind of MS, not to have provided more examples(etc), to make printing easier in pure VB. I guess they were providing openings for 3rd party providers to 'fill the gap'.
I have tried...
-
With my approach (and Hacks), no changes need to be done to the printing code.
The generic code just 'reads' what is now on the form, and can print it.
I have a form that is full of tightly...
-
Does your print out fit on a single page of paper ?
If it does then -
It is possible to print something like that with pure VB code (No OCXs, no DLLs, no distribution/Installation problems)
...
-
Ctrl G to show or hide it
If you break your program (still running, but paused), you can show the contents of variables with
? NameOfVaraible
and press enter
There is a lot more that can be...
-
There is a command to Comment and UnComment a block of code.
You highlight the multiple lines, and click Comment Block.
If you right click the Toolbar and choose customise you can add two button to...
-
I have never used Project groups, as I like to keep things simple.
Are you saying it all compiles into a single exe ?
If so why not have it all in a single project ?
Regarding your specific...
-
Can you not capture the screen another (free) way ?
-
Why do you need to use Project group ?
-
-
I agree.
I doubt that any experienced programmer, would be using any of the following -
- Data Environment
- Data Control
- Bound Controls
-
That's a good thought.
I have an approach that avoida that problem.
I have been using it for so long, that I forgot that others could still have those problems.
Every time I wish to run my...
-
In the IDE the last thing I see in the process is the message (Status)
'Writing the exe'
Do you get that message ?
To help narrow down the problem -
Can you go to your most recent copy...
-
If you mean the real Control (not my txtTakeFocus), the programmer can add code to it's GotFocus event to set focus to txtTakeFocus
-
I agree.
It will depend on the programmer's needs, on different Forms.
On some you may not wish any control getting focus.
On others you could set the TabStop for txtTakeFocus to False, which...
-
Ensure that the button's TabStop is False.
Have a small textbox called txtTakeFocus
Position it off screen minus 900 (either in the IDE or on form_Load)
Then depending on your needs, you can...
-
If my memory serves me correctly, I recall that in 'Data Modelling', the Primary Key is not really meant to represent meaningful real data.
There will be cases where it can be displayed and referred...
-
Try setting Redraw to false (or Visible to false), whilst drawing/loading the grid, and see if that helps.
If it doesn't, do a search in this group for SGrid
(Actually it is for SGrid 2), but do...
-
If you have a similar need later -
What I do is declare it as a string, and in the startup code
(eg Main in a bas file if you use them, or in the Form_Load of the first form),
just set the...
-
place a break on that line, and each time it gets to it, hold the mouse over skey.
My guess is that in one of the 'reads' it is returning "" and you cannot CInt that.
It is better to return the...
-
I nearly had an example for you, however I am having trouble providing events for each checkbox.
That example was creating controls 'out of thin air'
The other approach is to just add to an...
-
I noticed last night in one of Rod Stephens VBHelper newsletters, that it has a 12 month expiry.
I don't intend to use VB.NET but I have a couple of times tried to work out how it could be Free ...
-
PS
It is 3:30 AM in Australia, so don't think I am ignoring any responses during the next 8 hours.
-
Let me whet your appetite(s)
This is a snapshot of HiRes running.
The Form is on the left, showing a variety of controls.
On the right is the print of that Form
It has printed onto the preview...
-
I found that other example -
http://www.xtremevbtalk.com/showthread.php?t=217998
It illustrates how the VB code can 'scan' (interpret) other controls on the form you wish to print.
That example...
-
I had tried in the past to get something going on this site for native VB printing, but no luck.
Do all of the pages only require single page prints ? (They don't flow on to another page because a...
-
If you show Form2 vbModal, then no other form in your project can be interacted with, until you unload Form2
Form2.Show vbModal
'When Form2 is unloaded, code execution will return to here
...
-
I did find that in my search, but I thought there was a more text related post.
I am old (100/2 + 15), so I could be imagining things.
I have just provided the solution into the thread you...
-
Hi,
I am not sure this is the thread that I was trying to remember in my post -
http://www.vbforums.com/showthread.php?p=2910573#post2910573
But I will post a link to my text solution -...
|
Click Here to Expand Forum to Full Width
|