New profile posts
can you send your db to my email: agpuzon@gmail.com.
i have reformat my drive so i cannot remember the code.
i have reformat my drive so i cannot remember the code.
-
Y
Yianni wrote on smtazulislam's profile.
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
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
Date Picker not displaying
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!
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
shenekas wrote on theDBguy's profile.
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?
Cant search anything. Keep getting site errors
.......
.......
-
G
Galaxiom wrote on isladogs's profile.
Colin:
I know how you like to test different ways of doing things. I suspect you would like to compare the techniques offered in this thread.
Greg
I know how you like to test different ways of doing things. I suspect you would like to compare the techniques offered in this thread.
Solved - Access - Counting Letters and Numbers In A String
Good afternoon. I have some data like this: AB12 ABC1 ABC12 ABCD123EF I would like to count letters, numbers, and then letters again if applicable. This would give me: AB12 = 22 ABC1 = 31 ABC12 = 32 ABCD123EF = 432 I am not sure if this something I can do in a query using LEN along with...
www.access-programmers.co.uk
Hey Ava here, living in USA, I start working as a content writer in which I generally write content over entertainment and technology.
When I am editing my Access dB on a network, a PC name, not my own, appears next to the Citrix icon, namely rdrwrajr0304, at the bottom right hand corner. Is this a snooper?