Search results

Hi I am sorry I wrote wrong. I am talking about normal form. I wanted to say that I then also created a form in datasheet view- to add records-links ( becouse that i get confused with subform) I am sorry.

Hi Yes ,I read some time ago about algoritms and SHA hash functions. It is interesting to me to know How all that started how access know how to encyprt all that..how the person who write all that know to do it? I know that some data can be encrypted in access..like the table with...

Hello experts I want to create some Link form and then inside I want to have subform where I will add links. I want to manage with button add link to add links one by one to the subform. and with button delete ( if user will make mistake) I want to delete the selected record. I manage to...

Hi Pat I apoligize if i didnt say nothing before but yes i liked your presntation in your videos. You are exlaning very clearly so is very nice to follow. Thank you🙂 PS: Do you have plans fore more videos like this in future?

Yes I just watched the videos, first video= 29 min, 2 video= 11 min. I mean you are the Michael Jordan in MS Access world. From the early start of the program until now already 30 years later. Now I will start to play with the database. Thank you

Hi Pat I just downloaded your database. I will play to see and learn how is working. Thank you very much for your excelent work you make and for all you are sharing with us beginers. PS: Remember Michael Jordan? thank you :)

Hi Pat, thank you very much for your explanation. Where I can learn more about form's event model? I will start looking on internet but if you have something more detail explained I would apreciate if you can share with us, the beginers in ms access. Thank you very much

Hi yes I will try to make that with my query. thanks again

Hi Pat, Hi Minty yes I will take note of all your suggestions. I will try to use After Update and test it and then I will think how to convince my users that they will have to look for the status from another form that I will create and explain then that status has to be in one table and that...

Ok yes you are right I will change that and yes I need to have back status New..but how I can write that? can you show me some example? Is correct to use my query on Unload event? Should I use another event? thank you

I also try it to use query like you say. I put it on the Unload event is like you say max(dateInTableB) but then I have a problem...if user go to the form B open a close the formB then I have a empty field in tblA, becouse the user didnt make no new entry he didnt use the item...? then I...

Yes I know that I shouldn't keep the status in two places ( a lot of experts told me that here) but how then to show the correct status to the user in form A?( from tblA)? Imagine I have form A ( from tblA) this table contains all the items that are entered. Here the status is New, becouse...

Hello experts, I have two tables, tblA and tblB. In tbl A are all the items, tblB is storing the daily usage of the items. Both tables has field status and this status field must be the same in both tables. I am using this line of code to perform status update from tblB to the tbl A. I am...

Hi I think I finally managed it. I will do a lot of testing to see if what I am planing/doing is correct or not. Yes you are right, with that I resolve 2 problems,..no need to extra messages if is entered or is empty....ohhh I complicated it all. 🤔 Thank you very much.

hi yess also my mistake..I didnt notice that before...i am blind all day with my dlookup code who isnt working..ohh thank you very much. I will try to implement your suggestions.

Hi yes you are right, I wanted to tell to the user what is wrong if he can not go to new record. Becouse that I use entered and empty. Now i get some errors in module : I insert that in module: Is that correct? my code now in the form:

Hello MayP Yes I know what you mean about the no need to check empty or entered. I need to do that becouse i need to prevent that user go further and used it. He can use only if is approved. I am trying your solution now and I get little error: variable not defined ...access marked me in...

Hello experts, I need some help with extracting some value from a table. I was thinking to use Dlookup function in my form procedure. But then I get stuck. I have tableA who stores general data about items. Then I have tableB who stores data about usage for that items. The table A is mother...

Hi Ebs17 yes I agree.