7 results in 0.0014 seconds.
-
How to autopopulate a couple of textboxes from a database table?
I am new to VB world and developing an application which has to identify a person using their fingerprint, and i have to autopopulate the textboxes from the database depending upon who has logged in (the returned fingerprint ID from a scanner). That is, once the userid has been obtained from a reader then autopopulating the textbox fields i.e. family name, address, birthday, etc. Your post looks similar to what i need, except it gives me an "object... -
CLEAR the Table "login" on closing of the form
Trying to CLEAR the Table "login" on closing of the form...
...Code:public void remTempData() { string delete = "DELETE * FROM login"; SqlCommand rMove = new SqlCommand(); rMove.Connection = access; rMove.CommandType = CommandType.Text; rMove.CommandText = delete; rMove.ExecuteNonQuery();Last edited by Niheel; Oct 13 '11, 12:56 AM. -
I want to view the VB code of my MS Access Database 2007?
Is there any way i can view the VB code of all the objects i created in my MS Access Database?; in the Event Procedure of any object; it only shows me the events; not the actual design?
p.s. i created the DB using wizards
You see i created this MS Access Database (assignment) using wizards to create all my Tables; Forms; Queries and Reports ; now my teacher is asking for the VB code (the object design code); i can get...Last edited by Niheel; Apr 5 '11, 09:08 AM. -
SPC Camp started a topic What is the best way to build a db to report a total number of true yes/nos'?in AccessWhat is the best way to build a db to report a total number of true yes/nos'?
I am trying to build a db to report the deficiencies/strengths of security. We have about 1000 criterion that we base these on. I am trying to set it up to where we can specify which criteria they are deficient in, and it will report the total number of deficiencies that section has. i have tried to do this with a yes/no field, and code that looks a little like this:
in order...Code:Sum(([a1000]+[a1001]+[a1003]+[a1002]+[a1004]+[a1005])*-1)
-
MySQL sintax error
Hi, I'm currently trying to fix this db, it gives me sintax error all the time, I checked it from down to up, nothing worked.
Could anyone please give me a little hand? :)
...Code:CREATE TABLE IF NOT EXISTS `#__huruhelpdesk_categories` ( `category_id` bigint(20) NOT NULL AUTO_INCREMENT, `cname` text NOT NULL, `rep_id` bigint(20) NOT NULL, UNIQUE KEY `category_id` (`category_id`)
-
CurrentDb.Execute Problem
I have the followind code executing when a popup form closes.
I need the 'RequiredDate' field in the backend db to update to what is stored in the [RequiredDate] fireld. I also have the Shipped date updating in the db but that is done automatically since it is bound....Code:CurrentDb.Execute ("UPDATE Orders SET RequiredDate=#" & [ShippedDate] & "# WHERE OrderID=" & [OrderID] & ";") -
c#.net:retriving data from db to textboxes
can anyone help me,i have placed 2textboxes and a button,one textbox is to give the name ,textbox2 is to retrive values from db(address of a paricular name ),i tried a lot ,but i couldn't make it,help pleaz.......... ........
