Recent content by Epic

  1. E

    Show Database Window after Hide

    I have an ms access 2013 db on a WIN 10 64 bit machine. What I'm trying to achieve is to have my login form showing up without the database window frame, just the form alone, then (after login) restore the database window. I am using this code I found somewhere: Global Const SW_HIDE = 0...
  2. E

    Export executable OLE Object

    I understand the logic and various methods I can automate this... the problem is the code itself... could not make it work. I have used the microsoft advise but the exported program is altered and does not launch... invalid memory instruction or something like that Can you post a working version?
  3. E

    Export executable OLE Object

    Hi, Trying to figure out how to export an executable OLE Object from a table in a certain location. I am googling for a few days now, I found many solutions for pictures, office documents, etc... but I did not managed to addapt them for my needs. Basicaly what I want is to hold in one of my...
  4. E

    To store barcode value in a control

    It deppends on what type of barcode reader device are you using. The most simple version is a barco reader conected with a "Y" cable to the keyboard. This will write whatever has readed to the place where your cursor is in that moment... same as you are typing. Search internet, there is plenty...
  5. E

    Help Asap Need Help Asap Need Help Asap

    agree with boblarson with thıs approach probably most of the people here wıll ignore your post anyway... not sure what is your problem... giving a guess now: have you specified the subform object Master/Child relationships?
  6. E

    setting default value of txtbox in code

    do you have any other default value at the table level? say ""
  7. E

    Look up last record's year

    create a query and on group by select max
  8. E

    Automatic Membership Number

    No... leave the auto number where it is... this is unique and will identify the members. Add another field say "MemberType" Text, length 1 to your members table... additıonaly creat another table (lookup fo thıs fıeld) where you can store the description of the member types A - New B - Junior C...
  9. E

    Help Needed

    Under Add button Forms("PizzaOrder").Form.forms("PizzaOrderSubform").Form.Pizza = ME.Pizza Forms("PizzaOrder").Form.forms("PizzaOrderSubform").Form.Type = ME.Type etc.. Or something like this... use the code builder from a separate form to get the above Thıs way you can refer to any open...
  10. E

    how do i stop records being shown on form load up?

    ... and manipulate the filter by replacıng the record source... thıs will stop the user to cancel the filter... if you want
  11. E

    Update query???? or something else

    you do not have to adjust anything... just create the update query and link the tables at qry level. Addıtionally, If you data in excel is in the same format always, link the excel fıle and will behave like any other table. You can also write back to the spreadsheet from ms access.
  12. E

    numbering list ?

    will this do ?: InvNo = "SI" & YourAutoNumber
  13. E

    Automatic Membership Number

    do you really want this? is there any benefıt for you? if you want just for display reasons just format your autonumber and attach a character from somewhere...
  14. E

    More than two Subforms

    u can also follow this link which will download some sample Accees Db's... (12Mb) and study... starts right from the beginning. Is Access97 but the logic is the same.;) ;) AccessCookbook97.zip
  15. E

    Filter on New Record

    Set the data entry property of the form to true. can't really follow the rest
See more
Top Bottom