Chris,
Thanks a lot, It works fine. Much appreciated
Have a great day!
Aaitaman Tamang
Last Activity: Feb 4 '12, 10:12 AM
Joined: Jul 16 '11
Location:
-
Aaitaman Tamang replied to Listbox (Add & Removed selected items form one listbox to another listbox)in AccessSeth,
Thanks a lot for response. as you required, the ListBix1 is bound to "EmpT" and the second ListBox2 is not bound to anywhere. Yes, I am trying to transfer items from one list box to another list box by using pointing right and left Command buttons.
Any Help?
Thanks,Leave a comment:
-
Aaitaman Tamang started a topic Listbox (Add & Removed selected items form one listbox to another listbox)in AccessListbox (Add & Removed selected items form one listbox to another listbox)
Hi everybody,
I have two listbox in my form, the name of listbox is “ListBox1” and another is “ListBox2”. The ListBox1 Row Source Type is (Table/Query) where users will see all the employee Badge number and name. The column count is (2) and multi select is (Simple)
Now I have another ListBox which name is (ListBox2) in the same form. I also have selected the Column Count 2 and multi select is (Simple). Now my aim to... -
Thanks for help,
I have tried already and still. I have done a bit of modification using your above code. Seems like cool but did not get any details in report view. I have checked my table to ensure that the table has a record.
May be i am not good in VBA. But i still have to ask you for help. While using above code do i still have to have Query or not? Basically i have Query and have this Criteria (Between [forms]![RunReportF]![StartDate]...Last edited by TheSmileyCoder; Nov 16 '11, 12:03 PM. Reason: Added [Code]...[/Code] tags for you. Please remember to add these around any code you post.Leave a comment:
-
Hi TheSmileyCoder,
Basically i have form where i have two unbound text boxes one with StartDate and EndDate which are name of TextBox also there is Combo box with incident type. Of course there is one table with all this archived details of incidents.
Now i want user to open the form and type the report date such as from 10/15/2008 to 10/25/2010 and select the incident type and just hit the button. When user raise the event...Leave a comment:
-
Query Help
I have created table called “rptLocati on” and have all incident details. I have incidents that are categorized such as First Aid, Near Miss and etc…..and the records are archived in a table based on occurred date of these incidents....
Now I want to have Query that gives me just the total of those incidents base on my Criteria. I am preferring to have form where user have to type their date selection in the text box such -
Aaitaman Tamang started a topic Insert images and chage in bound form based on each employee record using VBAin AccessInsert images and chage in bound form based on each employee record using VBA
All,
The form I have built up just right before contains the employee’s details. I would love to get help to link to the images base on each record. We have more then 3000 employees in this project and would love if someone helps me how VBA can get link to folder where all images are stored.
I don’t want to store in table because it will get bigger and bigger and hoping it’s not the good ideas to do that way.... -
MTB,
Thanks a lot for sharing. I have already resolved this task, The following has been used instead of earlier one and working perfect
...Code:Select Case Me.MyName Case "aman" With CommandBars("MyMenu").Controls(1) .Controls(1).Enabled = True .Controls(2).Enabled = False .Controls(3).Enabled = False End WithLeave a comment:
-
Dim or Disable specific sub-menu items using VBA?
NeaPa,
Following code in used for disable sub-menu items for specified user. The problem I am having is one of below user is not able see it (Mean disabled the sub-menu items) I want both of them to see sub-menu when they currently on database. Any there is anything wrong with this code which causing one user unable to use sub-menu items.
...Code:Dim blnShow As Boolean blnShow = Nz(StrComp(Me.MyName, "aman", -
NeoPa,
Thanks a lot. I have resolved this problems. The following are codes i have used and working fine
Thanks,Code:Dim DP As Variant Set DP = CurrentDb If DP.Name = "C:\Documents and Settings\ATAMANG\My Documents\DiasblePath.mdb" Then Else MsgBox "You are not in the original source. Please ask your Database admin for help" DoCmd.Quit End If
...Last edited by NeoPa; Oct 29 '11, 02:35 PM. Reason: Added mandatory [CODE] tags for you and split new question into separate thread.Leave a comment:
-
How do I Disable or Dim Sub-Menu Items Based on UserName
I have my own menu bar which i have created called "Angola LNG Incident Reporting". My intention was to dim or disable sub-menu items base on user name.
Following code i am using right now. It works just fine to dim but doesn't appears to be working base one user's name. Is there any thing wrong of doing this.
...Code:If Me.UserName.Value = "aman" Then CommandBars("Angola LNG Incident Reporting").Controls(1).Controls(1).Enabled -
How i can stop users running MDB file from another location?
All,
I have MDB which located in network drive, sometime user seems to be copy from drive and pasting in desktop. As i have faced the problem earlier i would like to stop the MDB running from another location now. Any VBA to specifying the path where user can't run MDB from another location. Is there any VBA to fix this problem? Any prompt reply huge appreciated
Thanks, -
Add another table using same openrecordset
All, Any Help to solve my problems?
I have been trying add some more table using below VBA codes but still i have not got any ides how to do this. As you all can see below ("ElectricalFoc usObservationT" )Table for my Electrical description that will store when i click and working fine but how can add another table using same openrecordset for another table. I mean, i have another table called "General Fall ProtectionT"...Last edited by Niheel; Jul 29 '11, 08:56 AM. -
Show Value with No Decimal Places
** Mod Edit **
This additional question was moved from How to use dsum function in unbound form.
***
Rabbit,
I need one more help from you. Below is my control source of unbound text box where i get total percent
i am using this=(Round([Safe]/[Obser],0)to rid of two digit which i don't want.
I think should solve my problems but still have 100.00% with two digits
my goal is just like this...Last edited by NeoPa; Jul 23 '11, 01:17 PM. -
Rabbit,
Is there any VBA codes for sum or dsum function. As i fixed the problems yesterday occurred another.
I want VBA to sum two value in one unbound textbox.
example:
Text Text Text Text
Safe + AtRisk = Observed Total%
Safe1+ AtRisk = Observed Total%
Any help?Leave a comment:
-
Rabbit, i Just fixed my problems but i still prefer to see your codes. Can i have the example?
ThanksLeave a comment:
-
How to use dsum function in unbound form?
I have form called "FocusEntry " with unbound field
There are three field named with three different field name
1-Safe
2-AtRisk
3-TotalObserved
4-Safe
In "observed" Control Source i have wrote code as following =(Val(Nz([Safe]))+Val(Nz([AtRisk]))) to get total sum
In "Safe" Control Source i have wrote =to get total...Code:(Val(Nz([Safe]))/Val(Nz([Obser])))
Last edited by Niheel; Jul 21 '11, 03:19 PM. -
Adam,
End of the day i have fixed it.
Thanks a lot for helo & information shared with me.
Good day!Leave a comment:
-
Adam, I will try this by using but i am using 2003 and there is no option as said. should be another way on 2003.
Its little comlicated but i should be able to get help of my needs soon.
Thanks a lot for your help.Leave a comment:
-
Adam,
Thanks for reply. I have the same code alreay in used and it is working fine as intended but i was looking for something else where i can use vba to disable and enable the secondary menu base on valid and invalid user login. I certain that you can help me on this. I am give you screen print to easy understanding of my needs.
I am using my own menu bar called "Incident Reporting" from Tool-Start Up and menu bar....Last edited by Niheel; Jul 18 '11, 10:21 AM. Reason: Post your screenshots on the site, don't request for emails.Leave a comment:
No activity results to display
Leave a comment: