Here is an outline of my process:
1. I submit score cards to suppliers on a monthly basis.
2. I have a table with supplier names and email address. If the supplier is currently active the “Inactive” check box field in that record in not checked. Additional suppliers could be added at any time. Existing suppliers could become inactive then reactivated at a later date. Only active suppliers (those without the “Inactive”...
chip0105
Last Activity: Sep 19 '14, 04:41 PM
Joined: Nov 1 '13
Location:
-
chip0105 started a topic Email filtered report by Supplier from a list of email address in Supplier tablein AccessEmail filtered report by Supplier from a list of email address in Supplier table
-
I would like to try this function you provided. However, your coding stopped at the end of line 23. Can you provide the rest of it please?
I am actually creating several temp tables then using those temp tables to populate another table with the collected data. I am not much of a vba programmer; I can read code, follow it and somewhat understand what is being done, then make some "tweaks" to make any changes I need. However,... -
I thought the question was fairly straight forward. I hope this makes a little more sense now.
I need this type of ranking:
BU1 Supplier1 Score 28 Rank1
BU1 Supplier2 Score 22 Rank2
BU2 Supplier1 Score 35 Rank1
BU2 Supplier2 Score 27 Rank2
BU2 Supplier3 Score 27 Rank2
BU2 Supplier4 Score 22 Rank4
Not this type of ranking:...Leave a comment:
-
Ranking Query between 4 groups of data
I have five Business Units; BU1, BU2, BU3, BU4, and BU5 is ALL four BU's (scored values are totalled across all BU's).
Each Business Unit has the same suppliers with individual monthly score data.
I want the ranking to be seperated between each Business Unit; BU1, BU2, BU3, BU4, and BU5.
When I use the following rank code, my ranking starts at 1 and goes through 60 becauase there are five seperate Business... -
After I took a short break and stepped away from my coding, I realized I could perform this function using the following:
...Code:Private Sub Form_Current() ' If Not Me.NewRecord Then Me.btnSaveNewRec.Visible = False ' Me.[txtCoordArea].Locked = True Me.[Full Name].Locked = True Me.[Badge ID].Locked = True Me.[SSN Last 5].Locked = TrueLast edited by zmbd; Nov 14 '13, 08:30 PM.Leave a comment:
-
Lock fields when current record is not a new record
When a form is opened fields are locked. When a new record is added (by pressing an add new record button), fields are unlocked. When the record is saved the fields are then locked again.
However, if a user click the add new record button then the user uses the navagation button at the bottom of the screen to navigate to a previous record, the locked fields are unlocked because a new record was going to be created but in fact never... -
I apologize for posting my question twice. After over 140 individuals took the time to look at it and three days later, I decided it was not worth a look by anyone so I posted it again hoping to get a responce; which I obciously did. Again, sorry for posting twice.
With that said, I still am running into an issue with when updating a record.
I have the previously posted code showing that when the NAVMenu_AfterUp date...Leave a comment:
-
Hide/Unhide Close Form Button (NOT the Close MS Access Button)
I have specific forms that I need to hide or disable the FORM close button for certain individuals and have it available for others.
I researched this for the past three (3) days and all I could find were posts on how to disable the red MS Access close button on the top right of the screen. This is NOT what I am looking for.
I thought this would be fairly simple to find but has proven to be VERY difficult to say the... -
Creating Archive Update Process Using VBA coding in Forms
I created an archive process that records every update made to a record. These updates are written to an archive table.
There is a Navigation Drop-Down Menu located on each form. When the Nav Menu changes, and if the form is Dirty, the updated record is copied to the archive table, then moved to the Nav Menu selection. Simple enough.
However, some forms are able to be viewed in a DS format and here is where the problem...Last edited by zmbd; Nov 6 '13, 07:59 PM. Reason: [z{Merged Identical threads}{merged identical posts}]
No activity results to display
Leave a comment: