Search results

  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
  16. D

    Splitting attachment field from table

    After doing some experimenting, I decided the easiest way to deal with this was to put each records videos in a separate folder, then link to the folder. (I had mentally been stuck on links going single files, and missing that it would work for folders too). It took a long day to move things...
  17. D

    Splitting attachment field from table

    I think I half follow that. I do Access seldom enough that I have to teach myself over again each time. I'll refresh myself on M:1 table links, then get back to you if things don't click in my mind. Dale:)
  18. D

    Splitting attachment field from table

    I have a database composed of personal statistics. (name, age, height, wt, etc). I have two attachment fields. Photos and Videos. Each of these fields can contain more that one file. The size of the video attachments is starting to get me up close to the 2 GB database limit. If each...
  19. D

    Count of "true" in a crosstab

    I have it working with my kluge, and I have a convention on the 12th that I have to have it functional for, so for now I'll leave it alone. I do want to clean-up my design. I have a lot of kluges I've used because I couldn't come up with a simple solution for things I'm sure there are more...
  20. D

    Count of "true" in a crosstab

    That almost makes sense. Where I get lost is that it looks to me like triple state can be set in the form properties, but not in the table properties. Since my report is counting the non-null values in the table, I still am getting a count of both yes and no. BTW, I worked out a kluge work...
Top Bottom