1,557 Topics
| |
I have a 3 columns in my MS access database namely ID, Name and Type. The Types are Driver, Conductor, and Inspector. I want is i click a button, all names in column "Name" that is classified as Driver will be the items of my combobox, also the other two. … | |
**I am building a hospital managment system as a practice in visual basic. I am having some problem I want to write or read data from particular row or column with visual basics How do I o it? Thanks in Advance -Hassaan bin Jalil** | |
just want to know the correct synthax for creating a table in access database using vb myqry = "CREATE TABLE HoldInvoide'" & k & "'(Barcode varchar(20) not null Primary Key, ItemName varchar(40) not null, Quantity int , Price double, Total double)" k is a variable i want to create a … | |
i need some help how can you save the item in my textbox to the access database? For example i have Firstname.Text Middlename.text Lastname.text if i click the add button it will save it to my access database and also if i want to edit it and update it, how … | |
I've been battling with this for the pass few days. I have an access03 database that is used to track training that we give to employees. i had a form that has, the training info and then a subform that lists all the attendees and their scores. Now I was … | |
Hi i wonder how can i delete my data using access as my database? for example i want to delete Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & ConAccessDatabase & "';") Dim cmd As OleDbCommand cmd = New OleDb.OleDbCommand("delete * from [" & EBU2DB_LOB & "] where Brand ='" & … | |
string location = Environment.CurrentDirectory; string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + location + "\\harita.accdb"; // get records from the Shippers table string commandString = "Select x from map"; //create the data set command object and the DataSet OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString, connectionString); DataSet ds = new DataSet(); // fill … | |
i am tyring to create new project nemmed as car parking system please help to get the password and check the name in database and display the already gathered displays ........please help me ...........<snip> | |
Hi guys, I'm hoping you can help here with a problem I am having with regards to filling a Dataset. It was working fine but have had to amend the code to read a different data set and structure. Basics are 2 tables.. one customers, 1 orders. Joined on there … | |
Hello! I am currently developing a web interface that has access to an MS ACCESS database. However, I am unable to key in more than 6 Values into the database using the INSERT INTO sql code. Here are the codes that I am using: protected void bnAddPart_Click(object sender, EventArgs e) … | |
connecting access 2003 database from remote computer .I have a vb2005 application which uses access2003 database. I want to connect to this database via remote computer connected via internet. | |
Hi Guys, The reason for my message was to do with UPDATE and DELETE Statements from within C# when contacting a MDB file. I currently have the INSERT INTO SQL Query working perfectly The Code I used for this is below: else if (radioButton2.Checked == true) { //Creates new versions … | |
Hi Guys, Right... I've managed to run select statements with associated Joins to show the data I want in DGV's which is great. Seems to be working fine. I'm not to the point where I need to be able to Insert, Update & Delete Rows in my Database. I am … | |
Hi guys i have this code which insert the data in the textbox Dim FilePath As String = "C:\Users\ezekiels\Desktop\New Folder\EBU 6.mdb" Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & FilePath & "") conn.Open() Dim myadapter As New OleDbDataAdapter("SELECT * FROM Table_EBU6", conn) Dim dtset As New DataSet myadapter.Fill(dtset) myadapter.Dispose() Dim table … | |
I have just tried to access http://blog.seorevolution.com/2013/01/24/5133/ and get the following: Forbidden You don't have permission to access /2013/01/24/5133/ on this server. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_perl/2.0.5 Perl/v5.8.8 Server at … | |
Hello Community, I was wondering if there is a way to access SkyDrive using php i have looked at so many forums and i could not find anything and what i did find was too complicated to understand, what i want is a way to create files or folders, get … | |
Hello Community, I was wondering if i can get some help with the 4shared php api. [Here](http://www.4shared.com/developer/docs/samples/#PHP) is a sample on how to upload a file. But now i need to know how to delete a file, by the way i have never used an api. Please Help... | |
Hey guys, I just got a HP Pavilion dv6000 a few weeks ago with Vista Home Premium already installed on it. Im having some trouble getting my wireless connection to work. It worked once for a few hours but then just decided to stop. When I plug in my ethernet … | |
My project compiles fine, but when running a push_back on a vector, I'm getting an access violation when the vector attempts to resize itself. I have lots of code, but hopefully I can boil it down to just relevant classes. I am sorry about the HUGE amount of code, but … | |
I have a volunteer database and having trouble with genuine password protections. I have a "delete" button with this current code under Build Event: Private Sub delete_Click() On Error GoTo Err_cmdDelete_Click DoCmd.SetWarnings False If MsgBox("Delete this VounteerRecord. Are you sure?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes Then DoCmd.RunCommand … | |
I have a calculated field that takes the ID field of a table and pads it with leading zeroes. So far, I've gotten this to work: `String$(4-Len(Trim$(Str$([ID]))),"0") & Trim$(Str$([ID]))` Broken down, it takes the ID field, and string-ifies it. For some reason, this pads it with a space, hence the … | |
I'm creating a password protected Volunteer Database and everything is going well. I have created a 'password protected' form before entering the hidden database(seperate form). How though am I able to prevent a 'user' to find out the password by going through "Build Event" in Access? | |
Hi, I have a database (OLEDB) on which i perform operations like insert, delete and update. When i carry out these operations, the changes are reflected in the database during runtime but when i close the form everything goes back to normal. How can i get these modifications to relfect … | |
I am totally new to vb.net, still I am planning to try it for a project, in which there will be standalone machine using an access database to query and update different tables. While in VB6 I was able to define recordsets using Microsoft.jet.oledb.4.0, in VB.net I have become a … | |
Hi, I am not sure what is the best solution for my problem so I really need your advice. Here it goes... I have an intranet setup at work and I am acessing a web app from let's say IP 192.168.0.40. The intranet computer from which I am accessing it … | |
Hi geeks!! im working on a project (in visual studio 2008) where i need to create a reminder which will prompt every month for showing the actual state of fees a number of customers have left to pay. the project uses access as database and will have a fixed amount … | |
hi all, i am sending mail through exchange server version Exchange2010. below is my code: static void Main() { try { string owausername = string.Empty; string owapassword = string.Empty; string mailFrom; string mailTo; string mailSub; string mailBody; ServicePointManager.ServerCertificateValidationCallback = CertificateValidationCallBack; ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2010); EmailMessage email = new EmailMessage(service); … | |
Hi, I have a Vb.Net solution that contains several forms that read/write to an MS Access database. My problem: When I copy my Vb.Net solution and Access database to a new computer, the data source connection string needs to be changed. Currently the data sources wizard sets the connection string. … | |
Hi All, I would like to thank this community for the enormous help to develop my skills. Thanks. I have 2 databases and a single report form and a crystal reportviewer. The User can select the database which he want to work (Each of them belongs to different warehouse) So … | |
Hello Community, I was wondering if there is a way to restrict sub directories from accessing the parent directory (the main directory where all my website file are stored) and from having any interaction with the previous folders (so once there in the child folder they can't leave it eg. … |
The End.