I am working on my new project and I need to create a table for each user dynamically. In which the user will provide the Table name in the textbox and on pressing Create button a new table gets created in the same MS access database file with the provided name.[code]...
View 17 RepliesI am trying to do a home project and after many hours of failing to complete what seems to be a simple process I have decided to ask for some help. None of the examples I have found on over 20 websites is complete or works as the author suggests. (Im sure because of version differences)
I want to make a Visual Basic Program that, by means of clicking on a radio button and then clicking on a button named "create" will add a blank table to my db named by the string variable connected to a listbox where this name can be first entered before clicking on button1. Can someone help guide me in the right direction? The table needs to have three columns; Col1, Col2, Col3 -my database is named "Database.sdf"
Form/Interface info radiobutton1 'an option that if selected = true in the button1 click event will process the data that creates the table. textbox1 'table name input button1 to create table 'to run the process combobox1 'shows available tables that exist in the db button2 'click event shows the combobox (table) in the datagridview window button3 to delete 'to delete the selected table button4 to reset 'to clear radio button choice,textbox1, and combobox1 datagridview1 'to veiw the selected table Note: if also possible I would like a datagridview of the new table on the same form after it has been created.I am using Visual Basic 2008 Express, It is a microsoft SQL Server Compatct 3.5 Database
I want to create a table (called "Customers") in a Microsoft Access database and then insert/delete records into the table and update the table. The table shall have 3 columns:
ID
Customer Name
Customer Address
I know i need to make the "ID" column as an autonumber and a primary key, as i need to insert and delete records and update the table. I am using the Visual basic 2008 Express edition and quite familar with the OledBcommand.
I want to create an access table at runtime. It happens that my table has to change, this means that i need to alter some or all of the fields. I need to be able to do this at runtime. I am using the following code, but it does not seem to work. The last field has to be an Autonumber field.
Private Sub CreateLessonPlan() '' Create table if it does not exsist
If con.State = ConnectionState.Closed Then
con.Open()
End If
Try
' Drop the Employees table if it already exists.
[Code] .....
Is it possible to alter the structure of a table that already has some records in it?
I have th is little programm:
Dim dbOud As ADODB.Connection
Dim rsOud As ADODB.Recordset
Dim strCnnOud As String
[code]....
I am trying to make my program print out a requistion slip but I don't want to make a report using VB b/c sometimes the printer is not connected and it is better to have a Microsoft Word document and save it as such. So how do I create a Word application from VB? I basically am going to set out a format, make a small table etc. and then whatever the user types in the textbox, it will appear in the slip. (I am using Word 2003)
View 1 RepliesI am working on a VB2008 Express application that makes used of the office interop access. The exact code is:
[Code]...
I have a form that reads the data from the database table ( so you can see I have figured out how to attach to a databse table)On the form I can scroll through the data with use of the binding navigator that VB automaticly installed on the form, but I need to search the table for specific data in one field.I am guessing that one way is to use a query, but I can't figure out how to use one.I realize that this may be real simple, but because I am just learning VB, I don't know where to start.
View 4 RepliesI have a 20 x 20 Excel table that I want to transfer to a numeric array in VB 2008 Express.
View 1 RepliesI'm trying to connect to an Access table who's name includes spaces ('look Material Type').How do I identify this table in an OleDB string
View 2 Repliesso far i have this for my code:
Using myConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & databasePath & ";User Id=admin;Password=;")
[Code]......
This did not work but did when i just tried creating the table and not the fields.
The application I'm working on requires that I print out some tables without having a datagrid present.Is there a way to print the tables to a printer using the PrintDocument object or does have to be done another way?
View 6 RepliesI want to create a new MS Access database table using ADOX. On this page, is code in VB.NET, but obviously it's not working in C# (when I want to "convert" the code). I'll be grateful if someone converts it correctly.
View 2 RepliesI wont to be able to check if a table exist, if not i wont to create it...
This is the code i use for connecting...
Code Block
Im working on a prog for my work. however, im stuck. I come to a spot where i need the prog to copy a sample table to an existing database. we can either simply copy the sample table, or as a last resort, create a new one from scratch.
View 6 RepliesI have the code I am using below. On 3.5 framework Access 2003 database vb net 2008
I already have the database created but need to be able to add Tables and fields with the correct datatypes. So far it's not working but i don't know why or where the error is.
Private Sub MDIParent_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code].....
I'm quite new into the programming game, I've been working on this program for a few weeks now, and its coming along, but the method I searched for entering new rows of data into my table doesn't seem to update my tables after I try entering data. I have a feeling it may be something very simple that i am over looking.
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Handles Button4.Click
Dim conn As New SqlConnection("my datasource")
[code].....
I have made an Access database complete with a report/form UI, however I am now looking to take this further to Visual Basic. In my Access database I have a log-in form to access some secure reports. I am now trying to do the same thing in Visual Basic, with no luck. I have created the UI elements i.e. buttons and text boxes, but am now stuck at how to implement the code.What I want to do is make the login button check what's in the username/password boxes with a table in my Access database.
View 1 RepliesI'm trying to create table in my database, that would have name like i type in Textbox and than i have to click the button With code like this :
sqlCmd.CommandText = "CREATE TABLE NAME = '" & TextBox1.Text & "' (First_Name char(50))"
I'm getting erorr : Incorect syntax near "name that i type"
I have previously created a DLL in VB6 that I then used in a Microstation VBA program. But now cannot create a DLL with VB 2008 Express that works. I am trying to create a simple test DLL. The DLL appears in the Release directory of both the Bin and Obj directories but when trying to register it I get the following message "Can't find DLL entry point in TestRun.dll". Is it possible to create a working DLL with VB Express or do I have to "upgrade" to another "version" of VB.
View 14 RepliesDoes anyone has a sample code that do like,Open and select excel file and select the exact excel sheet to import then connect to SQL server 2008 and append all the data from the certain sheet to the SQL table?
View 8 RepliesIs there any difference in using the GUI in VB2008 when creating database tables in SQL SERVER or Access. ? Using the Database Designer
View 5 RepliesI'm stuck when trying to create the simplest partial class in order to access a table property. I have a LINQ auto generated DataContext with:
[Code]...
I am trying to create a DLL file in VB.NET 2008 Express which will can be called from a VBScript file. I have set up a Class Library solution but when i try to register it I get the following error.
"The module ... was loaded buy the entry-point DllRegisterServer was not found."
how to create a new mdf file in express 2008?before, I used some sample projects which have the mdf file, so I can use sql express on local machine. now, for a new project, I want to create a brand new mdf file, but can not figure out how to do it.
View 12 RepliesI have a couple of Excel macros that are working exactly as I want, and I would like to load them on other computers that may have different versions of excel. I have VB 2008 Express, and I was hoping I could use this to create the add-ins, but I am unable to find the Add-In wizard. Am I overlooking it, or do I need some other version of VB?
View 3 RepliesI'm creating an application and I want to pass on a string value from one form to the other.Is there an access modifier in VB 2008 EE that would allow me to do that?Example: I have a name such as Mike in one form, in a list box, and Mike has a file attached to it with different information.I then click on a button to load another form, where the name Mike will be passed on and will be used by my program to find the file and display all the information in the file of his name.
View 2 Repliesconcantenate rows from my ms access database using vb.net. I have a table in ms access where there are contacts of clients, so now i want to seleect only mobile numbers of all clients and then concantenate them seperated by deliminated commas. give me all the mobile numbers into a single row/line seperated each number with a deliminated comma. I have tried different methode but it gives my endless errors. Amongst other things i tried to bind the mobile numbers in to a listbox so that i can loop through and insert all the number in the textbox seperating them with a deliminated commas....that does not work it says "Operator '+' is not defined for type 'DataRowView' and string ";".
This is the code i have used:
Dim address As String
' Dim n As Integer
For i As Integer = 1 To Mobile_PhoneListBox.Items.Count - 1 Step 1
[Code]....
I am trying to store data to access by VB 2008 express. basically, I have 13 check boxes to let the users to choose. when they finish checking the boxes, they will click the button "submit" to submit it. VB will store this as a new row in the database.
However, my insertcommand is shown as invalid. so I need your help to figure out my errors. I put the codes in my reply below to be clear.
i have successfully connected VB2007 Express edition to MS Access 2007 but i don't know save the newly entered record into access database from the VB interface.
View 3 Replies