Solved strange attachment behavior in a form

[TipsyWolf]

i have a main table with one of the 2 data type

when i add these 2 fields into a form, one of these 2 acts very wierd for me. it adds "FileData" into a countrol source without me wanting it.

when i manually go to change countrol sourse it already set *FileData to it.

and chaning it to"picbefore" doesnt help... like it doesnt care my seleciton. it still goes back to *FileData.

I tried to remove 2 data type field from main table and add again. - no luck.

its very impormant to me as when i double click on it - it doesnt suggest me to add some attachmets. or even when i right click on it - a Manage Attchments is grey out

what do u guys think might be a problem is ?

 

[theDBguy]

Can you post a sample db with test data?

 

[TipsyWolf]

Can you post a sample db with test data?

sure ! here it is.
open a RiskPage form and try to add 2 attachment objects. picbefore and picafter.
i removed evertything that makes a db weights less than 1mb.
thanks for helping

 

[KitaYama]

I can't read Russian.
Is this what you need?

 

[TipsyWolf]

I can't read Russian.
Is this what you need?

yeah, but how did u do that ?

thank u very much ! could u please explain to me so i know how to fit such problems.

 

[TipsyWolf]

and not only fix such problems in a future, but also i need to know it cause i need to implement it in my original DB. I just copied these 2 objects and they have the same issues (picbefore is not allowing me to attach an attachments.
it must be some manipulaiton in database itself

 

[KitaYama]

and not only fix such problems in a future, but also i need to know it cause i need to implement it in my original DB. I just copied these 2 objects and they have the same issues (picbefore is not allowing me to attach a attachments.
it must be some manipulaiton in database itself

Check the record source of the table.
Your record source was not correct.
Copy the record source of the file I attached and use it in your original database.

 

[TipsyWolf]

Check the record source of the table

u meant source of the form ?

i just added everything to it and it did the magic. now PICbefore is allowing me to attach an attachments.

 

[TipsyWolf]

Check the record source of the table.
Your record source was not correct.
Copy the record source of the file I attached and use it in your original database.

View attachment 113399

thanks a lot !!!! i appriciate your help.
saved me tons of time

 

[theDBguy]

Nice work @KitaYama

Thanks for the assist.