[URL] the CodeContextObject property returns a reference to the object from which the currently executing macro or VBA procedure was called. This may or may not be the active object.What's the equivalent in C# or VB.NET ?
View 1 Replies
In Access if a query were to compute the sum of different fields where there is a likelihood of one or more fields being NULL, you use something like NZ. Is there any equivalent Function for handling NULLs in VB .NET?
I'm use the code below to retrieve the SUM of the column "BudgetAmt" from my DB but get InvalidCast Exception was unhandled error because the BudgetAmt and/or AllocationPersonnel holds no data:
Dim strSbCode As String = cboSubSubOrg.SelectedValue.ToString
Dim budgetYr As Integer = CInt(cboBudgetYr.Text)
personBudget = CDec(transDetailsDT.Compute("SUM(BudgetAmt)", "FundSource = '02101' AND DataSource = 3" _
[Code].....
what is the equivalent of Access DMin and DMax function in VB.net?
View 1 RepliesI was simply wondering if in VB.Net there is a shorthand equivalent to this kind of C# including the private setter:
public string Test { get; private set; }
In Delphi when we needed to allow the system to finish painting an object or something like that we could add a processmessages that would then let the system finish what it was doing before going on with the code.This was always handy when we wanted to show a message like "Please wait"before the start of a lengthy process.So then. What is the equivalent way of doing this in VB.
View 1 RepliesI'm developing a forms application with VB2010; and I'd like to be able to freeze the screen / form while the code populates the form for display on the screen. Then unfreeze the screen when the form is populated, to display the populated screen text; in a similar way to the VBA commands Application.ScreenUpdating = False and then Application.ScreenUpdating = True.
View 2 RepliesI've been tasked with the development of a Widows service, and so far i've pretty much got it all done, except I'm looking for the Services equivalent to a forms applications 'Application.ExecutablePath'.I've search the net, and gone through most of the intelesence's item's but cant find it, and acctually have very little idea where else to look for it..
View 6 RepliesI have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 Repliesanyone knows the equivalent code for App.TaskVisible in VB.net? App.TaskVisible is from VB6 which hides the application in the applications list in task manager and not in the processes list tab.
View 1 RepliesI just want to know if there any equivalent event (ADO. NET VS 2008) event as in MS ACCESS Form's OnCurrent Event.
The reason is I like to make some calculations based on some data bound controls with current datarow data when user clicked a row in DataGridView (or by using bindingNavigator). I've tried with DatagridView's RowEnter event. But some Data bound controls are not yet reflect the data of current datarow when that evet was fired.
In MSDN Help File: It says "RowEnter Event: Occurs when a row receives input focus but before it becomes the current row. "
I'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
My boss gave me an MS Access application that was developed by our former colleague. He wants me to convert that application to VB.Net Windows form application. I went through the MS Access Application. It contains tables, queries, forms, reports and macros. I could not find the programming (Where is the code written in MS Access?). My boss wants the windows application to be same as the MS Access Application (both in design and logic). I don't how will i develop the windows form. How can I achieve this?
View 2 RepliesMy boss gave me an MS Access application that was developed by our former colleague. He wants me to convert that application to VB.Net Windows form application. I went through the MS Access Application. It contains tables, queries, forms, reports and macros. I could not find the programming (Where is the code written in MS Access?). My boss wants the windows application to be same as the MS Access Application (both in design and logic). I don't how will i develop the windows form.
View 4 RepliesIs it possible to access Application Properties of my applicaiton in run time ? Please refer the below attached image (I want to access the Title and Category properties in my application)
View 5 RepliesI am developing a project in which i have to access datagridview's value into my application
Now i am able to get the handler of window
i am also get able to handler of datagridview.
i am used findwindow & findwindowex functions
Now i want some guidelines :-
1.How i can access Column Count
2.How i can access row Count
3.How i can access values of datagridview
for listview there are built in class in win32 named as syslistview32
Is there any class for Datagridview?
Or By which Window class handle datagridview?
Or tell any other way to access datagridview values of Third Application By My Application.
I need to be able to interact with an application's GUI within another application. Basically, I would like to run an application and have it's GUI appear in a MDI-style Form in my application. Is such a thing possible? The reason I need to do this is because I need to access an application remotely without having to use Remote Desktop or similar tool. Any questions on this, feel free to post.
View 2 RepliesI've trying to access an appsettings key value in my vb.net 2.0 web application.I've put the key in the app.config file:
<appSettings>
<add key="DownloadURL" value="http://<myURL>/" />
</appSettings>
I've followed the instructions here, and it says that I need to access this key like so:
URL = System.Configuration.ConfigurationSettings.AppSettings("DownloadURL")
But I get the following message:
Public Shared Readonly property
AppSettings() As
'System.Collections.Specialized.NameValueCollection'
[code]....
I tried to replace the old method with the new one, but it does not exist.Strange, since I've done a similar thing with a web app and it did exist there.
I am creating a VB.NET application with the back-end of MS-Access. I have created manual backup of database.But now i need the help to create an automated backup of the database in the same application.
View 1 Repliesim trying to update access from vb.net application. when excuting im getting this error: the microsoft.jet.oledb.4.0 source="c:...."provider was not registered on the local machine. when i go and run cmd to register ddl files. i was able to register msjet40.dll and msjetoledb40.dll with the other dll a box pops up: the module "c:..." was loaded but the entry point dllRegisterServer was not found?
View 2 RepliesI'm currently trying to convince management of the need to port one of our applications to .NET. The application has grown to be a bit of a monster in Access (backend in SQL), with 700 linked tables, 650 forms/subforms, 130 modules and 850 queries.
I pretty much know all the major benefits of doing this, but now need to look at how this can be achieved technically, so I can put a project plan together.So, my plan was to convert the queries into stored procedures and/or views on the backend and re-write the forms in WPF or WinForms.
Now, the code is where I come unstuck. Is it possible to packaged up the code behind and modules into dlls and consume them whilst it is slowly ported to VB/C#?
What we can't be left with is half an application in VB/C# and half in Access, it must 'appear' to all be one application, even half way through the migration.EDIT: Just some more info about what we do and why we're looking at moving away from Access.We are essentially an ISV and the Access application is our main product. This application has been developed over a period of 15 years, by many, many developers on an ad hoc basis. There is no documentation for this application.
We also have problems with getting branching in SCC to work properly, so we've currently got 4 or 5 code bases for the half a dozen clients we have. On top of that, all the testing we do is completely manual, which you can imagine is very labour intensive, and only scratches the surface of what really needs to be tested.We're currently looking to expand, and have a number of sales leads that are in the final stages. I'm worried that with these new sales, we're going to be swamped with support and testing, and that this application is going to become even more entangled an buggy.
I'll also add to this the fact that we're just about to enter the spec phase of a brand new product, which is almost certainly going to be built in .NET. If we were to rewrite the Access application in .NET, then the people we use for that can go straight on to this new development. If we were to stay in Access, then we'd have to get some new Access people in, whom would have to be retrained once we start the new development.
So essentially it has come down to two choices, major refactoring work in Access to try and 'organise' the code a bit better, and those of you who have suggested culling parts are most probably right; I'm sure there are parts that are no longer used. However, I fear that if we stay in Access we still won't be able to build in effective testing and we still won't have proper SCC branching, which will lead to support continuing to be a nightmare, and any future developments on this product makings things worse. Either way there is a lot of work that we're about to embark on, which is either going to be done in Acces, or .NET.
I have a web service that I will need to add as a web service reference in my vb.net application which is a plug-in to Outlook. I initially tried adding the reference by right clicking on the Project and selecting "Add Service Reference". In the box that pops up, I type the web service url in the address field and the namespace name and click ok.
Warning 2 Custom tool warning: Cannot import wsdl: portDetail: There was an error importing a wsdl:binding that the wsdl: port is dependent on.XPath to wsdl:binding: //wsdl:definitions[@targetNamespace='http://tempuri.org/']/wsdl:binding[@name='IAConnectServiceHttpGet']XPath to Error Source: //wsdl:definitions[@targetNamespace='http://tempuri.org
[code].....
I have sqlserver database in my server folder c:data How can i access this data from other computer with my vb application?
View 8 Repliesi am developing a vb.net application my question is how can i access a folder inside my application ?? for example i created a folder Myfold where i store some .doc files and i want to read them from my code.
View 1 RepliesI'm trying to print a barcode using the following code in Lightswitch Application[code]...
View 1 RepliesI have an application which is grouped in a MainApplication and serveral Modules (DLL's) The Main Application is basicly a Form with a NavigationBar on the Left Side (like in Outlook 2003) and an MDI-Parent. There is also a Simple Login Routine on this Form. I store the UserName after Loggingn to a Property. The DLL's holds functionallity and Forms for various Sections for example there is a Employee.dll which holds functions and a form to show all Employees.
On Loading of the Main Application I loop trough all dll's in a "Module"-Folder and extract NavigationItems from them which I add to the MainForms NavigationPanel. I don't have a reference to the Modules because I want to make it as flexible as possible so that it is possible to delete a Dll form the Module directory in order to remove the functionality from the MainApplication. The Modules could work also without the MainApplication if they are Complied as an exe insted of DLL of course. This works fine so far.
[Code]...
I need to check and see if I can access a file(the file is in use) So When I try to access it the application crashes. When I can access the file without the application crashing I would like a msgbox to pop up.
View 3 RepliesI need access to very precise timing in a .NET application. I need microsecond precision. Is there an easy way to do this in .NET?
View 5 Repliescan I have access to anivirus codes.
View 3 RepliesI am using following code to add my application to StartUp of Windows. It works well in XP but gives error in Vista that you donot have permission to edit registty file.[code]
View 1 RepliesCurrently following is the setup of my wifi connection.
Laptop 1 ------> Wifi Router <------
Laptop 2
There are about 5 laptops which connect to the wifi router to access internet. Network is password protected so anyone with a valid network key can connect and access internet.
I am planning to develop a local website which will be having a list of username and passwords. I will also remove the password of the wifi network so that anyone can connect.
If a connected system tries to access a web page in the internet then redirect them to a Login page (in the local website) and ask them to login. Once successfully logged i,n the mac id should be added to "Allow" list and monitoring starts. Internet should not be available for those who don't have a valid username and password.
I was thinking about developing the application to block/allow internet access though a vb.net/c# application.
I am okay with the website part. What I would like to know is
How I can block/allow internet access through the .net application. Is it possible in .net or should I be going for an unmanaged code development? If it is possible where is the best place to start? I have experience in winforms development but not much of network programming. Will there be any change in my current wifi setup? May be a new webserver/proxy server which will host the website and the windows application?
