|
Strictly speaking this is more of an Access database or VBA question rather than a VB .Net question.
Do you understand the difference between an MDB and MDE file?
One feature of MDE databases is that they do not allow the user to view VBA(visual basic for applications) code.
This is a way of protecting developers' code from being changed or stolen.
My guess is that there is something in the VBA that is not able to operate in an MDE file.
What I suggest is looking at the VBA, in the MDB, that is kicked off when one of the malfunctioning forms open.
Compare this to a form that is working and you may spot something.
Hope this helps
You always pass failure on the way to success.
|
|
|
|
|
Yes it is a VBA application. The application was written by somebody else. I have to convert it to an MDE. When I see the VB code it is all fine and working for each form. But there is a Main form that comes up first while running the MDE. It seems similar to an MDI Form as in VB but I can not spot that form any where in the MDB. When i take startup option in the tools menu there is Menu bar. It is a dropdown with two values: default and 'Mnubar'. I can not spot any file with the name Mnubar in the project explorer.
|
|
|
|
|
I've only done a very small amount of work with menubars in Access so I cannot offer much help - however one clue I can give you is that menubars can be changed in design time so it is not necessarily in the VBA.
I think Mnubar is a menu that was created at design time. I'm not sure of which version of Access you are using but in 97 and 2000 menus are just objects that float in cyberspace that are not present on the project explorer. This is why I hardly use them as they can be very messy - as you are discovering.
It sounds like the menubar has a function on it that the MDE does not like.
You always pass failure on the way to success.
|
|
|
|
|
Hi,
I want to put an excel file in a table.<br />
I use this code:<br />
<br />
<code>Dim archivo As String = openFileDialog1.FileName<br />
<br />
FileDirectory = System.IO.Path.GetDirectoryName(archivo)<br />
FileName = System.IO.Path.GetFileName(archivo)<br />
DBFConnection = New Odbc.OdbcConnection("Driver={Microsoft dBASE Driver (*.dbf)};Dbq=" + FileDirectory + ";")<br />
DBFConnection.Open()<br />
Dim dr As New System.Data.Odbc.OdbcCommand("SELECT * FROM " + filename, DBFConnection)<br />
Dim dt As New Data.Odbc.OdbcDataAdapter(dr)<br />
Dim t As New Data.DataTable<br />
dt.Fill(t)
but I get the error :
ERROR [42S02] [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object 'A12_BLANK'. Make sure the object exists and that you spell its name and the path name correctly.
please help.
thanks.
|
|
|
|
|
Surely if the database is a file, your connection string needs the file path, not just the directory path ?
It would help to tell us how A12_BLANK fits into the picture, is it a directory name ? A file name ? Something unknown ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
The problem is that I can connect to my database but I can't get the information from the file.
The file A12_BLANK (the name of the file I want to insert in a table) is a excel file.
thanks.
-- modified at 8:43 Tuesday 11th September, 2007
|
|
|
|
|
So, you're code is written to open a DBASE file (hint: Connection String!), but you're trying to get it to open an Excel file?
|
|
|
|
|
your code:
<br />
DBFConnection = New Odbc.OdbcConnection("Driver={Microsoft dBASE Driver (*.dbf)};Dbq=" + FileDirectory + ";")
maybe better:
<br />
DBFConnection = New Odbc.OdbcConnection("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + FileDirectory + ";")
please don´t ask me why driferid = 790, i didn´t try this code, found it with google.
|
|
|
|
|
it doesn't work.
thanks .
|
|
|
|
|
did you use the complete filename for the excel file?
|
|
|
|
|
I create an application and i try to access the .exe from another system in the network.
I got an error message " Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed "
How can i solve.
Thks
Yesu
|
|
|
|
|
Managed code running from a non-local source, i.e.: anything not locally attached to the machine, is run inside a heavily restricted sandbox. You've got so serious reading to do to understand Code Access Security. Just go to MSDN[^] and search for "Code Access Security".
|
|
|
|
|
Hello,
Small question, but it's given me nightmares at the moment.
Can I hold class instances in a collection, lets say arraylist?
sample code that doesn't work
<br />
Dim ClasseInstance = New Classe(parametros)<br />
<br />
' Add the instance to the arraylist<br />
InstanceHolder.Add(ClasseInstance)<br />
it's dashing the following error when i try to add the ClasseInstance to the arraylist: Object reference not set to an instance of an object.
Can someone help me out with what i missed.
Thanks
|
|
|
|
|
This error probably means that InstanceHolder is null.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks a lot.
I feel foolish 
I had this on top
Private InstanceHolder As ArrayList
instead of
Private InstanceHolder As New ArrayList
|
|
|
|
|
Hello friends,
We want to create background thread which run automatically in
regular interval
and run a particular sub ? please give your advice Thanks
Manu
|
|
|
|
|
You might wanne check out this:
' initialize
Private Timer_Queue As New System.Threading.Timer(New System.Threading.TimerCallback(AddressOf Timer_Queue_TimerCallBack), Nothing, System.Threading.Timeout.Infinite, Nothing)
Private Const Timer_QueueInterval As Long = 250
' at load or somewhere else...
Timer_Queue.Change(0, Timer_QueueInterval)
' the worker
Private Sub Timer_Queue_TimerCallBack(ByVal state As Object)
' do work
End Sub
enjoy.
|
|
|
|
|
your code "Integrating Microsoft Word in your NET applications" interested me much and I seek to make it integrated in my program but since I work with VB.net I found diffécultes with integrated in my program if you have the program in vb.net I would be very thankful if you can sent it to me by mall thank you in advance at this address "aziz_chawki@yahoo.fr"
aziz_chawki@yahoo.fr
|
|
|
|
|
aziz chawki wrote: your code "Integrating Microsoft Word in your NET applications" interested me much and I seek to make it integrated in my program but since I work with VB.net I found diffécultes with integrated in my program if you have the program in vb.net I would be very thankful if you can sent it to me by mall thank you in advance at this address
What are you talking about?
If this refers to an article on this site then use the forum at the bottom of the article page.
|
|
|
|
|
your program "Integrating Microsoft Word in your .NET applications" is in C# if you have it in vb.net send it to me pls
|
|
|
|
|
Seriously.
As you were told, the articles have forums under them, if you want to ask the author something. Asking someone to convert C# to VB.NET is just not going to happen. If you're unable to use the code via a dll, then you need to convert it yourself ( although I doubt you're capable of it, it's really not hard ), or buy a convertor, several exist.
In any case, the web abounds with examples of how to integrate Word, I don't see how you could fail to find a VB.NET sample.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
aziz chawki wrote: your program "Integrating Microsoft Word in your .NET applications" is in C#
I wrote no such program. I suggest you find the article and use the forum for the article.
|
|
|
|
|
I need to create MATLAB binary files from VB, any help will be appreciated?
Thanks
|
|
|
|
|
monochino wrote: I need to create MATLAB binary files from VB, any help will be appreciated?
Here is a document that details the MATLAB File Format[^]
|
|
|
|
|
Thanks.
I wonder if there is a simple way to use the MAT-file API, libmat.dll library
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
