|
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::-
|
|
|
|
|
Also check the projects properties. The "Shutdown Mode" is probably set to "When startup form closes". You can change this to "When last form closes".
|
|
|
|
|
VB6
i have picturebox its image containes many colored squares
How i could get RGB values of any of these squares
i need it so much
THANX
|
|
|
|
|
The PictureBox should have a property to access the bitmap object. Does that object have a GetPixel method ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
More detailes with an example
if you please
|
|
|
|
|
i found the command for the date which is %D
But wat is the command that i use to increase the number of my item??
like item 1. XXX 2. XXX 3.XXX
I want to have the couting number when eevrytime new item show in my data report...?
anyone have the full list of the data report command?
|
|
|
|
|
hello!
I'm creating an application that reads a DBF exported from a ARCview 3. I was able to run a query using a VisualFoxpro provider.
The problem was, there are times when the exported DBF files contain duplicate fields, then an error occurs.
I can't connect to the same DBf using MS ACCESS, is there a way to access tne tables in a low-level manner, say to be able to rename the fileds.
My idea is to identify the fields via index since I can't aidentify them by their names and attach an incremental values to the name of the fields. um.. anybody know how to do this.
U Xux
|
|
|
|
|
Hi,
first of all those DBF files are corrupted. It's not within the spefications of the format although I know that there are several ways to create such files. The only way I found to read such files was very lowlevel. Have a look here[^] or here[^]. Those sites describe the whole format of DBF files. Given this information you can either read the data yourself or just change the columns names so that each one has a unique name.
Robert
|
|
|
|
|
exactly what I needed.!
I appended a number series to the fieldnames. pretty dissapointed by the limited size of the fields. SO I had to truncate some of the letters. After that I was able to connect to it Using the VIsualFOxfrom Oledbprovide - it works !
Thank you.: -D
U Xux
|
|
|
|
|
Please help me.
I'm using VB.Net 2003. i need to make just like a taskbar on my mdi documents. So i can make my own buttons to choose which windows need to to be active.
-- modified at 20:20 Thursday 3rd August, 2006
|
|
|
|
|
Do you mean a toolbar?
Steve
|
|
|
|
|
Yes Steve,
Toolbar , because I'm using the MDI control and the parent will contains different child form in it. I think I need to popolate buttons bellow to specify which child form is active. And to do that only toobarbutton is all I know. And if I right click the button, then chhose closed[X]; also the child window or form will be out of that screen. Only the remaining child form and it's corresponding button will remain. Please help me how.
Thanks.
Ariel
|
|
|
|
|
Each Toolbar has a ToolBarButton collection.
Are you using Visual Studio?
Look up the help for 'ToolBarButton'.
You use the Add and AddRange methods to add buttons to your toolbar.
Steve
|
|
|
|
|
can i set the datareport
in vb6 with the recordset object that use DAO 3.51
dim rs as recordset
set rs=db.openrecordset("select * from table")
set datareport1.datasource=rs
the debuger tell me that the datareport1 can not be set
can any one help me please
thanks
BE OR NOT TO BE
|
|
|
|
|
Datasource is a string, no?
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
