im having a sql problem for reporting here. here is the table[code]....
i would need to have a column ParentLocationName that directly shows the name of the parent's location as below:
---
AssetNameOfficerInChargeIDLocationIDLocationNameParentLocationName
IPODSusan6Room 1Building B
Sony PS3Fred5Partition 1Building A
is there a way to pull the parent's location name in one sql syntax?
I have a database with two tables in it: People and Logs.I have created a Details page that displays Person information and additionally includes the associated logs records. All of this has just been done by adding a standard details page - not custom coding, etc.When a user clicks on the green + to add a row to the Logs for that person I want to autopopulate a few of the columns. To do this I've opened the Log class and added the following:
Private Sub Log_Created()
Me.Create_Date = Date.Now
End Sub
This works great. But I also want to pull in the card number associated with the person. In the end my code should look something like (pseudo):
Private Sub Log_Created()
Me.Create_Date = Date.Now
Me.CardNumber = SelectedPerson.CardNumber
End Sub
However, I'm not sure exactly how to accomplish this in code?
I try to update my data into Access using VB but I got the following error "Syntax error in UPDATE statement." [code]
View 4 RepliesI build a command.text that looks like this.
UPDATE a_list Set NOTE = 'This is text in a memo type field.' where index = 2;
I get the error --- Syntax error in UPDATE statement.
The provider is jet and the table is in an ACCESS MDB. I get the same thing on a DBF file.
So im writing a program, basic enough, to allow a tutor to enter student marks into a database and edit them and navigate etc...on my form that displays my database information, when i click on the update button im getting a syntax error. "Syntax error in UPDATE statement." Code below :
Code:
Public Class frmDatabase
Dim iResponse As Double
Dim con As New OleDb.OleDbConnection
[CODE]...
I keep getting this error "Syntax error in INSERT INTO statement." on this line "da.Update(ds, "Llenar")" when i try to update a microsoft access 2003 database with this app.
Code:
1.Imports System.Data
2.Public Class A�adir
3.Dim coneccion As New OleDb.OleDbConnection
[code]....
I am trying to work with an access database. If this line pulls data from a dataset and puts it into a textbox: TextBox1.Text = Me.A_DataSet.a_Table.Rows(0).Item(0).ToString How would I pull the field name? For Example, in this database I have 3 fields:
[Code]...
I need my program to connect to a database within my application i.e.What I have:
m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = C:Documents and SettingsmeroneyfMy DocumentsVisual Studio 2008ProjectsAsset Manager 2008inDebugDatabaseAssetManager.mdb"
What I need is: m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = DatabaseAssetManager.mdb"
I have used:System.Windows.Forms.Application.StartupPath & "ImagesSystemDefaultImage.bmp"
for loading of images within the default directory. but this returns the app path but also includes "System.Windows.Forms.Application.StartupPath" in the string?
Here is a code to insert data to DBaccess from textbox. When I write a colon(') in the textbox to add to DB it caused error and show me this Message "Syntax error in string in query expression '''')'
Code:
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "Store.mdb ")
Dim cmd As New OleDbCommand
cmd.Connection = conn
'Add text to DB
[Code] .....
I'm trying to make a program with transparent labels over pictureboxes and when I set the label Parent to the PictureBox the position of the label changes.
View 2 Replieshow to set location of child form to a specified point of parent form.Below is my code but it is not working for setting the location.[code]
View 1 RepliesI have a parent form that has a combobox. Whn the form loads I get the data from the db and bind to the combobox. that works fine and here is the code I use in form load to cause this to happen: [code] Now if there is not an Account Type, I have a button that will pull up a small form to allow the addition of an account type. The popup form adds the data back to the database just fine, but I am now trying to get the combobox to refresh its data. So I call a public Sub that is located in the parent form to from the popup form to accomplish this task and I have walked the code and the sub is called and appears to work correctly, but the new data never appears in the combobox. Here is my public sub that i call to try and refresh the combobox on the parent form. [code] But when I go back to the parent form, the combobox is not updated with the new account. How can i get the combobox to refresh from the database with the new data?
View 4 RepliesThis is a challenging one that got me stumped while I was coding today. Suppose I am running the Sub Test1() and Test2() and would like to print out the value of the Shadows method of the instance of the object I am passing in to TestCall() (see below - it is clearer) using the following restrictions:
Can't change the contents of Class A, B, and C
Can't change Sub Test1() and Sub Test2()
TestCall() can't have an if, select case etc. statement that tries to figure out the type
[code].....
I have a main form, and some sub forms, and each sub form can have some sub forms. When I have multiple sub forms open, and I try to get data from the parent form, it returns the data from the wrong parent form.For example I have two instances of Mainform.subform running. If I do something like this in a child form of one instance of the subform. It returns data from the other subform.
dim l = Mainform.subform.listofdata
Edit:I am using visual Studio 2008. Winforms, form designed using designer. In my mainform I am doing this
Protected Friend frmMain as Mainform
frmmain = new mainform
In frmMain I am doing this
Protected Friend frmsub as new Subform'
frmsub = new subform
[code]....
I would like to know if there is some simple code to release a child control from it's parent control, without having to name the parent control. In pseudocode, I'm looking for something like this:
[Code]...
I am having an issue trying to figure this out. I am writing a script editor that uses tabs (a tab control) and I want to implement syntax highlighting. My issue is that every sample I can find on syntax highlighting uses
Private Sub RichTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RichTextBox1.TextChanged
i am using an unbound datagridview so i can dynamiclly add rows. all that is working fine. but the grid is not is the location i have coded.. i am using the defualt form as a base then coding the unbound stuff in.. should i just create a blank class file and do everything? the only problem i am having is the grid must bees in the correct location according to the pixel point that i have given it. Right now it is placing the grid at point (0,0) no matter what point is entered on the line for location. so what am i missing??????
View 3 RepliesI got a error when I run this code:
Dim btch As String
Dim LeftPart As String
[CODE]...
It says index and location must refert to a location withing string
dim cn as oledbconnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:valid.mdb")
[code]......
I have 2 group box components and both are same size,font,location and visible is false. When i click button2, the groupbox1 won't appear(the group box2 is on bottom n group box1 is on top).
Example:
button1
groupbox1.visible=false
groupbox2.visible=true
button2
groupbox1.visible=true
groupbox2.visible=false
Because i want to show the different,so the location have a little different(actually both are same location). I think my code is no problem. The problem i guess is both component cannot locate at same location?
we have a user that my program works fine for.. and another that it just crashes for.. they get this error
"You cannot start application <App_Name> from this location because it is already installed from a different location."
then they run it up again and it comes up.. and then just closes..in reading some stuff online it says its a framework 2.0 sp 1 issue ?these pc's have 3.5, but my program uses all 2.0 stuff..so is this a 2.0 sp level issue ? or should I make my programs start to use framework 3.0 instead ?
I was using this old method of creating a bunch of rectangles when I need to get the location of a certain point within a grid so I could draw images on the grid. The thing is, I don't want to use rectangles, I want to be able to just round the location as if I were using rectangles. I need it to be able to round the point (66,70) to (50,50) so if you can imagine a grid and the mouse position being within that square in the grid, I need to get the location of the upper left corner of that square.
View 5 RepliesI have encounterd a problem when trying to re-enstall a program i have writen in vb 2008.I get the following message:"You cannot start application Shell from this location because it is already installed from a different location."This program is to be used on many workstation computers and i need to be able to update any changes by just reinstalling the program, no uninstalling needed first. If the program was installed from a cd first and needs to be updated from a flash disk this error will be a problem, if the update is from a cd as well then there is no problem.Is there a way to change the installation package to ignore where the program installs from and just update itself?
View 2 RepliesI'm currently working on a project that has a simple game . I want to change the location of a label ( middle ) to another location when a key is pressed down. But there is something wrong with the first of the If statement .I've underlined "point " because it has the error.
Private Sub Space_Navigator_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown If e.KeyCode = Keys.Up Then If middle.Location = [u]Point[/u](156, 655) Then middle.Location = New Point(156, 547)
End Sub
i need to developer project from vb.net to vb 6.0 and i have already project in vb.net and i have to convert in into vb 6.0 but i need same GUI format,but i get problem that is in vb.net control height and weidth is in pixel formate and there is vb 6.0 i dont know so i copy control's height and weidth or size so i got there is difference in vb 6.0 so any one have idea how to convert vb.net location pixel to vb 6.0 location format .
View 1 RepliesI'm trying to copy a picture from one location and paste it into another location however VB throws out the following error
Exception from HRESULT: 0x800A0046 (CTL_E_PERMISSIONDENIED)
both locations are on my local computer. So not sure what is causing the problem.
Here's the code
Module CPASU_SPC
Sub Main()
Console.Title = "MOARW Programs"
[Code]....
Can any one translate the following syntax to vb.net.
m_TextBox.Loaded += TextBoxLoaded
m_TextBox.Loaded -= TextBoxLoaded;
private void TextBoxLoaded(object sender, RoutedEventArgs e)[code].....
I have a listview "CategoriesList" and i have a repeater "NewsRepeater" inside the listview "CategoriesList"
<asp:ListView ID="CategoriesList" runat="server" DataKeyNames="CatID" DataSourceID="CategoriesListODS"
EnableModelValidation="True">
[Code]....
how to pass the catID from the listview and make it as SelectParameters in ObjectDataSource "NewsRepeaterODS"?
How to copy folder with its content from location to another location defined by FolderBrowserDialog
View 7 Repliesi have this code:Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
Error 1: Option Strict On disallows late binding.Im using visual basic 2010 express on a gateway laptop thats running Windows 7 OS How do i resolve this error?