Search results

  1. I

    appending a table in my front end to my mysql back end

    hello. i am having trouble with this code, the reason being is that i am referencing the table in the front end wrong. can anyone help me correct it? Private Sub cmdsave1_Click() Set cnx = New ADODB.Connection With cnx .Open "DRIVER={MySQL ODBC 5.1 Driver};" & _...
  2. I

    retrieve last autonumber from append and use that as FK for another table

    so how is this achieved? how do i retrieve each pk from an append sql statement and use that pk as an fk for another table used to combine it with another record. say a phone number and a client.
  3. I

    temporary tables and mysql

    That is a good idea. But I still don't know how to append my tables properly. The way I designed my tables are like this: tblclient tblphone tblclietphone So the deal is for each for number entered on the temp table for phone numbers I need te autnber retrieved so that I can use that number...
  4. I

    temporary tables and mysql

    i already have the connection figured out, what i want to know is how to be able to append temporary tables in ms access to mysql backend. the thing though is that when i append each row of record i need to retrieve their autonumber because the way my tables are set need to have that kind of sql...
  5. I

    s.o.s please! something odd happend

    do you mind telling me why i need the space for? actually i got it to work, i removed the * on the where clause but odd thing is on another app it's exactly written the way it is with the same exact settings and about 4 or 6 hours ago this function was working fine.
  6. I

    s.o.s please! something odd happend

    basically the problem is the where clause suddenly stopped working.
  7. I

    s.o.s please! something odd happend

    Function startRowSourceZipCode() strStartSql1 = "SELECT qry_city_state_zipcode_01.id_us_zip_code, " _ & "qry_city_state_zipcode_01.uszipcod_city, " _ & "qry_city_state_zipcode_01.usstacod_abbreviation, " _ &...
  8. I

    i have an unbound form and a vba recordset

    sorry. so basically i have a form an unbound one, the reason it's unbound is that my boss requested that we only have to click save once which does add to a point but adds more complexity to what i am doing. the records are stored as follows tbl_client tbl_contact_info (phone numbers, email...
  9. I

    i have an unbound form and a vba recordset

    so my question is this: i have an unbound form that has fields for phone numbers, sometimes the record has more than 1 phone number per client. how do i fill the unbound text boxes on my form when the recordset is filtered for a specific client who has more than 1 phone number?
  10. I

    argh! stops working when connecting to mysql LAN server

    so why is this happening? my thing is weird. for some reason, when i link the tables on the mysql server ms access stops working! any ideas?
  11. I

    need help with loop inserts with mysql

    so i am getting an error 438 with this one, anyone take a second look and tell me what's wrong? can't think straight at the moment, having gout attack :( Set ctl = Me.lstregclass For Each varItem In ctl.ItemSelected strSQL = "INSERT INTO...
  12. I

    is this possible?

    so am just wondering, is it possible when you have a modal form open the form behind/below it will turn to gray?
  13. I

    how to would this be set?

    am thinking of storing it? but a lot of people told me it's a bad idea. not sure though. but what am really concerned in doing here is how would the server and the database be set each time the application is deployed to a new computer? the user name and password i can store it if i have to...
  14. I

    how to would this be set?

    so i have this connection settings each time i update, insert, delete something in my record though i realized when the application is placed in our LAN server i would have to change the user and password as well as host, is there a way or how would this be set each time the application starts...
  15. I

    WHERE isnull in vba

    so am trying to figure out the proper way to write this: strWheresSql1 = "WHERE qry1.field1 = Is null " seems not to be working?
  16. I

    how to declare this variable

    how should i declare my variable vbresponse and strmsg (i think this one is string :P)?: strMsg = "Are you sure you want to add these classes a required course for this Licensure Program?" vbResponse = MsgBox(strMsg, vbYesNo + vbDefaultButton1 + vbQuestion, "Register program with student?") If...
  17. I

    can you use a column for an entire query as a criteria?

    so am thinking, is it possible to use an entire column as a query's criteria? like WHERE fieldtobefiltered = thefieldtobeusedascriteria from query1
  18. I

    option explicit

    i meant was like column 1 and 2, yeah i tried that it does work but i wanted something to compliment my ocd :D but thanks.
  19. I

    option explicit

    so i declared a lot of variables, like 30 :D is there a way to column them? e.g dim 1 as long dim 2 as long etc.. dim 30 as long
  20. I

    how to loop the .changeevent

    well i guess my mistake was not having explained my situation clearly. basically i just got lazy and wanted to find a way to detect changes made in my unbound form. normally i would set a variable to false when something is typed on the field. but i found myself having too much fields and got...
Back
Top Bottom