Search results

  1. I

    if the value is already in tableB, when tableA is queried, record will not be shown

    well i figured this one out. :D hehe. what i did was set the first SQL statement with a where clause for the student then joined it with the avialable programs query then voila. i got what i wanted. hehe
  2. I

    if the value is already in tableB, when tableA is queried, record will not be shown

    here's a clearer question :P i think. i have been scouring all over the internet for this but found no solution so maybe you can help me. here's my dilemma. (am using a mysql back end) i have a table called tblregclass_student (this table is used to store the registered classes for the...
  3. I

    if the value is already in tableB, when tableA is queried, record will not be shown

    i did this already, this would work except that when a class is already added sure enough it won't show up anymore on the selection. what i really want is for the selection only to activate when opening that particular listbox it would be limited to the currently opened listbox.
  4. I

    if the value is already in tableB, when tableA is queried, record will not be shown

    so basically i have a two listbox A and B and that listbox b's records come from tableb, whenever i want to add the records from listbox i use a pop up form that has a listbox with records from tableA. what i want to accomplish is this, if tableAs record is already appended or is already in...
  5. I

    updating a table using the records on the listbox

    actually i've sorted it out already, sort of. the reason i am doing this is because my forms, ALL OF THEM are unbound. some may say this is unnecessary but i prefer doing it this way to control the users data entry and the way the tables are designed are extremely reliant on referential...
  6. I

    message appears when hover over Command button

    i realize this topic has been open for a long time but just wondering how do you adjust the delay on the hover mouse?
  7. I

    updating a table using the records on the listbox

    huh? no i use mysql as my back end. all i really want is a loop code for the query on the listbox so each pk for the query will be matched on the original table and updated if necessary. what i planned to do with the delete was move it in another temp table then of the id is found on the...
  8. I

    updating a table using the records on the listbox

    i actually get this :D hehe. guess that's the side effect of learning this differently than normal. i do get the idea of temp tables and what not, but what i want to know is if i can get a snippet or sample for a mysql update using the records on the listbox?
  9. I

    updating a table using the records on the listbox

    i know how to work with update but am not sure how select query works. can you give me a sample or short intro? what i want really is a listbox using a temp_table as a record source, upon exit on the form, once the user exits and press save (the form is unbound).
  10. I

    updating a table using the records on the listbox

    is it possible to update a table using the records on the listbox? say you added new record so in the temp table then append the records to the perm table. how would i do this? i have used update mysql but i only know how to use this on a single field but have not found success or know the...
  11. I

    undo on an unbound form

    well if i was only dealing with 1 recordset sure, but i am dealing with more than 1 table and using odbc connection for update and inserts. is there any way to do this with an unbound form?
  12. I

    undo on an unbound form

    i found this code on the internet, i think it was roger's library. basically he made an undo code on an unbound form, it does work on this thing. but the key difference with his and mine is that i use a sql string to fill my record while he using a variable to open it. can anyone help me...
  13. I

    closing this recordset

    wait, i get it now. since i didnt "set" anything, i don't need to close it. thanks! :)
  14. I

    closing this recordset

    so with Form_frm_one .recordsource = strSQL set = nothing <-- is this it? because when i close the form then open it again, there is a record source set.
  15. I

    Function to open tables

    can you elaborate furthe? cause it seems you can just set an in module variable then use either a case or if statement.
  16. I

    closing this recordset

    so i know that when you set the recordset you can set the variable to set it for rs = nothing, but how would you close this? With Form_frm_details_student .RecordSource = strSQL1 ' if this was a field/listbox it would be with me.listbox .rowsource = strSQL! .value =...
  17. I

    input mask

    so you know how it is when you put an input mask it would select where you actually were clicking? is there a way when you click on a field with input mask, it would first select the first character on the left? or select them all?
  18. I

    resetting in in module variable

    so i'm all good right? when closing the form the variable is gone?
  19. I

    resetting in in module variable

    so basically all this time i have been assigning pk that've been pulled through sql through a text box, i realized you can actually do this via variable. so i have been playing around with it and got it to work, but what i want to do is, how do i reset it once the form closes? here's a sample of...
  20. I

    wrapping these code

    oh yeah, didn't think of it that way. awesome thanks man.
Back
Top Bottom