Visual Basic

4-Aug-06 2:29

Can you explain in a bit more detail?
What code do you have so far?

Steve

Re: Type

Assaf824-Aug-06 2:47

Assaf82

4-Aug-06 2:47

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

Re: Type

Stephen McGuire4-Aug-06 3:13

4-Aug-06 3:13

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

Filter in Datagrid

daveryan784-Aug-06 0:26

4-Aug-06 0:26

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,

Stephen McGuire4-Aug-06 2:26

4-Aug-06 2:26

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

daveryan784-Aug-06 2:49

4-Aug-06 2:49

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.

Dave Kreskowiak4-Aug-06 2:53

Dave Kreskowiak

4-Aug-06 2:53

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

Robert Rohde4-Aug-06 3:18

4-Aug-06 3:18

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

daveryan784-Aug-06 3:32

4-Aug-06 3:32

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,

daveryan788-Aug-06 2:29

8-Aug-06 2:29

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.

Robert Rohde8-Aug-06 6:24

8-Aug-06 6:24

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

daveryan789-Aug-06 2:16

9-Aug-06 2:16

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,

daveryan789-Aug-06 3:47

9-Aug-06 3:47

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.

Robert Rohde9-Aug-06 5:32

Read with Vb.Net the Table Structure of Access

9-Aug-06 5:32

daveryan78 wrote:
you must be sick of me at this stage

I'm not getting sick so quickly Smile | :)

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.

p00kie3-Aug-06 23:37

p00kie

3-Aug-06 23:37

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

Re: Read with Vb.Net the Table Structure of Access

Stephen McGuire4-Aug-06 2:36

DataBindings for datagrid

4-Aug-06 2:36

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

Mohammed Elkholy3-Aug-06 22:50

Mohammed Elkholy

3-Aug-06 22:50

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

Re: DataBindings for datagrid

Stephen McGuire4-Aug-06 2:44

[beginner] opening a base throught vba

4-Aug-06 2:44

To bind the grids to each DataView:

myDataGrid.SetDataBinding(myDataView, "")

Steve

torNAdE3-Aug-06 21:47

torNAdE

3-Aug-06 21:47

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 Confused | :confused:

Re: [beginner] opening a base throught vba [modified]

Stephen McGuire4-Aug-06 2:06

Load my app INSIDE the user's browser

4-Aug-06 2:06

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

Johann Marx3-Aug-06 20:28

Johann Marx

3-Aug-06 20:28

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

DataGridTextBoxColumn

PratibhaUniyal3-Aug-06 19:49

PratibhaUniyal

3-Aug-06 19:49

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 .

Re: DataGridTextBoxColumn

Robert Rohde4-Aug-06 3:21