Search results

  1. jwhite

    Error 3051

    This reference should answer your questions: Sharing an Access Database
  2. jwhite

    Queuing Theory

    A thought... Why don't you ask Armann directly if it is compatible with MS Access????? I believe he would give you the best answer. And if the DB Owner (usually NOT a user) knows nothing about the Queuing Theory, why not teach him/her?
  3. jwhite

    going from Access97 to Access2007

    Hi Mike, Have to side with Bob... Most IT shops want their company to stay with the latest versions, and that has been my observation with our flagship Access/SQL product having a client list of over 400 worldwide companies. With updating their install base to Office 2007, Access 2007 comes...
  4. jwhite

    going from Access97 to Access2007

    The time it takes you to install your package... :) MSAccess.EXE (Full Version): Loads accessible Wizards for Design "Assist". LaunchAccess.EXE (RunTime): Does NOT load the wizards. It is a 'deprecated' Design Mode, unless you include a startup form or use the Autoexec Macro to automate...
  5. jwhite

    Is using update query correct in this?

    May I humbly ask, please don't post a question in multiple forums Utter Access Post).
  6. jwhite

    going from Access97 to Access2007

    You would have to buy the license to DISTRIBUTE a copy of Ac2003 Runtime with your application installer. Your installer would then first check if full MS Access is already installed -- if not, install the Ac2003 Runtime before installing the rest of your application. Correct, getting the...
  7. jwhite

    help with sql syntax plz

    A quick look shows you have quotes around the database name: USE `jptulowiecki_db`; Change that to: USE jptulowiecki_db GO Also, it is good practice to put GO under each process. If an error occurs, SQL will roll-back any changes before the last GO. So, if you don't have any GOs, then the...
  8. jwhite

    going from Access97 to Access2007

    The Ac2003 runtime was always distributed with full Access 2003, and developer licenses could be bought for distributing the runtime version with applications for execution on systems without full MS Access. MS no longer sells Ac2003. The Ac2003 Developer Extensions can still be had by buying...
  9. jwhite

    Setting a file attribute to System or Hidden

    And I recall now a thing with Vista and Security.... Many (most?) IT Groups do NOT give users read/write permissions to folders under C:\Program Files. As we know, users require R/W access to the location storing the .MDB files (for creating .LDB files). In that a .MDB is essentially a...
  10. jwhite

    going from Access97 to Access2007

    Actually, it's my experience that very few in the professional world still use Access 97 -- the reason being that installing a full version of Office brings along the next version of MS Access. I started with Ac2003 and haven't had any interest to look at Ac1997 code. You are correct that...
  11. jwhite

    Open File Dialog / Folder Browser Dialog

    IMO, the API is better as it does not require Office to be installed (from what I see above). Every now and then, I run across a PC without Office.
  12. jwhite

    How to get record count to update as records are added

    Add 'Record x of y' count on a form (navigation)
  13. jwhite

    hourglass delay

    Another consideration: Instead, play a sound clip: API: Play MIDI/Avi/Wav files
  14. jwhite

    Add Pictures to My Records

    How to include a bound picture on form
  15. jwhite

    how to hide linked tables in database window with VBA

    scren: To get the users away from the DB Window, you might be able to utilize this concept with some modification: Universal Report Filter (QBF, URF)
  16. jwhite

    Decimals ending in zero

    OP: Seems to me you have (2) values in (1) field -- breaking them apart will simplify the formatting/sorting for you. And converting them to Text is best because they are references - not 'live numbers', as Bob and several UA members have suggested to you.
  17. jwhite

    going from Access97 to Access2007

    Converting from Access 97 to Newer Versions Converting from Access 97 Converting to Access 2007
  18. jwhite

    Access 2007 Horizontal / Vertical spacing

    Those options were never on the shortcut menu (even pre-Ac2007). But I suppose you could customize your own shortcut menu.
  19. jwhite

    Setting a file attribute to System or Hidden

    I would foresee no problems with that. Many Developers will make a folder under C:\Windows for these files. As a user, I would personally prefer that over dumping it in the C: Root folder. Or, also common, keep it in the same folder as your MDB.
  20. jwhite

    Open File Dialog / Folder Browser Dialog

    Not sure what method you are referencing, but the most common and easiest to use are: API: BrowseFolder Dialog API: Call the standard Windows File Open/Save dialog box
Back
Top Bottom