Recent content by Jboymeng

  1. J

    A good anime or movie

    Um, Adventure, Fantasy, I like SAO ,Arslan, Is it wrong to pick up girls in a dungeon, Fate/stay night, naruto, bleach, one piece and the like. I have watched a lot but i haven't kept track.
  2. J

    A good anime or movie

    Hey guys, Can anyone suggest a good anime. Has to be new, good art quality. :) Also, What is you favorite movie of all time? Just one. Thanks!
  3. J

    Turning Letters in to Numbers (code)

    Somebody Please help. How to do use this as an ms access function?
  4. J

    Automatically Fill Field Based On User ID

    Hello, I do this as well... you need to have a login screen to set the temp variables first. so that when the form loads it knows who is using it. and on the on load or after update of a control event procedure just put. me.officeris=[TempVars!][LoginID] or something like that. Login form...
  5. J

    Combo box does not expand and search as you type

    Also, Please comment about the DB I made.. The problems you think I will have in the long run.. The DB will be split and there will be 5 copies of the front end, 3 will be connected to the back end thru LAN the other 2 will be remote, Connected with Hamachi. tried it in a trial database, works...
  6. J

    Combo box does not expand and search as you type

    To recreate the problem in access 2010 try this: Make the tables: Create tblSupplier with fields SupplierID(Key,AutoNum), SupplierName(text) Create tblMasterItems with fields MSitemsID(Key,AutoNum), MasterDescription(text), Supplier(Num, relate to SupplierID) Create tblWSitems with fields...
  7. J

    Combo box does not expand and search as you type

    The DB is still incomplete and need a lot of work and I have only learned access three weeks ago, so please forgive/Excuse the mistakes, Ugly work arounds, messy codes, redundancies and other things. hehe. the tables haven't all been populated yet and some I'm still working on. Its just this...
  8. J

    Combo box does not expand and search as you type

    Here are pics of what I do with the qry. Also the row source SQL with criteria is SELECT tblMasterItems.[Master Item ID], tblMasterItems.Description, tblMasterItems.Supplier FROM tblMasterItems WHERE (((tblMasterItems.Supplier)=45)); Row source SQL no criteria is SELECT tblMasterItems.[Master...
  9. J

    Combo box does not expand and search as you type

    MS ACCESS 2010 AutoExpand Property Set to Yes I have a bound combo box that has a query as a row source, The query has 3 fields called from tblMasterItems, The ItemID , ItemDesc and ItemSupplier(related to the PK of tblSupplier). Column Count = 3 Column Width = 0";1";0" If I do not put a...
  10. J

    Turning Letters in to Numbers (code)

    I cant get the module to work in MS Access. How do I do that?
  11. J

    Turning Letters in to Numbers (code)

    Hi everyone! Hope Everyone is good. I have this UDF in my excel template that changes a set of numbers in to letters corresponding a code. For example the code is "EUCHARISTO" it would simply mean E=1, U=2, C=3, H=4, A=5, R=6, I=7, S=8, T=9, O=0 and by default the tenths position (".0")=X...
  12. J

    Hello Access World!!

    Good Day Everyone! My name is Rajeev and I am new to this forum, Im from the philippines and I have been using MS Access for a total of 2 weeks. :) My Hobbies are anime and manga. (love the new Is It Wrong to Try to Pick Up Girls in a Dungeon?) That's about it. Thanks for reading Have a nice day!
Top Bottom