My project which includes an access database is published for distribution on a CD. The database properties are set Build Action - Content, Copy to Output Directory - Copy if Newer. I need to be able update the published project. I have used ClickOnce Publishing Process.
View 1 RepliesMy application has Binding source to an acess db, how can i distrivbute the application and db as one exe file?
View 3 RepliesI have an access database which includes Customers table and one of its columns is the Birth date. In project in visual studio, using visual basic 2010, I have a form with a calendar. In this form I want to show who has birthday today. How can I compare all the customer�s birth date with the day we have today? And have as result a label with all birthdays?
View 1 RepliesI am in the middle of the creation of an application using vb.net. I have a database created in MS.Access which includes 7 tables. I connected this one with my parent program code. Now the problem is that I want to display the data from each column. I have 12 columns and 14 rows in my first table. How can I display data from one column in a Combo box?
View 1 Repliesi have this solution that i'm suppose to make an installer of, but because it calls a datebase and the database is not within the solution therefore it was not included in the installer.
and my installer cant work correctly. is there anyway i can go around doing it?
ive created a program in VB 2008 and i cant remember how to publish it in such a way that it includes the database that the program uses. At the moment when i publish it, it only works on my system because i have the database on my PC, if i delete the database from my pc the program messes up because it doesnt have a copy of the database in its program resources etc.how do i publish the program so that it includes a copy of the database that it needs to function?
View 6 RepliesI have made a Database.mdf that contains a table that Includes 3 diffrent Column Names.
1:"ID" This one i set to an primary key and i have also made it automaticlly put a number in order to the list. Like 1,2,3,4,5 for each data added. Data Type for this is int.
2:"WordCombination" Were i enter my word combination that i want it to look for)
3."TypeofCombination" Were i enter what the program should add to what i typed in texbox1 if it contains the WordCombination.
I want my program to se if texbox1 contains any of those WordCombinations in my database. And if thats true, Then i want it to show whats in the TypeofCombination + the text in texbox1 in texbox2. If i enter "What do you want ?" in Textbox1 i want the program to find that "What do you want ?" contains "you want" like in ID:1 WordCombination:you want. So becuse this is ture it should enter TypeofCombination in this case "Question:" + what i entered in Textbox1 to show in Textbox2.So if i write "What do you want ?" and click start. Textbox2 should show "Question: What do you want ?" If i Write "My name is Jake" and click start. Textbox2 should show "Answer: My name is Jake".If I Write "hello you Hi there Jacob" and click start. Textbox2 should show "Greeting: hello you Hi there Jacob".And i Should be able to add and delete Word Combinations Without having to change the program.
I put database in bin->debug and i also call from that folder using DataDirectory Business_Card_Database.accdb when i publish the project database not found error is occur note I also tried
1. System.IO.Path.GetFullPath
2. Application.StartupPath
3. System.IO.Directory.GetDirectories
Above all are not working to find database after published I'm using
1. vb.net 2010 express edition
2. Access database 2010
I have connected my vb .net forms to the MYSQL database but when i comes to publishing, i do not get the database on the published application.
View 4 RepliesI have made a small app with a SQL Database, published and installed it on my desktop pc with the express version.What directory does .net place the database in that has been installed.
View 3 RepliesI have a vb.net application that will not connect to an oracle database on the PC that I publish the app too. It works fine under my pc both in design and when I publish it to myself. But it will not connect under the pc I publish it too. I do have oracle installed on the pc and have the connection setup exactly as I have on my own pc. I am sure it is a file path issue, or at least I believe it to be that.
View 5 RepliesI have the same problem as in this thread [URL].
I am connecting to a SQL database on a hosted server and everything is ok but if I publish the application then it fails to connect which is a bummer because then I can't debug it!
I have tried turning off windows firewall and that doesn't make any difference.
When I publish my program I get no errors, and then when I install it on another machine it says it gives me the error that it can't read the txt file that it stores data in. If I hit continue it also fails to read the database. The database file is stored in the bin/debug folder and I told my program to include it when I first added the data connection. Anything I can do to have these included so my program can run on other machines?
View 6 Replies[Code]...
I have attached the full code here [attachment=16637:Form1.txt]
I've developed a small cost-tracking app with VB 2008. I was wondering what are the dependencies this app requires to install and run on other computers? I am not using any 3rd party or out-of-ordinary controls/DLLs.
View 5 RepliesI can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 Replieshow to retrieve/export distribution lists from an Exchange server? I've tried a few articles but the one that looked the closest said a needed to add a reference to Outlook 14 and the highest i have is 12.0
I look after a system that allows the creation of distribution lists but no way to sync them up with Outlook(and as you can imagine trying to maintain that manually is just a ballache)
i wanted to write a quick program to get the file organization of my MP3 files back into sync with the info in my ID3 tags... I had tried to get the Windows Media Format SDK, but when i go to install it says it can only run on WinXP. Problem is it seems the official site is gone, and the other links i've found to a hosting on Novell's servers is also down. Anyone know where i can still get a distro of TagLib# for C#/VB.NET for Windows? Or another good ID3 tag reader?
View 2 RepliesUnable to find a normal distribution function for VB8 Found the others I needed Math.Log, Math.Sqrt, Math.Exp but no Math.ND To give an example of the problem that the code needs to do.
P = S*NORMSDIST(D1)-K*e(-Rf*T)*NORMSDIST(D2)
I 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 RepliesI want to distribute the installer package to my clients. how can I make setup.exe file for my visual studio 2008 projects.
View 4 RepliesWe are using Exchange 2003 as part of sbs 2003 premium.
We have a distribution group abc which receives emails abc@mydomian.com. How can I access emails coming to this distribution group and extract any PDF attachments that may be present using vb.net code?
I tried to put just the name of the in the .To but that didn't work. Could someone please point me in the direction or show me how to do it?EDIT: My Code is Below...
Dim Subject as String = "Services for " & date.today.string
Dim Body as String = strHTML (defined elsewhere on form)
Dim oApp as Outlook._Application
[code]....
I didn't copy or paste as the code is on a second computer and that one isn't network connected. I typed it in, so there may be a typo or two. When this code is executed, nothing is sent.
i have created a VB.net application which can be used as a BO scheduler substitute for sending refreshed report copies. These copies are AES 256 encrypted and password protected.
View 2 RepliesIm trying to use the library in GNU in VB2008 to generate random number with uniform distribution (actually will also use it for other distributions)...I already added dll under bin file and try to run the following code, but just cant make it work:
Public Class Form1
Declare Function gsl_rng_uniform Lib "C:vbuniformuniforminDebuglibgsl.dll" (ByVal x As Double, ByVal y As Double) As Double
[code].....
I have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
View 1 RepliesI am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 Replieshow to get my compiled program onto another computer. I'm using Visual Studio 2010 Professional.
I've read and tried ClickOnce deployment and Setup Installer, but I'm not getting it right.
With ClickOnce, I manage to install the program and it has the menu item and icon in the Start menu, but when I try and run it, it tells me that it can't find the text file. I put the file in the bin Debug and Release folders, selected 'Build' then 'Publish' and still no go.
I tried the other option of creating an Installer (using [URL] as my guide), but I get the same error - the txt file can't be found.
I've done this several times, but just can't seem to get it to work. Other resources online, like YouTube, just cover a project that doesn't include a text file or database file etc.
I have to create a Dialog box to get the user's selection. I can use the InputBox to get text but if it is able to show a Dialog Box with a Combobox, user can easily select items.
View 2 RepliesI've been working creating a few programs in visual studio 10. These work fine on my own PC because I have the .net framework installed. However I need to be able to distribute these programs as a single .exe file download from our website and also as a single .exe file via CD.
Most of the PCs which will be installing my programs won't have .net framework installed and I don't want to force people to have to download the files from the internet (it just seems like so much hassle and I can't guarantee that everyone who wants to install my programs will even have access to the internet).I know that I can set pre-requisites in the publish tab and I have done this whilst setting "Download prerequisites from the same location as my application". I've already downloaded the redistributable files WindowsInstaller-KB893803-v2-x86.exe and dotNetFx40_Full_x86_x64 and I've put the files in the same folder as my project.I then go into the publish wizard and select that users will install the application from a CD-ROM or DVD-ROM. Unfortunately I then get the following errors:
Error 2 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' in item 'Windows Installer 3.1' can not be located on disk. See Help for more information.ConsumptionCalculatorDraft1
Error 3 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'DotNetFX40dotNetFx40_Full_x86_x64.exe' in item 'Microsoft .NET Framework 4 (x86 and x64)' can not be located on disk. See Help for more information.
ConsumptionCalculatorDraft1