Linking 2 Database In 1?
Aug 12, 2009I got 3 tables in database namely A,B,C. how am i going to link the column a in A and column b in B to table C so that table C can have both my data a and b?
View 3 RepliesI got 3 tables in database namely A,B,C. how am i going to link the column a in A and column b in B to table C so that table C can have both my data a and b?
View 3 RepliesI'm creating a system (for a project) that is based on a vet.I want to create a combo box that has a list of different animals (e.g. Dog or Cat etc.)and when an animal is selected,a group box, with loads of checkboxes inside appears. Then the user can tick a check box (a vaccine to be given to the animal) and the record is saved to a database.I have hard coded this to work, but I want a more sophisticated code set, that links to SQL so that when a new vaccine is to be added, I would only need to add it in a table, in the database. I don't know where to start for this could any one give me a nudge in the right direction?
View 2 RepliesI have a database (sql server) where i store activity information example (activityid,id,summary,signs etc.) I can successfully save this information to the database. what I also want to achieve is to add this information to a listbox so that it can be displayed in the corresponding textboxes at runtime for an encounterid.
View 6 RepliesHow do I go about linking a picture to a database? I'm using VB 2008 Express and SQL Express.I want the user to click a button when editing a recipe; the button click will then open some kind of dialog where the path to a picture will be selected. Then a button on the dialog will be clicked by the user and the picture will be saved to a folder in My Documents called "My Recipes" at the same time the recipe will be renamed using the Title and ID of the record being edited ending up with a name like "Nick's Milktart 237.png" (preferably with a space between "Milktart" and "237"). Also at the same time a link to the database must be created to a field called "Picture".I have never tried linking pictures before, I understand the app. will respond much faster this way as to imbedding the picture into the database.
View 10 RepliesHaving found the following post on datareaders Topic Posted On DaniWeb i have managed to successfully create a datareader in a class that updates a listbox on the calling form with entries retrieved from a SQL server database.I was wondering if it is possible to achieve the same thing using a dataset?My ultimate aim is to read a SQL table / view of information (ie customers), add this into a list box so that when i click on a specifc line in the list box i can then use that selected entry to do something further (ie click a line and then an edit button to edit that records details)[code]
View 3 Repliesi having trouble in linking a database which contains name ,address, etc and most importantly the signature for each individual to vb.i know that microsoft access is used in linking those database to vb, but couldnt get the signature part to be done.
View 1 RepliesI want to connect to a database Ive created using Microsoft Access 2007. Im using Visual Basic 2005. I also want to be able to perform basic tasks such as searching.
View 1 RepliesA friend at work is trying to write a piece of database software for an HND project and when adding his database file, he gets the below error message. I'm too much of a greenhorn to know what it means, can anyone make sense of it?
View 1 RepliesI'm trying to link a datatable from one access db to another access db but i get this error:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.[code]...
I have already linked the file into the form, but can't figure out the code to write for buttons to beable to view the first record in the database in the file that i linked. I need to make buttons to find the first record, last record, previous and next record. Then I also need to code buttons to add, change, and delete records.
View 4 Repliesi had created a form with datagrid view , in that a table is linked with MS Access database , i need the coding steps in vb.net
View 2 RepliesThe Calendar control (the Month Calendar) control in VB 2008. I am creating an attendance timesheet and I want the Calendar to color each date differently like e.g An employee Paul is selected from a list.
On the calendar I select the month. (The dates are not supposed to be selectable). Then lets say it is June. He is late on the 1st and the Second, so those days are supposed to be colored red (the whole block). Let's also say he is absent on the fourth and so I want that date to be coloured black. How do I do this? I tried finding a query and my friend told me that this functionality is not available in the current control and that I was best off making my own control (???).
I have tried selecting specific dates and bolding them (there is a function that allows this) but I am stumped trying to find two different ways to differentiate colours. Second:- How do I link a calendar with an Access Database?
After trawling around the net for a good few days, i decided to post something here.
Basically, i've got a problem linking a data source (Access 2007 database) to a VB 2008 project.
I've broken it down to having a problem dragging a table onto my form, when it generates the nav bar, it says "0 of {0}", and the table is empty (despite the actual database containing values)
However, this happens only at home, at college it works totally fine. The only difference that's obvious is that i'm using Windows 7 at home, and Windows XP at college.
I am working on a project that requires us to create a bracket type tournament and I am now stuck. I linked my access database to my project, and have 32 labels (lbl1-lbl32) and I cannot figure out how to integrate the labels to read from my database. It can be random or not, I just cannot get the labels to display the names of the fighters.
After the labels are integrated, the next coloum of the bracket has a link that opens a new window with each of the fighters match results, does the link have to include anything particular to display the attributes from the database?
I am currently doing a project which is to be linked with another project. I.e., when I click on some button in my current project's page I should get a page from the other project..
View 2 RepliesI have an e-mail that i send out and everything works fine exceptthe hyperlink doesn;t link.
taskMessage = <a href="C:\Program Files\Microsoft Office\OFFICE11\powerpnt.exe"> Powerpint </a>
myEmailClass.SendEmailMessage("myemail", "your email", "You have a new stalker",
[code].....
was just wondering if it's possible to link up excel and vb so that data can be inputted into vb and then transferred to excel which would carry out calculations using functions and send the data back.
View 2 RepliesI'm trying to do is access a DLL that is outside the original EXE's file structure. So like this
C: estexe estexe.EXE 'The EXE that needs to access the DLL
C: estdlls
eturnstring.dll 'The DLL I'm trying to access.
So far everything I've tried has failed. I keep getting a FileNotFoundException.
I've added the following code to my app.config
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
[Code]....
I've recently decided for my VB final that I'd like to tackle something my professor and I discuss constantly; portable game server apps.
What I'm wanting to do, essentially, is create just a rudimentary programme that allows you to check the server status of either the north American or European servers for the game Rift and just (instead of opening your default browser, which I know how to do already) displaying the info in a listbox inside the programme itself.
The information I have to work with (aside from the obvious direct .php link to the web page) is two separate .xml links that contain all the information that is contained on their webpage. I could easily just turn these .xml files in an access database but I want something dynamic rather than static, but I honestly have no clue of how to turn this info I have into something I can actually use in my programme lol.
Individually the Draw red and draw white work. The delays work.When in series the only color seen is the last color. Why? [code]
View 5 RepliesWhat are the main functions needed to create a .dll file in vb.net which needs to be Explicitly linked i.e at run time to an application Plz post me an equivalent code snippet in VB.Net
Explicit run-time linkingDLL files may be explicitly loaded at run-time, a process referred to simply as run-time dynamic linking by Microsoft, by using the LoadLibrary (or LoadLibraryEx) API function. The GetProcAddress API function is used to lookup exported symbols by name, and FreeLibrary — to unload the DLL.
[Code]...
i've been searching everywhere to try to get this setup. I am running Visual Basic 2008 I have 1 Combo Box that Has 3 Entries, Kyocera>Konica>Toshiba I have a 2nd Combo Box that has entries for each of those manufactors ...Kyocera has 3035,4035,5035....the konica has c250,c352,c452......the Toshiba has c3520, 4520
[Code]...
i've been searching everywhere to try to get this setup. I am running Visual Basic 2008 I have 1 Combo Box that Has 3 Entries, Kyocera>Konica>Toshiba I have a 2nd Combo Box that has entries for each of those manufactors...Kyocera has 3035,4035,5035....the konica has c250,c352,c452......the Toshiba has c3520, 4520
I want it so when i click on Kyocera the 2nd combo box only reads 3035,4035,5035 and when i click konica it only reads c250,c352,c452 etc etc
I have created a form in VB 2010 and I want a executable file (.exe) to open when the user clicks on that button. What do I need to do to accomplish this?
View 2 RepliesI have several resource files I would like to be able to access in my Visual Basic program by using code. I have added them in folders in the projects folder, and have also chose the "Include in project" option for them all. However, I am a bit confused when it comes to the correct format for linking them with the code. I didn't think using a full path (starting from the C: drive), then linking to my main project folder, would be a good idea since when the end user installs it, the path would be invalid. I tried to type the path like this: "ResourceVideoABCImage000.jpg" however, I receive an Invalid Parameter error. The only way to make it work is to enter the entire path name.
View 2 RepliesI have one main form and another dialog box that is used to search records. What code is used to declare a public variable in the dialog box form in order to get the record found by the user displayed back into the main form?
View 4 RepliesI need to link different arrays of data that I am gathering from different Select Cases.For Example:Araray A, B and C from Case 1Array C, D and F from Case 2 Note: Array C is common between two cases.I know in C++ I could have used Pointers and use SQL in Java.
View 1 RepliesI have two forms. In form 1, I have a textbox1 and in form two, I have a textbox2 and a button1. Now what I want to do is, write in textbox2 (That is in FORM2) and when I press the button, it just go to textbox1 (That is in FORM1)
View 3 RepliesI am new to vb.net. I am currently programming Space Invaders. Firstly i have two forms What is code for linking form 1 to form 2?
Secondly i have coded and tried to understand arrays. I currently Have
Private Sub tmrUFO_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tmrUFO.Tick
[code].....
How could I link a Listbox to a Textbox? So each Listbox item holds string data, and when I click that Listbox item, it shows it's string data into the multiline Textbox. For example
I have a listbox item names "Numbers". It holds this data:
1
2
45
84
So I want it to when I select this item in the listbox, it display the number data into the multi line textbox. How would I do this?