Search results

  1. J

    Find out what users/workstations have .mdb file open?

    a far less exquisite solution, but also quicker if it works for you - if your app has front and back end, load all front ends in one directory with user related names - access generates a "ldb" file in same directory when app is opened and checking the directory for ldb files will tell you who...
  2. J

    MS Access 2003 problem for reports?

    am not sure that this is your problem, but one thing that we have seen is problems in conversion with any old hanging code - the conversion seems to hate any code which is not actually linked - so if you sometimes grab one old form or report to create the next one and you delete, for example, a...
  3. J

    Works - now it doesnt

    is it possible the form you're referncing isn't open?
  4. J

    Splitting names into Lname,Fname,Mname

    going back to the issue of initial set-up of the database - i come at my access use from a document assembly background and am never satisfied with the set up of most databases with regard to names - in the original posting scottgem recommends using five fields - consisting of salutation, first...
  5. J

    Text box capitalizes first weekday character

    or if you'd rather leave the default as it is, you can just set the format in the properties for the box to "<"
  6. J

    A challenge to say the least

    depending upon how your table is set up, why not just a crosstab query that counts all the cats on each day in the range for the reservation, giving you totals day by day - that way you have a report that tells you which days are problems, so you can offer that to cat owner to see if they can...
  7. J

    write vertical in forms / report

    sorry to disagree with reclusive monkey, but i think maybe you can accomplish this by setting up a subform to the right of your vertical text, grouping the report by the month and linking the subform - you'll probably want to add at least one datepart field to your query though - i don't know...
  8. J

    runtime access97 on thumb drive?

    the problem with that is that different versions of access cause problems for the application - one aspect of the program is the preparation of reports that are forms created by others - what we did was convert the pdf forms to bmp images - shrink the size down to 8x10 (from 81/2 x 11) and set...
  9. J

    runtime access97 on thumb drive?

    distributing it about on cd's is no picnic either and the installation on machines that may or may not have have other versions of access already installed or subsequently installed is no picnic - even when we were only distributing to 20 clubs - someone could spend full-time walking folks...
  10. J

    Linking to another database

    am sure others will have better solutions - but here's a couple of possible work arounds- import structure and data of linked table to your database and use autoexec macro to delete table and re-import each time your database is opened (so you're working off an updated copy each time and...
  11. J

    Inserting images in database to later view in report

    you may not have solved the problem was sorry to see that no one had come forward with a solution - i have similar problem, but i'm not sure that you've seen full extent of your problem - as you have, we embedded a number of graphic files in the reports (pdf forms converted to bmp so they could...
  12. J

    runtime access97 on thumb drive?

    does anyone know if it's possible to "install" the runtime version of access 97 (we do have developer's edition, so can distribute the run-time version) to a thumb drive so that it would run without having to install it on each computer that one was going to use the thumb drive on - is there any...
Top Bottom