Im currently doing a project which is a system that adds booking records to it
it loads the database from a module
Set Db = OpenDatabase(App.Path & "cihansol.mdb")
Set RS_Staff = Db.OpenRecordset("EPHS_Staff")
Set RS_Customers = Db.OpenRecordset("EPHS_Customers")
[Code]...
I need a code that once u select a field and click delete it removes it from the database.
I'm trying to delete an entry from my database, i have the code written to display the details in a listbox but now i need to write the code do the user can select the item they want to delete and then click the delete button to delete it? I just want to flag it as deleted not get rid of it completely from the database?
View 5 Replies[code]....I have a dialog that comes up and asks for a reason for declining the business.I don't want the code to move on after not enabling the "me" until the reason has been entered and saved into the database. Also, at that point where it says "I WANT...." I want to copy the textbox fields into a new database and then delete this entry from the database, how can I do that. I am using VS 2008 and SQL.
View 2 RepliesI want delete all files in a folder, but I get access denied as the file is locked.I use an email function before i'm trying to delete the files, the send email is a built in function of the application:fcMailer.SendMailWithAttachment Process.Company, "email", Subj, "Bo", "e:upload est.xls" i tried to set it to nothing: set fcMailer = nothing and set fcMailer.SendMailWithAttachment = nothing I'm using the below to delete the files
[code]
Const DeleteReadOnly = True
Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.DeleteFile("e:upload*.*"), DeleteReadOnly
[/code]
How do i remove connection holding the file or simply just delete all locked files / or not locked?
I am using Visual Basic 2008, and I am making a simple meeting planner program. The data stored for each day is stored into an array with three fields:
calendars.Days
calendars.ToD
calendars.Appointment
[code].....
I have been struggling to get vbscript working for last three days of relentless effort. I have windows 7 ultimate and upgraded from windows vista. searched the web for solutions and tried out all the options I think I have, but yet no luck.
I tried registering vbscript.dll and I get a succeeded message back. Everything seems to be fine. but, I just cannot run vbscript on my computer. It complains that "can't find script engine vbscript for script ....". I have a hunch that it is something to do with "microsfot security essentials (my virus protection software)" or with UAC.
i just want to ask how can i trap the deletion message appears whenever i delete one item in may data entry? im using vb2008 and sql as my database.i know the code in access. does anyone know its counterpart in vb2008? here's the code in Access 2003acDataErrContinue
View 1 RepliesI whant to entry data in a database (fild) by pressing a button. The problem is that the button is in form 1 and the database is in form 2.
In the Button1_Click i have the cod for Form 2 to show.
my deletecommand delete all my rows whenever i delete a row..but when i view it again the other rows still there and the i deleted is actually deleted.[code]
View 5 Replies*WeightCheck is a dataset connected to a mdf SQL server file..Datagrid on form is bound to the dataset..This code executes because datagrid on form updates with the deletions..[code]
View 1 RepliesI'm doing a project where I need to have people register by entering a username and password. When they click register I want them to be added to the database, but I'm having trouble doing this. Can anyone help? This is my first time using VB.[code]...
View 2 RepliesMy apologies I have posted this in the wrong catagory It should be in VB.net, my mistake)Hi guys I posted this question at the end of another topic I started but I think it will be over looked as the origional topic was solved of the dreamincode community You must all be getting sick of my quexstions by now haha I suppose you don't learn if you dont ask.
Anyway I have used the delete sql method to delete data from a database, I want to refresh the data in the form after the record has been deleted. Do I have to close the form and then open an new instance of it? or is there another way I can refresh the data?
[Code]...
I am trying to update a few entries in a access database through VB.NET. With the code I used below could anyone help me out and show me where I made a mistake because it is creating new database entries instead of updating them.
[Code]...
if i had a cancel button which showed a message box, how would i get the message box to show OK and Cancel and for each of them to do something?
and how would i get an OK (paired with the first cancel from above) to save an entry/ changes to a database?
I was able to successfully connect my database using connection string, i am having a hard time finding tutorials on how to add the items in a textbox. [code]...
View 1 RepliesIs there a faster/easier and more efficient way of checking if an entry exists in SQL then this:
Private Function CustomerCheck()
Dim connString As String = ("Data Source=.SQLEXPRESS;Initial Catalog=BFS;Integrated Security=True;Pooling=True;")
Dim cmdText As String = "(SELECT * FROM Customer WHERE Customer=" + CustomerTextBox.Text.ToString + ")"[code]......
I'm trying to add a name of a product to a Textbox...the name of the product is stored in a database. Now there is a Combobox with number in them....1 2 3 ect. Now if you select one of the numbers it must display that product name?
conn.Open
Textbox1.Clear()
myDataSet.Clear
[Code].....
I want to find an entry in an access database.I've employees database it have 4 columns (Name , Age , Nationality , E-mail address)I've in it 100 entries.And my questions are:1-I want to find all employees those names start with "Tim".2-I want to find an employee that his name is "Charles Sterling".3-I want to find all employees those their ages are "30 years old".*I want to show all results in a message box.
View 3 RepliesI write the following
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
Dim con As OleDbConnection
Dim cmd As OleDbCommand
[Code]...
i am pulling together a cash register that will allow both bar code product entry and manual key entry.imagine if you have a tin of beans in front of you, in a small corner shop they would probably type "47" and then hit "Produce". Fairly straight forward as I have the button Produce to act upon my code and update my salestrans.mdb but,if you scan the bar code I want the same form to handle both 'real' actions, (i assume that keyboard emulation barcode scanner includes "ENTER" after providing 13 digits)....
Q. in perhaps a long winded way i want to know how to kick off an event based on the "ENTER" key being activiated by the barcode scanner)?i do not want to have to hit any buttons if i am scanning bar codes.
What is the code for ignoring the case of an entry while checking to see if the entry is correct or not... (i.e. in a flashcard program... given definition, asks for the name) I don't want the case of a character to affect whether the answer is correct or not.
View 2 RepliesIam trying to link a database to a website. I want the website to allow a user to make a username (OrgID) and password (OrgPassword) and have them apear in my database table (Organizer). This is the code I have so far, but I cannot get it to update the information in the database.
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
if (txtUserName.Text != "" && OrgPassword.Text !="")
[code]....
When I insert a new record into my DB the same information gets two records not one. I am using A datatable and sqlcommand and sqlconnection and sqldataadapter and I'm using me.bindingcontext(datatable).position to move between records.
View 2 RepliesI have an assignment where I have to develop a Windows application using Visual Basic .NET. From the form that I have designed, it should save all records in a table in a MySQL database. How should I do this? Here's what I've got so far:
Imports System.Data
Imports System.Data.SqlClient
Public Class AddMember
[code]....
I want to backup my database using Linq to SQL:
Dim sql As String = "BACKUP DATABASE SeaCowDatabase TO DISK = _
'" + sfd.FileName + "'"
db.ExecuteCommand(sql)
[code].....
Display a Dialog Box that asks for some user input. Take that input and add a new entry to an access datatable. Refresh a List Box that displays the Keys from the datatable. Steps 1 and 2 work just fine. After the following method is executed (without closing the program) I can open the Access Database and the data has been stored to the datatable.[code]...
View 3 RepliesI am trying to make a program with a bar code reader for the first time. I am programming with VB 2005. I want to differentiate a bar code entry to keyboard entry. My questions:
1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).
i connect database with vb.net and also i receive a single value from my receiver through serial port. now i want to match this single data with one field of database. i have attached my code.
Public Class Form1
Private Sub OPEN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
I am inserting data from vb.net to oracle but I am unable to insert datetime except date into oracle. I want to insert date and also time of entry into database:
cmd.Parameters.Add(":STARTING_DATE", (OleDb.OleDbType.[Date].))
cmd.Parameters(":STARTING_DATE").Value = DateTime.Now()
cmd.Parameters(":STARTING_DATE").Value = txtStartDate.Text
I am trying to make a program with a bar code reader for the first time. I want to differentiate a bar code entry to keyboard entry. My questions: 1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).