|
Dim PassCheck() As Object
y = TextBox2.Text
ReDim PassCheck(y.Length)
For i = 0 To y.Length - 1
PassCheck(i) = Mid(y, i + 1, i + 1)
.
.
.
.
and now i want to get each type of the variable stored in the array
to differ numeric, charactere,and alphabetic.
Thanks.
Assaf
|
|
|
|
|
You could loop through the array and use the following functions to check each character:
If you start with a character array:
Char.IsNumber(character)
Char.IsDigit(character)
Char.IsLetter(character)
Char.IsLetterOrDigit(character)
If all you want to do is check the contents of a string, loop the characters of the string and check using one of above. You don't have to put the characters in an array to do this.
What is the purpose of this?
Steve
|
|
|
|
|
Hi all,
I'm not too sure if this is possible, but any feedback at all would be much appreciated. I would like to have a datagrid where the first row acts as a filter. So, just under each heading you would have a combo-box that can filter that column.
I've searched the net for code or components that can do this and haven't found anything. Does anyone have any ideas regarding this issue?
Thanks in advance,
|
|
|
|
|
I don't think you can do that with a standard DataGrid.
You may be able to purchase a custom DataGrid control that has this functionality. There are many such components on the Internet but they are often quite expensive!
Simple solution would be to add filtering combo's above the grid or use a Master/Detail grid configuration.
Steve
|
|
|
|
|
Thanks Steve,
The combos above the grid is how we are doing it at the moment. Was just wondering if there was a way to have the filters embedded in the grid.
|
|
|
|
|
Can't be done inside the grid the way you described.
You might want to explore the possibility of adding this functionality to the DataGridView's Headers though. It sounds like you already have the bulk of the code written using ComboBox's.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi,
have a look at one of my articles[^]. It is not integrated into the first row but can be integrated intro the caption and handles proper resizing so it looks like its fully integrated.
Robert
|
|
|
|
|
Hi,
Thanks to everyone for their replies. I'll download that version alright and try and get it working for our project. I might have a question or 2 later on.
Thanks again,
|
|
|
|
|
Hi Robert,
I was looking at your sample and it seems to work as I would like it. My project is in VB. I was wondering do you know the code in VB to link to your Grid View. I'm looking in particular at the ExtenderSample. If you don't have it thats fine, just thought I would ask.
The specific line I'm having problems with is:
(_extender.FilterFactory as GridViewExtensions.GridFilterFactories.DefaultGridFilterFactory).CreateDistinctGridFilters = true;
I can't seem to write this in VB .net.
Any help would be much appreciated, thanks again for the code.
|
|
|
|
|
Hi,
I'm not really a VB.Net programmer but I think CType is used there for castings.
You could also create a new instance of the filter factory (this would even be more typesafe):
Dim factory as GridViewExtensions.GridFilterFactories.DefaultGridFilterFactory
factory = New GridViewExtensions.GridFilterFactories.DefaultGridFilterFactory()
factory.CreateDistinctGridFilters = True
_extender.FilterFactory = factory
|
|
|
|
|
Hi Robert,
Thanks again for your help. I'm still not quite there. Just a textbox appearing where the filters should be. I feel I'm close, when I put a watch on the _extender it seems to be filling up with data.
Do you if people have had this working for VB without any problems?
Thanks again,
|
|
|
|
|
Hi Robert,
Another quick question (you must be sick of me at this stage) but does your code only use datasets? I using bind to objects.
|
|
|
|
|
daveryan78 wrote: you must be sick of me at this stage
I'm not getting sick so quickly  .
daveryan78 wrote: does your code only use datasets? I using bind to objects.
Well you should have read the article more carefully. Yes the extender only works in conjunction with DataView, DataTable or DataSet. This is simply because I'm using some of the internal functionalities of those classes.
Maybe filling your objects from a collection into a DataTable might work for you.
|
|
|
|
|
Hi @all
I was looking around for a solution but i cant find anyone.
The point is, i want to make a list with the Tables inside of a specified mdb file.
Is there a way to read the table structure of an Access mdb?
Greetings
poOkie
|
|
|
|
|
I don't know the answer to your question but you will need to examine the TableDefs collection (DAO) of the database somehow.
Each database has a TableDefs collection. This contains a TableDef (DAO) for each table that exposes properties of each table.
Steve
|
|
|
|
|
i have dataset has 3 tables customerinfo,customercontact and customeraddress
and there is relations between them
customerinfo displayes on textboxes
but others i filltered them by the id dispyed in the textbox by dataview
i want to set DataBindings for the tow datagrids by the dataview
so,when i change in gride i need to change in the dataview
the save to dataset and save in database
how can i do this please
thank you
MD_NADA
|
|
|
|
|
To bind the grids to each DataView:
myDataGrid.SetDataBinding(myDataView, "")
Steve
|
|
|
|
|
hi all,
i'm using vba under access.
i wanna a database secured by a password from another database
i used this function in the autoexec macro
code:
Function Ouvre()
Dim ds As DAO.Database
Set ds = DBEngine.OpenDatabase("C:\Step3.mdb", False, False, "pwd =alpha")
End Function
the prob that when i try to open the base it sounds that i couldn't do it.
so someone know? how can i wrote a code to connect to the base with password?
thx
|
|
|
|
|
You cannot have two separate databases open in the same instance of Access.
You can have linked tables from another DB or you can use the 'Shell' command to open the DB in another instance of Access:
Private Sub CommandButton_Click()
'Open another database
Dim PathNameOfDB As string
PathNameOfDB="C:\Pathname\BDName.mdb"
Shell "C:\Program Files\Microsoft Office\Office11\msaccess.exe " & "PathNameOfDB", vbMaximizedFocus
Application.Quit ' closes current application so new DB is current.
End Sub
MDBMakers.com is a great source for Access and VBA solutions.
Steve
-- modified at 8:46 Friday 4th August, 2006
|
|
|
|
|
Hi guys.
I've been struggling with this for about two days now and I'm at wit's end. I've been tasked with writing an image viewer application.
"Easy enough" I hear you say. Well, yes, writing an application that can view an image is pretty simple, but there's a catch - they want the application to load INSIDE the user's browser, just like Word and Adobe Acrobat opens the documents in the Internet Explorer.
Basically we build up a url to a tiff image in the web application, and when that url is called, we want our image viewer to open the image in the browser, instead of having to open the Windows Image and Fax viewer in a new window and until Microsoft decide to add native viewing of TIFF images to IE, I'm in a bit of a pickle.
Please, please, please could someone lend a helping hand here?
Thanks,
Johann.
If all else fails... influence with hammer
|
|
|
|
|
I have developed my own customized textbox control.That is working properly.I m now working on a Datagrid Control.How can i use my textbox control in that DataGrid Control.
If anyone has any idea ,Plz send me the answer .
|
|
|
|
|
Hi,
DataGridTextBoxColumn is not revealing its internals on this part. If you inherited from the normal TextBox you could try to set the private edit field of DataGridTextBoxColumn via Reflection. It holds the TextBox instance which is shown on the respective columns.
Other than that you probably have to implement your own column style class. Use Reflector to look how the given ones are implemented to get an idea on what to do.
Robert
|
|
|
|
|
Hi all,
iam havin a hard time figuring out how can i close a form which calls another form...
its like a log in form calling the main form after validating the log in parameters.
my code goes like this...
dim form2bcalled as new form2bcalled
form2bcalled.show()
me.close()
what happens after this codes is that the entire project close... leading me back to the design state.
thanks in advance guys...
Cheers.
"computers are the lousy actors, and programmers are the playwright..."
-::maximus::-
|
|
|
|
|
Option Strict On
Module basMain
Public WithEvents frmParent As New Form1 'project startup form
Public WithEvents frmLogin As Form2 'login form
Sub Main()
'prompt user for login first
frmLogin = New Form2 'create a new instance of the form
Application.Run(frmLogin)
Application.Run(frmParent)
End Sub
End Module
|
|
|
|
|
owkei... ill try this one... thanks alot
-::maximus::-
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
