Recent content by DBrodin

  1. D

    VBA tutorials

    Learn VBA By Crystal Looks interesting. Thanks!
  2. D

    VBA tutorials

    Anybody have a recommendation for a good Access VBA tutorial? I want to figure out how to do some Boolean comparison of 2 fields in a table to determine which will show in a text box within a report. And not have someone here do it for me!:)
  3. D

    Solved Add attachment (pic) to a report.

    That did the trick!:D I taught myself just enough Access ten years ago to write the database for political conventions that tracked who was present, and from what district, along with about a dozen reports. The name tag module I added about six years ago as an update. Adding photos to the...
  4. D

    Solved Add attachment (pic) to a report.

    That brings the photo across, but it is loading every record. How do I limit it to the record selected in the form?
  5. D

    Solved Add attachment (pic) to a report.

    The photos are in an attachment field in the table, and attachment controls in both the form and the report.
  6. D

    Solved Add attachment (pic) to a report.

    I am trying to modify a database that I did for convention registration many years ago to print photo name tags for a reunion. My structure is a table (sheet 1) with names and a photo in an attachment field, a form (check-in) to select a record, and a report (Name tag) based on the record...
  7. D

    Network printing

    I may have stumbled upon the problem. It may that the ports for the printer are different on the different computers so the remote is looking for a port that does not exist on that machine. I am going to play with it a little.
  8. D

    Network printing

    It seems like a path issue, but I do not understand why. I tried doing the page setup from a remote computer, and selecting the shared network printer on the host, hoping routing the print through the host would cure what ever the conflict is, but that did not work either. My thoughts on the...
  9. D

    Network printing

    The "host" computer can print. The remote computers can not. If I redo the page setup from a remote computer, then that one works, but the main computer where the files are located can not. It is like there is a path issue, but with a network printer, I do not understand why.
  10. D

    Network printing

    I have a meeting registration DB. In the past, name tags were pre-printed. I modified the DB so that they are printed at the time of check-in. The system is structured as a simple shared access to the DB on a main computer, no FE/BE. The "remote" computers get a "printer not available" error...
  11. D

    extra white space

    After going through half a bottle of aspirin from banging my head I solved this. It was a paper size selection issue. I am using a Brothers QL-1060N roll printer. I have 2 3/7" tape, so my paper options where; 2 3/7" 2 3/7" x 4" 2 3/7" x 4 I have no idea what is different between the 2nd &...
  12. D

    extra white space

    A new report with the detail set to the same dimensions, the header/footer removed, and one small field added does the same thing. :banghead::banghead::banghead:
  13. D

    extra white space

    I am having trouble printing a report. It is adding extra white space to the bottom, which results in 3 blank labels being printed for each real one. There are multiple threads on this type of issue, but none of the suggestions seem to apply/help. I've deleted the header/footer, removed slide...
  14. D

    Print label upon update of record.

    That gave me the hints to go in the right direction with this. I was mentally stuck on printing the contents of the form directly. Making a report based on the form, then printing the report turned out to be relatively easy. This is my code. Private Sub Present_AfterUpdate() If...
  15. D

    Print label upon update of record.

    I am considering adding a feature to an existing database. I would like to print a label (in this case a name tag) automatically when a field in a record gets updated (the person is flagged present). Is this doable? Thanks, Dale
Top Bottom