Search results

sigh.... it stil cannot work! It is deleting the wrong record.... the code is I used it: If Me.SPFmCallRestriction2.Form.UserName <> User.UserName Then MsgBox "You can only delete your own entries" Else If MsgBox("Are you sure you want to delete this record?", vbQuestion + vbYesNo, "Confirm...

Thanks Bob! Sorry to give you so much trouble. To think that you have been teaching me for this entire year and I still make such silly mistake. sigh

Attached is the database. Thanks for your help Bob! If you go to the comments form, select the second or third row and click delete, you will see that it pops up the username of the first row. If you able to solve this, then I am able to continue to add in the delete confirm code. Thanks again!

ok. I try to upload it One thing I notice is that if I put "Me.UserName" on the onclick event of the "Username" field, it show the "UserName" value of that particular row. but If I select the entire row and put "Me.Username" in the before confirmdel event of the form, it does that show the...

Sorry man, It is not working and I am still trying to find out why. The Me.UserName does not give me the value of the field in the row that I have selected.

So is YourFieldWithUserName = Forms!formsname!UserName? UserName is the name of that field.

can I just disable the "allow deletion" from the form or use the "before confirmdel" event? My YourFieldWithUserName title is "UserName" Is Me.UserName same as Me!UserName? The reason that I ask if that when I code Me.UserName, the value is from my "=fosname()"

Yup. The row has the name of the person who added the data and my system has also recorded the user who is currently using the database with "=fosname()"

Hi, I am trying to create a form that does this: When a user wish to delete a row of information, the system will detect if that entry was done by him. If so, deletion is allowed. If not, an error message appears and deletion is canceled. Anyone done this before?

Hi, Thanks for the questions :) 1)I do not want to use grouping, but if I don't; like the message before that, duplicate data will be displayed. That is the cause of the problem and why this thread is created. 2)Nested form is used because other information are also display within the same...

The attached is the scaled down version of the one that I'm building. Click on FmDisplay to see the main form that will be used by my users. If you click on "O/B" that is marked as "Yes", a pop up form will be displayed. Main problem is that Product Code and Cat Code can only be edited if...

The comments is a stand alone pop-up form. The special field is just a indicator for user to know that comments are added for the specify products. Both table are join in the ERD. Therefore, when both table are added into a query, they are already connected.

Hi, I badly need help. I have two table (Product & Comments)that are connected by a one-to-many relationship. The Comments is a table where people can put multiple comments for one product. If a comment is added, a special status field will be changed from "No" to "Yes" This special field is...

Thanks for your help!!!

Hi, How do I ask MS access to search a particular record in a table and update a certain field after user have click on a "checked" button in a form? I tried the following code but failed. Please help. Thanks in advance!! Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim...

How do I change the record sourse via combo boxes? Do I use this method? I got this code from this thread http://www.access-programmers.co.uk/forums/showthread.php?t=121948&highlight=requery+subform Private Sub filterOptionGroup_AfterUpdate() With Forms!frmMain Select Case Me.filterOptionGroup...

Hmm... I will try to do that. Out of my 6 subforms, 3 of them are from the same source but display differently due to queries. Is that anyway to requery a subform so that it is able to display different information?

My database will be a multiuser environment. Anyway, The top part of my main form shows a few world clock and other details while the tab is slightly below the clocks. The size of the 6 subforms are 22" by 13" (I know, it is very big. the database is meant to be seen on a 30" monitor. The...

Forgive me but I forgot to mention that my subform is in datasheet view, therefore the combo box is located in the main form. Can i actually just have all 7 subforms in the main form and make 6 of them invisable? I believe that in datasheet mode is not possible.

Hi, I have a subform within a form. I also have another 6 additional subform. I am wondering if it is possible that to use a combo box to change the display of the subform. e.g. Form A is now showing subform 1. User click "2" in combo box and the form now shows subform 2. Is it possible? If...