New profile posts

What's new Featured content New posts New profile posts Latest activity
G
Welcome. Looking forward to your contributions. Your first post was spot on.
A
alphonseg
Thank you. I'm hoping this forum will be more interesting than the MS forums.
H
hi arnelgp

still I need your help in my post

ranking with many condition

good day for all please help in following In company we have a lot of employee Company make summer resort to many place Like place 1 ,place 2, place 3… And we want to get ranking for each employee depend on many rules If many employee select place1 and group1 I want ranking employees...
www.access-programmers.co.uk

please check ranking serial

is not correct

thanks for you help!
View previous comments…
arnelgp
arnelgp
I already given you two examples.
you ask other people in the forum.
I already done my part.
  • Like
Reactions: hatmak
H
hatmak
thank u for reply
when I filter data
rank not change as filter
look like
1
2
4

number 4 should be 3

do u understand me
thank u again
H
hatmak
please try to change filter and see ranking
Z
Dear Mr Sonu,
Regarding your post "acCmdInsertHyperlink does not allow to set a default start folder" in which Code 1 and Code 2, to Open the File in Specific folder.
May I know that this Issue resolved? As I am also facing the same issue with my DB in Access.
Kindly guide me.
Regards
Zubair Mughal
The_Doc_Man
@jcsuarez - your question via the Profile Post method requires an answer that is too long. I will create a conversation to answer what I need to answer.
H
hi.... i want to design a message box which appear from right to left on opening at bottom of screen ,then disappear from left to right on closing .i tried with
form_load inside height=20000&inside width=0 but want to change message width from 0 to line length on opening
H
hi..i want to design a message which appear from right to left at bottom of screen on opening then disappear from left to right on closing .i tried using inside height
F
I appreciate greatly for your tremendous help with building the database for me. Thank you for all your help
Y
Hi, I have reviewed your database and see that you have thought through many issues.
1) I suggest that you use the Autonumber field in tblProjects as the unique number for each
project. Access will manage it, keep it unique (never duplicate it)
2) Use the same field name (ProjID) in the tblProjectDetails; however the field will be Number, Long Integer
more later

John
GaDauBac
Hello!
You can make changes to the [Maintenance Date] field once a month until the Departure Date does not change.
This means it changes once a month.
For example:
- OutOfDate = 27/3/2021
- Maintenance date = 27/4/2021
Then 1 month Maintenance Day = 27/5/2021
If OutOfDate = Current date will not change
At stops: - MaintenanceDate = OutOfDate
Thank you!
S
I would like to make the Archived Date field a "required" field if the Archived value is selected in the Status field in Access 2016. Is there anyway to have the cursor automatically go to the Archived Date field so that the date can be selected? Does you have any idea how to fix this?
S
shenekas
I used the following code:

Code: 
If Me.Status = "Archived" Then

If IsNull(Me.Archived_Date) Then

MsgBox "You must enter a date when the Status is Archived.", vbOKOnly

Cancel = True

End If

End If
theDBguy
theDBguy
Did you get this fixed? Sorry for the delay.
Back
Top Bottom