Search results

  1. M

    Question ACCDE version od database doesn't work as it should

    Of course. I've noticed that all the .accde versions I've created on my current system does not work. I have second system on other hdd (on which I switch to test something) and when I create .accde on it, that version works. Also, when I try the .accde version I've created on my first system...
  2. M

    Question ACCDE version od database doesn't work as it should

    This is the second database I've created in Access 2007 and now I have a problem when I compile it to .accde, it doesn't work. it's like there is no code, the button on my main form doesn't do anything. The previous database I've created worked normal. What should I do? Thank You
  3. M

    Checking the date but not from the local machine

    What do You mean by "seen" dates, maybe the last date application was started? If yes, then that system isn't foolproof, the better way is to check the date somewhere else. Where would You store the "seen" dates, table, property? The software will be installed on one workstation but there is...
  4. M

    Checking the date but not from the local machine

    Well, yes, unless You have some other idea from where I can read the current system date besides calendar in the lower right corner of windows OS, because if they change date in calendar, lets say a year from now in the past, they still have one year to use my program, so by my opinion it's...
  5. M

    Checking the date but not from the local machine

    Can I somehow connect with VBA from Access to time.windows.com in order to check which is current date, because as You know users can change the date on their local machine and thus fool the software? Or maybe use some ActiveX control or something? Any ideas on this? Thank You
  6. M

    Please explain how to use this module

    I tried using FormatDateTimeIntl function but the locale argument confuses me. What value I need to pass in this function for that argument? Also the function StGelLocaleInfo(locale As Long, LCTYPE as LCTypeEnum) As String what arguments do I need to pass for it to work? I tried using different...
  7. M

    Question Many records speed tactics

    And what exactly do I need to do that?
  8. M

    Question Many records speed tactics

    Thanks George, and Banana for You answers. One of the reason I was asking was if Access couldn't deal with that many records then I would be forced to switch to different platform. Now when I know it can there is no need to change it, so yes, I will use access as a pure solution. Cheers!
  9. M

    Please explain how to use this module

    On this article http://allenbrowne.com/ser-36.html#Interface I've found this module: '------------------------------------------ ' basIntlFormats ' ' Some helper functions for handling date/time/currency ' formats for locales other than the current regional ' settings will handle. Since...
  10. M

    Back end password issue

    I was thinking about this. I have a split database. If i add password to back end what code must I use in front end to open the back end database sucessfully? Thank You
  11. M

    Question Many records speed tactics

    Very soon I'll start to build a database which will approximately have 5000 new records a month, and it will have to keep records for last two years, so that is 5000 * 12 x 2 = 120000 records. The scenario is : Database will be empty at the beginning, each month there will be 5000 new records...
  12. M

    Converting date format in VBA

    I don't understand what FormatDateTimeIntl() function, from basIntlFromats module, should do. Could someone please explain? How do I use StGetLocaleInfo() function? Could somoeone pleaseexplain how do I use this entire module?
  13. M

    Question Application data transfer through internet

    What is sharepoint location?
  14. M

    Question Application data transfer through internet

    Each user is working with its copy of the back end. Both users finish at the same time, then the Back End 2 is e-mailed to LAN 1, and then the synchronisation should take place, copyinign (or whatever needs to be done) the newly added records in Back End to to Back End 1 (thus creating one...
  15. M

    Question Application data transfer through internet

    What about this idea: When the user on LAN 2 finishes his work and send his Back End to LAN 1, can that Back End 2, when gets on LAN 1, extract only that data that is added( and/ or changed) and import it in the Back End on LAN 1? Is the thing simpler if User 2 on LAN 2 only ADD new records not...
  16. M

    Question Application data transfer through internet

    I need to create a database which will be operated on two different workstations and on two different networks. One networks has a server where main database will be stored and that network will have its front end database from wich the user will manipulate data stored in back end on server...
  17. M

    Hi Galaxiom, could You please look at mt question at this thread...

    Hi Galaxiom, could You please look at mt question at this thread http://www.access-programmers.co.uk/forums/showthread.php?t=179822, I'm waiting for someone to answer whole day. Thank You
  18. M

    Question Split access 07 database

    Can You give more detail about terminal services session? Do I need some kind of software for this? What is more faster, efficient and reliable, using terminal services or online application from a browser? In what format should the back end be (.accde or .accdb)? Can I split and link two...
  19. M

    Explanation of a complex JOIN

    I've recreated query (removed some joins ad made it shorter): SELECT tblZahtev.intZahtevID, tblZahtev.dteDatumZahteva, tblZahtev.txtBrUgovora, tblZahtev.bolDoc1, tblZahtev.bolDoc2, tblZahtev.bolDoc3, tblZahtev.bolDoc4, tblZahtev.intDocTipID, tblZahtev.txtSifraDetetaID, tblDete.txtMBDeteta...
  20. M

    Explanation of a complex JOIN

    So, based on this text, You suggest that I remove the lookup fields and then build combo boxes from scratch? Don't be confused with the background color here. I mentioned that I use two different background colors to represent updatable and not-updatable fields, but in this particual case combo...
Back
Top Bottom