Search results

Ohh I just have a tought. Maybe a workaround way for it. When the user open view the record form, it will update the field with their username. So there is a check before the record is open. If the field is empty, then the user that open the record has name in the field. If the other user open...

So without locking the record is it possible to know who is accessing the record?

I have set an idle timer to kick the user out the database if he is idle. I will need to find a way so tat 2 user do not edit the record at the same time. Also, I do let Access handle the record lock. I just set the lock-edit in the options Advanced, so Access is still controlling it right?

Hi, Can anyone guide me, if it's possible, how to display the current user Environ(Username) that is editing the record? I have set my access options to lock the record if a user is in the edit mode, but if I create a field [rec_user], is it possible to display in that field the user...

I guess I figure it out. I only need to send all the after update to a function using In case anyone have the same issue. Thanks

Hi, I am having trouble figuring out how to do this: I have form in continous form with a form header that has some field and in the form section, it has the record listed. Whenever the data is entered in the field on the form header, there is a command button to validate the field...

In our database, we are creating a profile for each customer of their order. The items are generated via our mainframe server which result in a table (tblItem). Because the result generated from the server cannot be changed, thats how the IT programmed it, raw data. Usually, we will select each...

There is no query because that is what I need to do? I tried the query wizard but it doesnt give me the result I wanted so I deleted it.

Because the difference here is I want the query to update after the selection and not before the generation of item.

The database I am creating is huge and I cannot pull out the sample so i am creating this small sample which gives the same idea of my actual database. The listing item are generated from our mainframe server and the user have to select the desire item to add to the member profile.

Hi, I am having trouble to figure how to do the query to group items together, and sum the cost of a the group field based on the selected item only. I have a subform that has a list of all item and selection box. I have a subform with a subform that list the selected item but in a...

Thank you very much! This really help me through my relationship development and thanks also for responding to my question. I am pretty sure once I master access for several years, it will be much easier for me.

I cant joint the Relationship from tblEnrol to tblExam??

Thanks for your help. The main unique identifier here is student_id, that is why I carry that same value over table. In case I want to pull the activity of only a student, i will only need to filter the student id off the tblActivity. John Corrector only fit to Class/Exam. An exam can be...

Hi, I Wonder if the use of Relationship is absolutely needed to build an access database?? There is an alternate way to work with table without having them in Relationship. I have read thru many document about Relationship, but I still cant figure out the way to work around what I...

Hi, I am trouble finding way to make my subform to display only unique value, even the Index is set to Duplicate Ok. I have a list of client that can have more several product. The product for each client can be the same. For each of the product, I need to specify the quantity, the price...

Thank you! I knew u had to save the record first, but I used : docmd.save which didnt work.. Thanks!

Hi, If I am using my access to add new record manually, then it does not have a problem. However, if I want to add data via VBA, then I have error. Here is the code that I am using to add new record to the subform that has table related to another table, but I always get the error...

Oh nevermind. I figure it out. The changes were made to the second form, but not to the first form. Since the second form subform is linked to the mainform subform, i have update the record on the mainform subform, then everrything works now.thanks

Hi, I have looked kver many site for solution and many tries but still does not work so I am wonderin if anyone can help: I have a mainform with subform filtered on onload event. I am using docmd open form dialog to open another form, then when the changes is made to the record, then when...