Link The Data Together So It Can Be Viewed On One Form?
Jan 15, 2012
I am working on some sort of client + project management system. Each client can have many projects, many projects can have many staff. The Link (Junction) table allows for many staff members to be linked to the projects. I have attached the relationships which have been put together in Access 2007. In order to display the data in my VB forms, I am making use of OleDb, by having a OleDbDataAdapter and DataSet. I am using SQL queries to select, insert etc data from the original database tables.
My issue; I can't work out the best way to link the data together so it can be viewed on one form. So once I access Client 1, I can see the projects they have with us, and then within that, all the staff they have working on that project.
i wrote a program that i can search within a fixed database that contains names,phone number... ok,what i need is that i want to be able to print these results or to print the whole database i used printform1.print() for sure it printed the whole intervace of the program
I just want to display data in a DataGridView (from SQL - already made the connection) based on what is selected in a ComboBox (data that is also coming from SQL). The 2 are separete on the form. I am using VB 2010.
This doesn't work for me: objCommand2.CommandText = "SELECT ProductID, Name, Color, Size, ListPrice FROM SalesLT.Product WHERE ProductCategoryID = " & cbCategory.SelectedValue
I have another question (and anticipate that I will have about two more before I'm done with my class project). Here is my issue (and I'll copy and paste my code for clarification). I need to link up the control from the form on either side of the current form that I'm working on so that if I click on the buttons that I'm titling previous and next that I can click on the proper button and either go directly to the previous form or the next form. I was successful in doing this for two earlier forms on this project (with some direction from a couple of helpful people on this forum before), but for some reason, no matter what I details I use the controls do not connect to the previous and next forms.
Option Explicit On Option Strict On Option Infer Off
How can I access some of the Geo encoding for a website I am making?I would like to extract the location information of where the site is being viewed/used at. This would allow the check-in process to go more smoothly when the users do.
I'm creating a simple web browser. I have a combobox for the url address bar. I'd like the combobox to drop down and display the sites that have already been viewed. I think I can use the BeforeNavigate2 event to do this but I'm unsure how to use it.
I am looking to get a list of websiets viewed from the registry. I think the code below is fine but how do i populate a combobox with the typedurls it finds. I have tried myself but i still get blank in the combobox
Imports System Imports Microsoft.Win32 Imports System.Windows.Forms
Apparently, there is some kind of "bug" or "feature" in 64-bit Windows that prohibits a 32-bit app from "seeing" certain icons. Testing this is simple:Create a basic Windows Form app on a 64-bit machine.In the Project Properties, go to Compile > Advanced Compile Options > Target CPU. Set Target CPU to "x86".Add a button to your app that triggers an OpenFileDialog. Run the app and click the button to open the OpenFileDialog.Browse to: C:UsersDefaultAppDataRoamingMicrosoftWindowsStart MenuProgramsMaintenance
You should see the "Backup and Restore" shortcut, but its icon will be a blank white sheet. (If you don't see it there, it might be in C:Users[MyUser]AppDataetcetcetcMaintenance).
Now, close your app... go back to Project Properties > Compile > Advanced Compile Options > Target CPU and set Target CPU back to "AnyCPU" (this will cause it to run as 64-bit).Run the app and browse to the same folder. Now "Backup and Restore"s icon will be visible.This happens on all 32-bit apps. I tried it in Firefox (using "Open File...") and it can't see that icon (and many others) either. as a result of this behavior, when I try to extract icons from files when running under 32-bit, it produces an error. If I run the same code under 64-bit, it works just fine. running my app as 64-bit isn't an option. I'd literally quit programming if I weren't able to use Edit-and-Continue, and for some brilliant reason, 64-bit apps can't Edit-and-Continue, so I make them all in 32-bit).
Part of the app I am writing allows users to create an encrypted, password-protected output file that they can email safely to a central store. I can't have the users choose their own password for the encryption as the central store needs to access the contents of all the output files emailed to it. So there is one password that gets set within my vb app.I am worried that security will be compromised if the vb executable is somehow deconstructed? Is it possible to read the contents of an exe file (and thus find out the password)?
generally i'm trying to make a simple web broswer... my program has a button and a tab control. that when i click on the button a new tabpage is added to the tabcontrol with a web browser inside. now i have added a textbox for the url and another button that when i click on it the viewed web browser in the current tabpage is navigated to the url that i have typed in the textbox.
I'm developing an web application using VB.Net, and I would like to know, if is there any way to make a namespace to be viewed by all project without necessary Imports?
I want to be able to take snapshots of the desktop periodically(about 1 every 300 ms) then be able to view them live through a web browser.
Here is what I already have:
I already have a form which takes the snapshots, overwrites a file called 1.jpg with the image. I also already have an http server running which succesfully serves up html documents.[code]...
is it possible to have the open programs on my computer viewed in a list, and have the abbily to minimize and restore if so, what are the codes for it and what do i have to attach it ro (butten etc) it is for my OS i am making.
i have a dataset that i am viewing in detail view i can enter a new record and save it fine but the auto ID field enters as (-1) after i save it does not automatically change the (-1) to a number so i need to clear the dataset then refill it to give it a genuine number to prevent concurrency violations. my problem is after i refill the dataset it returns to the first record in the dataset not the last entered record, how do i get it to return to the last record.
I have a form called FrmPracDetails, which has details of practices and each practice has a unique prac_no populated on the form in the text box called TxtPracNo.Now, I have another form called FrmPayHistory. This form has a datagrid called DgvPayHistory, which is loaded with all the payment history of all practices. It has also a field called prac_no and stores the unique prac_no. What I want to do is, when a user is in FrmPracDetails, lets say prac_no 1155, then you open the FrmPayHistory. Only the payment history of that respective prac_no should be seen. Presently, it brings all the practices and their payment history. I have added a textbox (TextBox1) in the FrmPayHistory which links and displays the prac_no from FrmPracDetails with the following code; [code]
I have a form called FrmPracDetails, which has details of practices and each practice has a unique prac_no populated on the form in the text box called TxtPracNo.Now, I have another form called FrmPayHistory. This form has a datagrid called DgvPayHistory, which is loadedwith all the payment history of all practices. It has also a field called prac_no and stores the unique prac_no.
i tried to link "LoginForm.vb" and "Form2.vb" using databindings at "TextboxName" and "TextboxPassword" properties window to database access file, "Student.mdb" but i dont know how to make it to link between "LoginForm.vb" and "Form2" in "Student.mdb" got "NameColumn" and "PasswordColumn"
I am doing a project which required the website application that I have created to be linking to the window form. As what I know is in the webform to webform, the command is "response.redirect("")" whereas for the window form to window form is "me.show form1.hide". So that is what I know.
i have a database that I created, and I also have a form I created, example database has Flower type, my form has a section for flower type i want to link it so that I use the form to add or change or edit my database using the form.
i have a webbrowser1 which cannot navigate from the link it is set up to, and cannot open new links in other windows, i need something like if get the URL Google.com when it clicked a link on the current site, then Form2.Show(). Link here <-- when clicked open form2 if its yahoo opens form3.
Every time I click on download file link, instead of the internet explorer download file dialog to come up, show my second form and in it's textbox place the download link. I have been searching for this for a long time.
