Search results

  1. I

    connecting with a mysql back end in a webserver, is it possible?

    so is it possible to connect a mysql server over the web? cause when i was looking at the ODBC connector, it can be done though, yet i haven't tried it. so i want to know if someone has and is it a good idea? thanks! :D
  2. I

    filtering a memo field with a specific phrase type.

    so i want to accomplish something, this might be just a bit complicated buy i want to do it anyway, what i am trying to is this, that when they enter something in the comment box, a function would see whether a certain phrase say, "Cancel, 08/16/2011" would then create a new cancel record with...
  3. I

    saving unbound form with PK and FK (PK becomes FK)

    so how can this be done? i have two tables that uses the PK of tblA as a look up for tbl B making it the FK for tbl B. i have an unbound form that has all the fields for both tblA and tblB but thing is, when using the rs.new, it only generates the autonumber for tblA, how can i include or copy...
  4. I

    ms access 2010 and sharepoint

    correct me if i am wrong, but i was able to put my table on a sharepoint site and did some remote collaboration with a couple of co-workers, what i want to know is it a good idea or no? and is there a way to connect through a hosted sql or mysql server to preserve the access front-end?
  5. I

    how would this be done

    so i have listbox with a bunch of records, i want to add a new record to that listbox, what i want next is, once the record is created and the listbox requeried then that record would be the selected item in the listbox, any clues how to do this?
  6. I

    how would you write this

    i think i did what you have said, basically, i have this function taht starts an sql to a listbox's rowsource, but thing is, if it's a new record i don't want it to load, and i tried doing the WHERE clause in the sql and still not working. maybe i'm just tired and not seeing the code straight...
  7. I

    how would you write this

    can you elaborate? :P
  8. I

    how would you write this

    ah. maybe i do need a break, but the function is still firing up. i had the button open a new record here's the code i had embedded on the button DoCmd.OpenForm "frm_LABREQUISITION_ADMIN_NEW", acNormal DoCmd.GoToRecord , , acNewRec then put the sub on the on load property of the form to be...
  9. I

    how would you write this

    how would you write so that a function will not work if the record is new or when a button with the command DoCmd.GoToRecord , , acNewRec meanning that if me.newrecord then don't fire up function123 but if the record is not new, fire up function123.
  10. I

    something wrong with my code

    even if i put a space, it still returns nothing. i already tried the step by step and that's how i figured it out yet still can't seem to find the reason why it's broken.
  11. I

    something wrong with my code

    i already know what doesn't work, it seems that the line If Not IsNull(Me.txtHHA) Then If strWhereSql1 = "" Then strWhereSql1 = "WHERE CAGENCYNAME Like '*" & Me.txtHHA & "*'" Else strWhereSql1 = strWhereSql1 & "AND CAGENCYNAME Like '*" & Me.txtHHA & "*'" End If End...
  12. I

    something wrong with my code

    so did the debug.print strSQL, what i have noticed is though i keep getting ALike instead of just Like, cause i believe i checked the SQL compatibility with this project, any ideas how to write ALike in VBA?
  13. I

    something wrong with my code

    so this code seemed to work earlier now it wont. for some reason, it only works when i try to filter the date, but won't work with the text strings, any thing wrong with it? Function startReqList() strStartSql1 = "SELECT qry_LABREQUEST4.LABREQUISITIONID, qry_LABREQUEST4.FLABREQUESTID...
  14. I

    how would you go on about doing this?

    can you give me a sample?
  15. I

    how would you go on about doing this?

    i want to filter a query using all the data in a listbox, how do i do it?
  16. I

    this might be simple, query writing need help

    how would you go on about writing something like iif([field] = 1 or null,true,false)? thanks. i can't get the part to make it an or
  17. I

    1 month + and still no luck, ranking records with the ability to change rank

    so i have this thing with a record, that when someone adds a record, a field counts the number of records or ranks the record from 1 to n then if the user wishes to change the rank of a record, he/she only changes the number of that field then the query would rearrange on its own, any idea how...
  18. I

    ideas on how to do this

    ahaha. lol. i didn't realize it. thanks for pointing me to the right direction. just that, it was bad enough they wanted it ranked, now they way to be able to change the rank as they please it. just never had any idea nor tackled that kind of request before.
  19. I

    ideas on how to do this

    thanks, i'll check it out. lol on the user though, banned :)
  20. I

    Search form

    what data are you searching? you can use either a query based search or use vba. something like strStartSql = "qryexpression" strWhereSql = criteria etc.
Back
Top Bottom