Search:
Type: Posts; User: jaya-shree
Search:
Search took 0.04 seconds.
-
Hi!
I am trying to generate reports using the data designer.
I have a form with a dropdown combo and a button. I select one value from the dropdown combo. When I click on the button 'Generate...
-
I am designing reports using the microsoft designer in VB. I do nt have crystal reports. I have designed the user interface using the wizard. i want to link it to the database.
using access...
-
I am designing reports using the microsoft designer in VB. I do nt have crystal reports. I have designed the user interface using the wizard. i want to link it to the database.
using access...
-
rs.Open "select memberId, itemId,dateOfIssue,Dateofreturn,actualReturnDate,fine from transactions where itemid = '" & txtItemId.Text & "'", db, adOpenStatic, adLockOptimistic
i want to set...
-
I have two date fields in my code:
Dim dateOfIssue As Date
Dim dateOfReturn As Date
when i printed the value of date, it gave 12:00:00 AM. I want to get the date in the format MM-DD-yy. Plz...
-
i have a column in the database which takes only yes/no in the db. when a query is fired into the db, the value gets retrieved properly.
If the value is "yes", then i want to display an error...
-
I have a login form. The login name and password tht the user types needs to be compared with the combination in the database.
plz let me know how do i compare the textbox values with the values...
-
i am using ms access database.
-
I have the login id and password coming from the form
i have a query which gets the login name and password from the table.
i want to validate the user name and password against the values...
-
How do i write an insert query for the following:
Transactions table
transactionId --> autonumber
memberId --> comes from recordset1
ItemId --> comes from recordset2
startDate -->...
-
I used Instr(ItemId.txt,"b") <> 0
if i pass "b001", then instr() returns = 0
if i pass "m001" , even then instr() returns = 0
if I use Instr(ItemId.txt,"b") = 0 then
the above condition is...
-
I have a form which has two fields:
memberId and itemId.
In the itemId field, I can give values like 'B001','P001','M001' and so on.
If it is B001,--> it indicates a book and i need to query...
-
i have a form in which i am displaying the details from two tables:
in the form load event, i have the following code:
<vbcode>
Dim WithEvents adoPrimaryRS As Recordset
Dim WithEvents...
-
In the book table, i have the following fields:
itemid,bookname,author,publisher,isbn,volno,editionno.
in the items table, we have itemid,isissuable, noofcopies,fine/day,issuabledays.
the...
-
hello,
is there nobody who can suggest something? i am stuck at one point.
-
In the book table, i have the following fields:
itemid,bookname,author,publisher,isbn,volno,editionno.
in the items table, we have itemid,isissuable, noofcopies,fine/day,issuabledays.
the...
-
the above statement gives an error at compile time if i dont put a = sign.
-
How do i compare two date fields in VB
one comes from the table and the other is the system date?
-
trying to insert data into two tables at the same time
I have the following code to select data from two tables:
<vbcode>
Private Sub Form_Load()
Dim db As New Connection
db.CursorLocation...
-
The following sql stmt gives me an error:
Dim sql As String
sql = "Delete from MemberItems where memberId = '" & txtFields(0).Text & "'"
adors3.Open(sql, db1, adOpenStatic,...
-
The values in my combo box come from a table.
I want to highlight one of these values after comparing it with the values in the table.
Eg: if memberId = 2 and schemeName = quarterly for this...
-
The values in my combo box come from a table.
I want to highlight one of these values after comparing it with the values in the table.
Eg: if memberId = 2 and schemeName = quarterly for this...
-
<vbcode>
Dim db As Connection
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "Provider=MSDASQL.1;Data Source=library"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open...
-
The infinite loop is gone, however, the focus on the textbox moves off . The focus shifts to the next box.
i want the control to remain in the same box after the validation msg.
-
when i try to add a record into the db, i get the error:
multi step operation generated errors!
i dont know y this error comes and how can i solve it?
-
i have the following code for the delete function:
<vbcode>
Private Sub Form_Load()
Dim db As Connection
Set db = New Connection
db.CursorLocation = adUseClient
db.Open...
-
On a form, I have a set of 12 text boxes.
I have set the following properties for the form:
Name: txtFields
Index: 0,1,2 ...
ie i have made an array of text boxes.
-
Here is the code:
==============================================
Dim db As New Connection
db.CursorLocation = adUseClient
db.Open "Provider=MSDASQL.1;DSN=library"
Set adoPrimaryRS = New...
-
The following is my query:
It returns two columns
==============================================
Dim adoprimaryrs1 As Recordset
Set adoprimaryrs1 = New Recordset
adoprimaryrs1.Open...
-
I have the following code:
==============================================
Dim adors2 As Recordset
Set adors2 = New Recordset
MsgBox "txt2" & txtFields(0)
-
I have the following code:
==============================================
Dim adors2 As Recordset
Set adors2 = New Recordset
MsgBox "txt2" & txtFields(0)
-
I am facing a situation like this:
I have books and journals table with ItemId as pk.
I have items table with ItemId as fk.
Now, depending on the ItemId i need to query the item table and...
-
I am trying to pass a parameter which is the result of a query into another query as follows:
==============================================
Set adoPrimaryRS = New Recordset
...
-
I followed the steps suggested by u:
-------------------------------------------
Do While Not adoprimaryrs1.EOF
oCombo.AddItem adoprimaryrs1(1)--> error at this line
MsgBox "added item"
...
-
i am passing a value of memberId from the form to the sql statement.
When i tried to print the value of memberId, I get the value properly.
when i run the sql query and check the record count...
-
I tried out ur code as follows:
-----------------------------------------------
dim index as integer
index = 1
Do While Not adoprimaryrs1.EOF
Ocombo.AddItem adoprimaryrs1(Index)--> at...
-
I have written the following code to delete a record from the database.
==============================================
Dim db As Connection
Set db = New Connection
db.CursorLocation =...
-
I have a combo box with say four values, in a form.
when i select a value from this combo box, i want the id related to this value to be inserted into the database.
how do i do this?
I...
-
thanks a lot!
wht i am asking is when i select a value from the combo box, there is an id associated with each value in the combo box. i want to pass this id as a hidden parmater.
i dont know...
-
depending upon the item id that is present in the text box, i want to fire queries to different table.s
eg: if the itemid is B001, then a query to books table,
if itemid is P001, then a query to...
|
Click Here to Expand Forum to Full Width
|