Search:
Type: Posts; User: ktab
Search:
Search took 0.03 seconds.
-
tried your idea before your second post.. which is brilliant :)
Just pass a string instead of eventinfo itself.
-
Job id done, thank you for the help
Updated code is:
Private Sub HandleMyControls(ByVal evt As EventInfo, ByVal Proc As EventHandler)
For Each c As Control In Controls
...
-
Hello,
I have the following code to dynamically add handler to my controls
Private Sub HandleMyControls(ByVal Proc As EventHandler)
For Each c As Control In Controls
...
-
it's mdb (wanted to use a file/mobile db: any other suggestions are more than welcome)
-
I will experiment some with your code and tell you the results :)
-
-
It's just the int at invoicetype field. 1 is sales 2 is purchases
-
Ok, as it's very difficult to transfer here all tables structures, I will give a sample and if i figure out, i can solve the rest
Table "Products"
RecordID int
Table "Transactions"
...
-
Almost solved. The above gives me an error at query builder when i enter,
but when I execute query, i get the desired results... what could be the problem?
-
SELECT modProducts.Product_Name, SysProductCategories.Product_Category, SysProductSubCategories.Product_SubCategory, modProducts.ProductDescription,
...
-
The 2 sums are already in:
SELECT modProducts.Product_Name, SysProductCategories.Product_Category, SysProductSubCategories.Product_SubCategory, modProducts.ProductDescription,
...
-
Hello,
I have the following query to my tableadapter:
SELECT modProducts.Product_Name, SysProductCategories.Product_Category, SysProductSubCategories.Product_SubCategory,...
-
Great one, thank you.
May I suggest an update to users, another solution in order not to set manually UTCoffset...
Place next function in your solution:
Public Function GetUTCOffset() As...
-
-
Hello,
If I would connect to database I would run a query like this:
"Select distinct Column1, column2 from tablename where somefield=somevalue order by column2"
How can I run this query to a...
-
sorry for taking so long to answer back, but i had a small insident with my pc and had to set it up all over again.
I got an error (Error:Range variable name can be inferred only from a simple or...
-
Hello.
Since now, I have the following:
Dim x = ( _
(From row In _Obj_DataSet.Tables(TableName).Rows() _
Select row(ID_ColumnName)).ToArray())
How can I...
-
.paul..
Thank you very much. I love 1 line coding :)
Nice one.
-
done:
Dim m() As String = Split(frmExcludedColumns, ",")
Array.Sort(m, AddressOf MyArrayComparer)
For y As Integer = UBound(m) To 0 Step -1
...
-
actually, yeap, it's sort :P (a most common mistake I alway make :/ )
And this is what I had in mind, to recreate an array() as integer by converting the array created by split. I just wanted to...
-
While split a textline with numbers (integers), i get an array with numbers as string.
Is it possible to short them? Array.short does not work as it shorts according the first number of the integer...
-
Well.. first of all i load my db in a dataset. These are my constants:
Public _Obj_DataSet As DataSet
Public _Obj_DataAdapter As OleDbDataAdapter
Public _Obj_BindingSource As...
-
When I update a record at table [Product] with the integer that stands for [Supplier Name] from joined table [Suppliers], this does not appear in my datagridview. Instead, I have to reload the table...
-
No probs, I trap keys for numeric keys only and also i get math.max and math.min to get the values.
Like this: (actually a part of my code)
Dim TempDouble1 As Double, TempDouble2 As Double
Dim...
-
Hello.
How may I filter a bindingsource between 2 numbers? Obviously "column_name BETWEEN Num1 AND Num2" does not work, since "between" operator is not supported. Any ideas?
-
To do so, i guess i have to go to "Edit" and edit (?) title? Or is it done otherways?
-
It works both ways :P
I had made a mistake at the value of "i" integer, that's why it failed ;)
Thank you any way
-
Hello all
I have the following problem. I want to loop a control array that each of them, is not in the same container (frame), to give values.
What i do, is this (form).(control...
-
Hello,
When i used to work with MS forms2 and VBA, i used to set the list of a combobox like: cbTest.List=strArray() where strArray is an one dimension array...
Is there a way to fix the list of...
-
I think that i solved it...
converted the string at procedure that opens recordset from:
.Open strSQL, mobjConn, adOpenDynamic, adLockBatchOptimistic, adCmdText
into:
.Open strSQL, mobjConn,...
-
And the connection...
Public Sub ConnectToDB()
Dim strConnect As String, strPassword As String
If Not Ping_Connection Then Exit Sub
strPassword = "*****" 'masked ;)
strConnect =...
-
Opens recordset:
Public Sub OpenRecordSet(Optional Table_Name As String)
If Not ConnectedToDB Or Not Ping_Connection Then Exit Sub
If MyTable = "" Then MyTable = "Members"
If Table_Name =...
-
ADO.. MS Access
The connection is already open (not opening/reopening)
-
Hello,
I have tried the following code to update my recordset, but changes are lost as soon as i reopen recordset... What is the problem with that?
Public Sub Save_Data()
Dim i As Long
With...
-
I'm interested only in greek and english language support.. I've already tested that and it works. So i think i'm covered with .charset
-
worked like a dream...
All is needed is add the public const for greek (161) and add a code line like:
.......
frmTask.Ctrl(i).FontUnderline = .FontUnderline...
-
experimenting is evolution. I'll give a try to all your ideas, and i'm sure i'll find the way out. Thank you for all you time and advices
-
My question, is exactly, how may I modify charset. And how to check it's value before apply?
When the form loads, combos are by default MS Sans, 8, regular, and are displayed as it should.
This app...
-
Standard VB combos.
An example of how manipulate fonts is as follows:
Private Sub cmdFont_Click()
Dim i As Long
With Me.cmDialog
.CancelError = True
On Error Resume Next
.Min =...
-
Hello,
I have the following problem.
In a form, I have a set of combos, where font is set to MS Sans Serif, size 8, regular. If i change anything of it, it displays greek alphabet from AB...ect ...
|
Click Here to Expand Forum to Full Width
|