Search:
Type: Posts; User: Frans C
Search:
Search took 1.39 seconds.
-
In Openconnection you open connection cnnMain , but in your declarations you have declared ADOCn.
Change either one of them to match.
Also I don't see where you call the Openconnection sub.
And...
-
Your own solution is the best, as long as the string is always in this format.
Any output from the Format function is a string, and when assigned to a date variable, the output is dependent on you...
-
There are some problems with your code.
xlApp is not declared.
xlWB1 is declared as variant, and not as Excel.Workbook
ReadOnly is the third parameter to the Open method.
The code will be...
-
-
Set the MDI form's AutoShowChildren property to false, and you can remove the LockWindowsUpdate and Frm2.Visible code.
-
You already got most answers, but it basically comes down to something like:
Dim str As String
str = frmEditor.txtMain.Text
For a = 1 To Len(str)
If Mid$(str, a, 3) = "ss{" Then
...
-
If you don't have the source code, forget it.
Otherwise, open the sourcecode (the *.vbp file, of if there is one, the *.vbg file) with vb6.
-
Don't use EXISTS, because it is slow and not necessary.
Try this:
SELECT a.Dsp_ref_id, a.Account_no, a.Voucher_No, a.Voucher_Date,
a.Name_1, a.Street, a.City, a.Postal_code, a.Carrier_code_ext,...
-
If the form is already loaded, you can use:
Forms(formname).New_Operation
assuming formname is the variable that holds the form's name.
-
I think the Found = False line is to early. It should be after the For Each .. line
-
Create a table with UserID's and passwords.
When the user log in, check the UserID and password in this table. If OK, store the UserID in a global variable, so when you need to log it with an action...
-
Because these dialogboxes only have two buttons, you are sure the other button is clicked if the cancel error does not occur.
So two possibilities:
1: No error occured. The user clicked Open/Save...
-
Is the version of Word installed on the machine the same as the version referenced in the application?
I normally use late binding for automation of office applications, to avoid versioning...
-
Your conectionstring puzles me, because it is a mixture of ADO and DOA (with ODBC) connectionstrings. What technology do you use?
Connect to the master database (this is the database with the...
-
You can always connect to the master database.
-
Your code:
sSQL = "UPDATE tblStock INNER JOIN tblStockAdd ON tblStock.ProductID = tblStockAdd.ProductID " & _
"SET tblStock.Quantity = [Quantity]+ " & txtProdQty.Text & ",...
-
Milk's solution is the best. Don't store the DC in CurrentForm, but the form.
If you need to know the DC, you can always use CurrentForm.hDC
-
Why did you include a (relative) path in the declare, if the dll is in your programs directory?
Show us also the source code where you use this function (including the code where you initiate the...
-
Is this error on the develpoment machine, or on another machine?
If the last: Did you install the program on the other machine, or did you just copy the exe?
-
Normally an ocx is being installed in the windows\system directory, but it shouldn't matter, as long as it is properly registered.
-
A late replay to post 7 by Martin Liss:
The Sub FormActivateCode is only called in Form_Load, so it will not run on a second Activate of the form.
If you call the sub also in Form_Activate, it...
-
Of course the order of events doesn't change.
Form_Load will fire before Form_Activate. There is no way to change that.
But with my approach Form_Activate will fire before Form_Load is completed,...
-
In general Martin's approach is the best, but it could result in code being executed twice in this case.
If you want to force the Activate events to run first, you could make the form already...
-
Of what type is rs2 and ConnectionAccess?
Is this ADO?
If you use ADO, you should use the % sign as wildcard, and not the asterisk (*).
-
You need to change 2 things:
Set AutoRedraw of the picturebox to True.
Image1.Picture = p.Image
Oh, and remove the Exit Sub :)
-
I have tried many times to find something for this, and unless you start using user defined functions in your query, it can't be done as far as I know.
-
I also don't understand what is the purpose of the picturebox.
If he uses a picturebox, he doesn't need a memory dc.
If he uses a memory dc, he doesn't need a picturebox.
-
How do you mean revert back to 127?
You can call this function the same as the old one:
outputdata = Encrypt(inputdata, 127) 'Encrypts Text1 contents.
-
To solve this, add or substract 256, to make sure the ascii value is in the range 0-255
Public Function Encrypt(EncryptString As String, Key As Integer, Optional Decrypt As Boolean = False)
Dim...
-
Instead of using bitblt, you can also use the native vb function PaintPicture.
The functionality is similar.
For bitblt there is a tutorial in the codebank, or you can check the MSDN library...
-
Unfortunately I don't know any of the Intersection control, Weatherview control, sensorview control, and a griddisplay control.
Probably they are custom controls as well.
This makes it difficult...
-
Normally the same code that is used for printing is also used for print preview.
For printing, the printer object is used for the drawing, for the preview, a picturebox is being used.
You could...
-
The ligthweight controls are controls with limited functionality, but which use also limited system resources.
Which and how many controls you use in your nuser control?
Do you use a picturebox...
-
You should add code like this:
For cnt = 0 To UBound(sLines)
sLines(cnt) = Decrypt(sLines(cnt),127,True)
Next
somewhere after:
Close #1
-
OK, I think this is the problem for sure.
I would not try to change the limit, because the limit is already pretty high.
Why does it create so many GDI objects?
Why do you need to load so many of...
-
Show us the code of the Encryption as well.
Or did another program encrypt it, and you try to crack the code?
-
Task manager, Processes tab.
From the menu: View--> Select Columns
Select the GDI Objects checkbox.
All graphic objects that have a handle count as one.
There is a registry setting that by...
-
How about GDI object?
There is a limit on these, depending on the machines resources.
-
MOD returns the modulus.
This is the remainder of a division
eg
3/2 = 1 remaining 1, so: 3 mod 2 = 1
9/2 = 4 remaining 1, so: 9 mod 2 = 1
12/4 = 3 remaining 0, so: 12 mod 4 = 0
XOR is a...
-
I don't understand why you need the picturebox, but in general, you must do the following:
Create a device context, using CreateCompatibleDC. I would use the printers dc and not the dc of a...
|
Click Here to Expand Forum to Full Width
|