New profile posts

What's new Featured content New posts New profile posts Latest activity
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.
J
Did you ever get a solution for the #deleted in an empty field that you posted on 31Oct2019? I having the same issue.
thanks
Jeff
mike60smart
Hi
You asked for a copy of the example I uploaded screenshots of.

If you use Skype then i can show you what I have done. My Skypename is:- Live:mike.s23

Regards

Mike
F
flyers123
Hey Mike,

Sure I can reach you on Skype. What is your time zone? I'm in Australia.
H
Abo, Could you help me on my question regarding query to select only one row where date of order is the latest?, how can we say that query
G
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.

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
Greg
isladogs
isladogs
Hi Greg.
Thanks. I've just replied in the thread. Will do so if I find the time
BTW did you see my PM reply regarding SQL Server security - before Xmas I think.
If possible, please respond by PM or email ...definitely not in an open forum thread or profile message for reasons that should be obvious
A
Hey Ava here, living in USA, I start working as a content writer in which I generally write content over entertainment and technology.
W
Hello MajP, Hope you are doing fine. I have made some progress in my database and stuck on an issue. Please review the recent post, whenever you have time and let me know what is possible solution. Thanks for all your help
S
How to make a continuous flash for a record that meets a specific condition in the continuous records form
isladogs
isladogs
Sorry - no idea what your question means. Please ask in a new forum thread so that others can respond as well.
mistermarty
Hi Dave. Just tried to post a question on the VBA section and got a message saying it could not be posted because it may be spam etc. Any guesses?
GabrielRyder
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?
GabrielRyder
GabrielRyder
Now my dB has been scrambled, when it was previously working: is this evidence of a malicious attack.
GabrielRyder
GabrielRyder
Part Solution: when the PC or device label disappeared, the dB appears to have returned to normal. I am running tests currently to catch any possible damage done.
N
Hi,

I just need code which hides the Access DB window and only have the open form. I have two more options in the form to which shows a report and one which saves the report as a excel file.

my form name: frmMyTime
my report name: rptMyTime

I use both MS Access 16 64bit / 32bit.
Back
Top Bottom