Rdcarlson65
New member
- Local time
- Today, 02:54
- Joined
- May 16, 2021
- Messages
- 4
Okay, not sure where to post this, under forms, tables, general... So just going with Tables. Anyway...
I am writing an access database for my job at a Condo Complex. I am learning as I go, so I am sure there is a lot of sloppy non-standard programming. Please forgive.
My problem is that suddenly my attachments aren't saving. If I change an attachment in a form, it shows in the form. I can move forward and backward in records, and it still shows. Problem is, if I pull up the table it is supposed to be saving to, it shows "0" next to the paperclip. But I CAN change the attachment directly in the table itself. I have different forms with their own various attachments, and the problem seems to exist in all forms. Other form elements appear to work and save properly (Text Boxes, Combo Boxes, etc...)
As I said before, I am sure I have a lot of sloppy and questionable programming. But I don't think that applies here because if I just load up my database and go straight to the attachment and try to edit it, I have this problem. None of my other vba or macros should have any affect because they are never called.
Now, I am assuming that when I change the attachment, Access is probably saving it in a temporary file or something. If that is the case, how do I force it to update the table from the temporary file? I have tried changing the attachment and changing focus to another text box, exiting the form, clicking save... Nothing is seeming to work.
Does anyone have any suggestions as to what I can do to get this working? Could it somehow be a problem with my computer, and not Access?
I am writing an access database for my job at a Condo Complex. I am learning as I go, so I am sure there is a lot of sloppy non-standard programming. Please forgive.
My problem is that suddenly my attachments aren't saving. If I change an attachment in a form, it shows in the form. I can move forward and backward in records, and it still shows. Problem is, if I pull up the table it is supposed to be saving to, it shows "0" next to the paperclip. But I CAN change the attachment directly in the table itself. I have different forms with their own various attachments, and the problem seems to exist in all forms. Other form elements appear to work and save properly (Text Boxes, Combo Boxes, etc...)
As I said before, I am sure I have a lot of sloppy and questionable programming. But I don't think that applies here because if I just load up my database and go straight to the attachment and try to edit it, I have this problem. None of my other vba or macros should have any affect because they are never called.
Now, I am assuming that when I change the attachment, Access is probably saving it in a temporary file or something. If that is the case, how do I force it to update the table from the temporary file? I have tried changing the attachment and changing focus to another text box, exiting the form, clicking save... Nothing is seeming to work.
Does anyone have any suggestions as to what I can do to get this working? Could it somehow be a problem with my computer, and not Access?