Type: Posts; User: Bezzie
Search took 0.01 seconds.
July 17th, 2009, 02:56 AM
Using VB6, MS Access 2000 mbd and Crystal Reports 8.
I set the database for the report with
Report.Datafiles(0) = App.Path & "\Database.mbd"
Now I want to move my reports into their own...
July 13th, 2009, 04:59 PM
Thanks guys. I'll look into Inno first and see if I can get it to do what I want.
July 13th, 2009, 12:52 PM
What would you suggest I use to update some outdated files on users computers? Some of the files I need to update are dll files (system32) and some datafiles (program directory). Some of the dll...
June 28th, 2009, 10:41 AM
Thanks. I'll look into it and see if I can get it figured out.
June 23rd, 2009, 02:36 AM
Is there a way to build a HTML string then?
June 18th, 2009, 04:03 PM
If I use Clipboard.SetText Richtextbox1.SelRTF, vbCFRTF and try to paste into the email, nothing gets pasted. Leaving out the vbCFRTF gets the string pasted with all the RTF codes as below:
June 13th, 2009, 03:47 AM
I can get the text formatted in the RTB programmatically. The text in the RTB looks like this after I formatted it:
When sending it to the clipboard with:
June 11th, 2009, 04:12 PM
Most of the information in the string I'm building comes from databases. I then copy the string to the clipboard so I can paste it in the email. Currently I then format the text in the email to show...
I build up a text string in VB and then I want to send it to the Clipboard so that I can paste it in the body of an email. How do I go about to format (e.g. bold, underline and colored text) that...
It gets weirder still. If Dim TotVal As Currency is changed to Dim TotVal As Double it does return 32 as expected!
Sorry, missed it in the first post, you have seen the double already.
Not to worry. For some obscure reason I was thinking I used MySQL. I'm using MS Jet SQL and not MySQL. I see that MS Jet SQL is severely limited in it's database structure manipulation so the...
It seems? Access tables doesn't support the ALTER TABLE ... CHANGE COLUMN command.
Found a workaround, sort of.
Add a new column with ADD COLUMN, copy data to new column and DROP COLUMN to drop...
I want to change column names in a MS Access Table using MS Jet ALTER TABLE statement. In the table there are columns of type Memo. The ALTER TABLE statement to change a column name is:
April 28th, 2009, 07:56 AM
Where are the control TextBx (Form???) and where are the Function SpecialChrTest (Module???). If the function is not in the same form as the control you must access the control with the form as well...
April 20th, 2009, 05:06 PM
Thanks WizBang; found this one but setting it gives the title bar a twitch while typing. Will play around with it some more.
Any ideas for custom properties to update immediately?
April 20th, 2009, 09:44 AM
You misunderstood me:)
I 'm busy trying to make a usercontrol that includes a label. If I put my control I'm creating on a form and I edit the caption property of my control, that should...
April 20th, 2009, 08:59 AM
I was also wondering about that, but was working on the code supplied.
April 20th, 2009, 06:34 AM
Another thing I just noticed is that you are creating a array with 1145 elements, your storing the acronyms from the spreadsheet to this array one at a time as you test them but you are never using...
April 20th, 2009, 06:18 AM
Your AcrNimTst() is a Sub and not a Function and it is not returning anything so that part of the If... And...And...And...End If will not be True or False so your textbox assignment doesn't get...
April 20th, 2009, 05:56 AM
I'm making a UserControl that includes a Label.
When one put a label on a form and you change the properties of the label (i.e. Caption or Alignment) in the IDE on the properties window the label...
April 17th, 2009, 12:19 PM
The thread Dglienna supplied did the job halfway. It allowed me to determine the textwidth of a string or partial string without having to set the form font to the label font etc.
Added a bit of...
April 16th, 2009, 05:24 PM
The Autosize property makes the label one long line so it's not going to work. I have long captions that must wordwrap to the width of the label but then the height must be adjusted to...
April 16th, 2009, 03:33 PM
Is there a way I can determine, at runtime, what the height of a label must be to display the entire label caption.
The label has a predetermined width, also determined at runtime. The caption...
April 2nd, 2009, 05:41 PM
Pleasure. Rate if your happy:)
April 1st, 2009, 05:59 PM
As Datamiser said; A Sub does not return a value, you need to use a Function for that. Where you call the Sub with
you are not passing the variable that you told the Sub...
Click Here to Expand Forum to Full Width