Search results

  1. I

    Compact a Back End OR a Front End Database

    I am aware of the various methods to compact databases" Access 2003: Sendkeys "%(TDC)", False Access 2007: Sendkeys "%(FMC)", False Access 2010: Sendkeys "%(YC)", False accDoDefaultAction Method DBEngine.CompactDatabase SourceFile, DestinationFile I'm still playing with the SendKeys option...
  2. I

    Speedometer/Dashboard Chart

    Realizing the charting limitations in Access, has anyone undertaken the task of creating a speedometer chart in access? Most of the tutorials I've found deal with Excel.
  3. I

    windows 7 and office pro 2003

    Damn, I'd be happy just to get away from Access 2000 here at work!
  4. I

    Logging Errors

    I collect the network user as well as the PC name. That way I can isolate things to a particular user or machine. I also collect the access version information. Though I haven't really found the need for the information yet
  5. I

    Looping file count limit?

    No wonder I was only getting a partial list. As much as I use the immediate window, I probably should have known that. Thanks.
  6. I

    Looping file count limit?

    This has been driving me batty for a few days. I am trying to perform a simple task and loop through a folder to retrieve file names. The problem is I only get 199 files and there are over 400 in the folder. Here is my latest code: Sub File_Import() Dim FSO As FileSystemObject Dim...
  7. I

    Multi-user/network issues

    Does each PC that is accessing the back end have it's own "front end copy" installed locally? Or is each user accessing the same front end on the network. If the latter, that's a big no no.
  8. I

    Can you....???

    Why not set the icon in the startup properties? Not sure it's what you're after though.
  9. I

    Question Shared usage

    Splitting the database and putting a copy of the front end on each user's PC is one of the rules for multi-user environments. Have a look at the Ten Commandments thread. By not splitting your database, it's just a matter of time until something becomes corrupt. To answer your question about...
  10. I

    Change txt file from 1 row to 1 column

    Hi Boyd, You are right, wasn't very hard. So no need to post any code. I always like to try to figure it out myself. To answer your question, I used CR+LF. Craig
  11. I

    Change txt file from 1 row to 1 column

    I am not sure if this is even "doable," but I have the following task. I have a comma separated txt file where all of the values are in one row and separated by commas. There are over 500 values. Why the output is like this is beyond me, but it is. What I need to do is replace each comma with...
  12. I

    Question Looking for the BEST way of learning VBA SQL

    Sheesh... and I would have done it for $90/hour. :p Really though, the books Bob listed are well worth it to have in your reference library.
  13. I

    Automatic Email Generation !

    Here's another useful link: http://www.access-programmers.co.uk/forums/showthread.php?t=164429
  14. I

    Front End VERY slow

    Will replication work in this instance?
  15. I

    Database almost complete, what about maintenance?

    You're not alone there, many companies are like that.
  16. I

    Database almost complete, what about maintenance?

    David, As far as the installer, I have only used it messing around and it was extremely easy to use. I also believe it will do what you ask for OCX. See here. Craig
  17. I

    Database almost complete, what about maintenance?

    Yes there is. Check this out. The downfall is many companies require IT support to run installers. They usually don't allow users to install anything. I like manually deploying my FE apps to each user, then using Bob's update utility. That's in the version that I have. The problem I have with...
  18. I

    Issues with record locking - multi user environment

    David already mentioned this, but if the above is true, it's a cardinal sin to have all users on the same front end. Each user should have their own copy of the front end placed on their respective PCs. As far as the locking, I'm not sure it will help but make sure each user's GUI is set to...
  19. I

    Runtime Error '3043'

    Commandment #6: Thou shalt split thy databases. :D
  20. I

    Question Open .mdb file and just edit/save forms and reports?

    Have you tried using the bypass key? Open the original file using File --> Open and hold the shift key while you open it. Can you see the database window/navigation pane (all the tables, forms, etc) after doing that?
Back
Top Bottom