Search results

  1. vhung

    Need advice building a workforce and attendance database

    look at your num2 2. calculate a weekly attendance (in total hours) for every staff in the list > your "Attendance (in hours)" if this refers to one day may that be on your report sumtotal "(in total hours)"
  2. vhung

    Need advice building a workforce and attendance database

    add 2 fields >time of log in and time of log out >in order to determined "Attendance (in hours)"
  3. vhung

    I want to Concatenate First Name and Last Name fields into Full Name Field

    3 fields were given > no worries > would be: [Full Name]=[Last Name] & ", "& [First Name] > on [Last Name] and [First Name] update insert code above
  4. vhung

    The future of Access

    we can still use access but more likely the updates be limit > Mainstream support for Access 2013 ended in 2018. Extended support will end in 2023. > isladogs mention "If you have a license for 2013 you will still be able to use it once the support period ends (in 2023?)" > Access 2016...
  5. vhung

    Suppress "You can't save this record at this time"

    sorry >i only sight the concept >yes codes has complete syntax for that (i always use it) >wish you could arrived with it (only you would consider the other form functions) >but if you want the specific syntax maybe i could share it later
  6. vhung

    Suppress "You can't save this record at this time"

    wow nice play >form timer is great >why you set IDLEtime and ExpiredTime idleminutes value is undetermined, if this run "If ExpiredMinutes >= IDLEMINUTES Then" just setting this "ExpiredTime = 0" for DoCmd.Quit acQuitSaveNone >if your time expired >=idle maybe set dim answer...
  7. vhung

    The future of Access

    You like Access much >on the run i use 2010 if my system break's down >2013 has nice feature and mangeable too >i try 2019 but i can't work with well, there's limation when setting up >as of today i keep on 2016 but indeed some controls don't work anymore, but i remain with 2016 >sure if 2013...
  8. vhung

    STILL CANT SUS THE COMBO TO LIST BOX

    good luck >with your project, you can do it, all the way
  9. vhung

    Update underlying table

    GUESS >That is auto run >maybe supply also the cmdsave codes if applicable >when you insert that ontimer always run for save to table >that if your acForm settings is true to your target actable >i used it many times >well in this case, supply your codes to ontimer, if you have use calculations
  10. vhung

    Update underlying table

    maybe form settings >try to use OnTimer then set TimeInterval=1000 >OnTimer: insert codes like "me.requery" >see attachment
  11. vhung

    Identifier type characters

    guess >"suffixed with ^" is an exponential sign >i used it with my access calculator >see attachment
  12. vhung

    Identifier type characters

    wow >very silly >try that sometimes later
  13. vhung

    Export Subform to excel

    did you try the codes >if not you cannot evalaute it's accuracy >"or it will error out" what error is that, guessing error, be prompt >"must be saved first" of course you have to save it, that is part of confirmation well anyway, it was Hillary who seek for solution >good luck to both of you
  14. vhung

    Constant hack attempts on AWF

    silly >operating system patched (thus they try to destroy hardware) >applications/utility programs (study the software weakness and sell us their products) >Anti-Virus package (too serious) they want to make money, finding their best clients target, what a world of Information Technology...
  15. vhung

    Export Subform to excel

    tough move >just try the syntx below, then recode the entry form name []![] to subform DoCmd.OutputTo acOutputForm, [FrmImprt/Exprt], "MicrosoftExcel5.0/95Workbook(*.xls)", "", True, "", , acExportQualityScreen >i used this before, hope would work too for you
  16. vhung

    Surveying new members

    that is what i mean >stat would locked the privacy settings >which is not in common sorry doc
  17. vhung

    Constant hack attempts on AWF

    nice >they had a big cause for that means >we must be in order always >we can't simply motivate them but rather undressed them thanks doc...
  18. vhung

    Constant hack attempts on AWF

    well >i didn't mean it but it does... >thanks for the recognition
  19. vhung

    Resize sub forms

    that's right >anchor left/right or top/bottom is very applicable >there is codes for that try to search >i forgot where i place/use the code for anchor a form before
Back
Top Bottom