1,557 Topics

Member Avatar for
Member Avatar for jontennyeah

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. …

Member Avatar for jontennyeah
-1
141
Member Avatar for HassaanJalil

**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**

0
143
Member Avatar for samirkhzem

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 …

Member Avatar for Reverend Jim
0
321
Member Avatar for ImZick

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 …

Member Avatar for Reverend Jim
0
228
Member Avatar for kayjenx

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 …

Member Avatar for tirror69
0
196
Member Avatar for ImZick

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 ='" & …

Member Avatar for ImZick
0
171
Member Avatar for adem87

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 …

Member Avatar for ddanbe
0
161
Member Avatar for vprakashit

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>

Member Avatar for <M/>
0
137
Member Avatar for sundog1

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 …

Member Avatar for sundog1
0
332
Member Avatar for izzywizzy

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) …

Member Avatar for IIM
0
177
Member Avatar for Skipind

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.

Member Avatar for savedlema
0
297
Member Avatar for sundog1

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 …

Member Avatar for ChrisHunter
0
183
Member Avatar for sundog1

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 …

Member Avatar for sundog1
0
207
Member Avatar for ImZick

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 …

Member Avatar for Begginnerdev
0
202
Member Avatar for Joe2

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 …

Member Avatar for BigPaw
0
211
Member Avatar for joshl_1995

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 …

Member Avatar for pritaeas
0
365
Member Avatar for joshl_1995

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...

Member Avatar for pritaeas
0
265
Member Avatar for JUGS446

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 …

Member Avatar for barunsen
0
6K
Member Avatar for sciwizeh

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 …

Member Avatar for sciwizeh
0
5K
Member Avatar for jealii.jealii

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 …

Member Avatar for Begginnerdev
0
2K
Member Avatar for DeanMSands3

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 …

Member Avatar for adam_k
0
771
Member Avatar for jealii.jealii

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?

Member Avatar for adam_k
0
415
Member Avatar for dhani09

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 …

Member Avatar for dhani09
0
212
Member Avatar for Baradaran

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 …

Member Avatar for Baradaran
0
233
Member Avatar for end3r

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 …

Member Avatar for JorgeM
0
6K
Member Avatar for slymdjay.gunshot

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 …

Member Avatar for phorce
0
567
Member Avatar for krunal1986

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); …

Member Avatar for krunal1986
0
654
Member Avatar for maurice91

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. …

Member Avatar for Lethugs
0
203
Member Avatar for vijaycare

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 …

Member Avatar for john.knapp
0
465
Member Avatar for joshl_1995

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. …

Member Avatar for pritaeas
0
290

The End.