Search results

  1. J

    Audit Trail Option in Access

    Hi Khalil! You will find what you are trying to do in the attached app. Note that I am using alas Access 2013. The main menu is a dummy to illustrate the log features. You can very easily generalize its utilisation (form usage, rec. mods, etc). Good luck.
  2. J

    Running Local Help file within MS Access 2013

    Assumption: they want to dump Access because overall, they found that it's usage as a system development tool is declining... Just found this one: an Access web app cannot be encrypted!!!! So who is going to be silly enough to develop web apps??? I thing that Access days are counted...
  3. J

    Running Local Help file within MS Access 2013

    vbaInet #13: The help download was a rather small .chm file: are you familiar with that? It's a good old days format produced by a Help file maker (forgot the name) and it's definitely obsolete. It's not a drop down but a text control. Bottom was cliped because there is nothing...
  4. J

    Help with my tables

    Answering #24. The presence of EventID is an error: ignore it. Cost: I thing I didn't understand your treatment of costs. So in CostSources, Cost is the unit price. ShowCostSources.Cost makes it possible to increase or reduce the unit cost. Ex. Unit price of a table is $325 but you used 3 so...
  5. J

    Help with my tables

    Hi Infinite! Except when he gives his opinion on autonumber :p , vbaInet his always right! You have to understand that your project is not so simple and that a properly adressed project his likely to last all the way. Attached is a proposed schema (I'm an old timer...) for your project...
  6. J

    Running Local Help file within MS Access 2013

    Done: doesn't work!!! Not connected to Access, not stored in 1033, not stored in downloads. Here are the screenshots you asked for.
  7. J

    Running Local Help file within MS Access 2013

    Could it be you still have A2007 installed? When both were running, I had the same problem: an empty screen... vbaInet: I cannot get that screen because HELP button on A2013 is totally different: no automation? goto web. No web connexion? you only get a limited help on ribbon usage!!!
  8. J

    Help with my tables

    MarkK: did you download his DB? I did and there are so many flaws in there that it should be remade from A to Z!!! Mr Infinite should first work post #3, and then any web tutorial on DB normalization...
  9. J

    Running Local Help file within MS Access 2013

    I get no message, just transferred to web. F1 does the same... vbaInet: you see, he is going through the same sh.. I did, doing the same error: MS does not document it but if you have A2007 and PLAN to upgrade to 2013, one should uninstall A2007 BEFORE switching to A2013!!! By the way...
  10. J

    Database Checklist

    Can be done easily and efficiently: 1 - Create 2 tables: CheckLists -> Questions. 2 - Create a form that displays the Questions contents: a second form is used to load it with proper CheckList ID. 3 - USE THE Question FORM to create a report: select it as a subreport!!! 4 - Use the second...
  11. J

    Running Local Help file within MS Access 2013

    Hi Oluyemi! Same with me!!! It occurred after uninstalling A2007: this clears automation register entries and I think that's why we loose help. What version did you uninstalled?
  12. J

    autonumber problem

    Uncle G goes: This issue is so poorly formulated that written in Katakana, it would not be more obscure. The procedure seems to be wrong, updating records using Excel is strange (to be polite). This site should have some procedure (or volunteer) to filter out that kind of post...
  13. J

    get database to send email

    Here is what you need: https://msdn.microsoft.com/en-us/library/office/ff197046.aspx
  14. J

    Access 2003 Project

    A very similar issue was posted lately. Here is my suggestion: - Create a form with 2 tabs: page 1 for Advisory and page 2 for security. - Clean up the MS garbage in the header and create in it a combo for the systems - Create a query on Advisory table, sorted by System (whatch out this is...
  15. J

    I need help!

    Validate the info: make sure you have a month and a region before 'doing it'.
  16. J

    To open a second DB - Access 2013.

    Don't be mistaken: you have a deep knowledge of Access technicality. It's not a matter of hacking but finding a fault in my solution. I really thing that I found a very dependable solution and you are probably the only one in this forum that could break it!!!
  17. J

    To open a second DB - Access 2013.

    Hi vbaInet! Thanks for this one! Have a tooth on this one!!! Good night, JLC.
  18. J

    To open a second DB - Access 2013.

    Hello vbaInet! Holly shmit I will put 100 $CDN on this one!!! But wait a sec: you will have to define the time you need to break it (the bet will depend on it...). To get path, etc. I use this: str = CurrentDb.Name P = InStrRev(str, "\") PathBE = Mid(str, 1, P) strBE =...
  19. J

    To open a second DB - Access 2013.

    Hi vbaInet! No it's not my morning routine but this automation issue became an obsession: I am finalizing a procedure to deliver a highly secure (I really mean it) Access app to a customer: no links to data file and no queries, BE super protected (can't be opened), unreadable modules...
  20. J

    To open a second DB - Access 2013.

    Hi vbaInet! You are right all the way. Here it's quite early: I will have a look to you registry screenshot later this morning... This automation issue makes me mad!!! Good day, JLC. SOLVED!!! 8:30 AM Sipping my 1st coffee, I started random research to solve my issue. I found (plain luck)...
Back
Top Bottom