Recent content by zambam

hi i have a textbox which the user enters a criteria. i want it to filter through a datagrid on my form. e.g. search is 'harry', all records with harry in the first name field should show in the datagrid. thanks

well, ive connected it to the correct database but thats about it.... i used the adodc control by clicking the button from the left of the vb6 interface. i then went to properties and clicked on connection string etc etc...

hi, i have a loans table and a products table. i want to be able to update the field "borrowed" in the products table THROUGH THE LOANS form in VB6, by updating the recordset. so it would use the productID TO FIND THE RECORD (txtproductID), then update the "borrowed" field for that book. i...

this is an example of one of the things i have: SELECT `Member ID`, Forename, Surname, `Date Loaned` FROM Loans i want the user to specify a date range so all the loans between that date range are shown. in access, to enter a parameter as all of you already know it would be between[start date]...

thanks pls do, id really appreciate that. in the meantime ill try figure it out from what you have said.

thanks, but how would i do that? im using vb6 thanks

WOHOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO:D :D :D :D I CAHNGED THE "1" TO "-1" AND IT WORKED!!!! THANK U SOOOOOOOOOOOOOOOOOO MUCH!! (sry abt caps - im just so happy now!) thanks again!!!!

i have written this: SELECT `Member ID`, Forename, Surname, `Paid?`, `Fine?`, `Amount Due` FROM `WHO HAVE NOT PAID` WHERE (`Paid?` = 0) AND (`Fine?` = 1) this is supposed to show people who have not yet paid, but it does not bring up anything in the search now. it used to work before...

hi, i have written an sql statement to display fields from a table. but i want it to do this based on a date range (the user enters a parameter) this can happen in access, but im using vb6 to do this and i dont know how to specify the parameter to wait for user input to filter the results pls...

hi, i have written SQL code so that all the members with the surname "jones" are found. i want to display this in a listbox, so that when the user clicks on the specific record from the listbox, the details will automatically fill into the text boxes on the form. is it possible to display...

thanks for your reply what im trying to say is that when i click the book title in the first combo box, it should transfer it to the second combo box to show that it is not in stock... how would i do this? :confused: :confused:

hi, i have created a combo box that is linked to a query. it shows the books that are in stock. here is the sql: SELECT Books.[Book ID], Books.[Book Title], Books.[In Stock?] FROM Books WHERE (((Books.[In Stock?])=Yes)); i want to create another combobox, which will show the books not in...

hi i have linked an access query into visual basic by linking it to an adodc1 control, but what do i do now? how do i run the actual query? pls help. thanks

hi i have two fields that are the same, but in different tables. can i create a relationship so that when one field (in stock) from the purchases table is selected, the same field in the stock table is the same value as the one from the purchases table... i hope i explained it well enough:)...

hi is it possible to use an existing query from access and open/run it from visual basic (externally)? if so, what would be the easiest way? thanks