Search results

Thank you all of you for your help. Problem solved. 1) Uninstalled netframework 4.8 and installed 3.5 sp1. Restarted pc. 2) Launched my app, Now I got different error (no more previous automation error mentioned in post title) I got this error (error 91 In SHA256: Object variable or with block...

@Gasman @The_Doc_Man Today after my system update, I started getting this error. I knew that this error is probably for .Netframework, which is used in code. Therefore I downloaded the latest one 4.8 developers one. Did windows update. Still have the same problem. Not yet tried, but probably...

Thank you @CJ_London , @Pat Hartman,@Gasman @The_Doc_Man The same Ms Access app, of which I have not changed this code since months. Because of this error I transferred in USB ( merged front backend), and tested on my personal PCs 1) Main PC: (win 11 , 64bit and Office 2021 64bit) Till...

You are right, Sorry my typo error. Code error number is -2146232576 , I will correct in above.

No change in bit, before and after pc has 64bit. Accdb file works fine on my other two pcs, even on this pc as well before this fresh installation.

Hi, May be some one specifically knows about this problem and solution. I am using SHA256 hash function for password and some other things (app security). This function has been working fine, without any problems for the last 3 years, with mutli-User app (more than 35 user accounts). Hashed...

This is also very nice approach. At 1st to add main field (Master - Product), then click to on edit button to add its further children via multiple tab controls. So, this way, it will avoid any confusion to add all data (including master, children) in one go. Thank you very much.

No I did not went to navigation pan. Thanks a lot for your support and help.

The file which is attached above, Form1 is not acting as data entry form (as new record) - Parent form has record at ID 3 and will stay at ID 3. Only subform accepts new entries.

Nice idea of junction table. In my case comments (multiple) will be specefic (linked) to a product. ie different for each product.

This is nice to edit / update both master and child records, and to add multiple child records. But this does not allow to add new records. In my case it is about new records. For example: Master record: PID Product etc Child Record: Which is...

Yes your point is right, that if temp is in front end and user postpones half way. But the things will not work like that, it can never happen in my case. It may vary from person to person, but in my case it will never happen. Though I have not explained above all this, how will I implement this...

@gemma-the-husky There is no record in my db as orphan, offcource Masters can be orphan otherwise child is always linked and have FK. Yes offcourse it is like that in my case. This is how I designed, and made a different table to have multiple comments of a single product. This is only possible...

Considering your point 2, mentioned before (temp table), I did this. You are right, therefore Instead of update or append, I have tried Insert statement in demo db. So, on save button, I used both statements (Insert and delete) - basically inserting data from temp to main table, and at the same...

Point was 100% clear to me, when @arnelgp gave me an idea that temp table will reside locally. This sentence answered my all questions. Therefore, I will use access normal ways (Master/child relationship forms). Update to main table and delete (from temp table) will be in my Save button. This...

Thats totally right. And thank you for appreciation. When a member like me posts here, so Experienced members comment here to help us. Even if they argue or whatever, basically they have taken time to guide us (me) for no reward. So it is my duty to respect all those and it should be like that.

Okay, thats also nice to know... then this will not harm... so cool..😀

At 1st I must have to say thank you to all, because I learnt from this post like every day learning. I will try to implement after considering practical possible situations. Temp table, will cause problems in Multiuser case , because it will be a multiuser app. Because what if another user makes...

Yes Exactly . . -Same product can be from many suppliers. -Different products can be from same supplier. -Each product can have different dimensions/varient.... -much more But this all is not a problem.... The point which I am making here is.... Multiple line comments for same products.. To...