Nauticalgent
Last Activity: 1 week ago
Joined: Oct 30 '15
Location: South Prince George, VA
-
I use PowerShell and Task Scheduler.... -
Thanks NeoPa, and I totally understand how AI is basically stealing the livelihood of these Forums and others...Leave a comment:
-
New Look
I step away for a minute and someone decides to give the site a new look... -
Excellent contribution, more to come?Leave a comment:
-
anoble1,
Did you ever get this sorted?Leave a comment:
-
I assume you are using MS Access?Leave a comment:
-
Will there be cake and ice cream this time?!?Leave a comment:
-
However, you CAN hold it's head under water until it quits moving....Leave a comment:
-
The OP is referring to MS Access. He/She cross-posted this on AWF and has received some replies but has not responded yet.Leave a comment:
-
Hello there!
Easy to do, but I would suggest NEVER storing concatenated data. It is a better practice to do this for Forms, Reports, and Queries - but not in a table. What if the name changes, or if you make a mistake and have to change it?
Anyway, to answer your question:
[First Name] & " " & [Last Name]
- or -
[Last Name] & ", " & [First...Leave a comment:
-
Here is the code I use:
Code:Public Function DateToJulian(dt As Date) As String DateToJulian = Right(Year(dt), 2) & Format(DateDiff("d", DateSerial(Year(dt), 1, 0), dt), "000") End FunctionLeave a comment:
-
You're very welcome, happy to help.Leave a comment:
-
Try:
...Code:Public Function PrintOut(strTest As String) Select Case strTest Case "aaa" DoCmd.PrintOut acPages, 2, 2, , 1 Case "bbb" DoCmd.PrintOut acPages, 3, 3, , 1 Case "ccc" DoCmd.PrintOut acPages, 4, 4, , 1 Case "ddd" DoCmd.PrintOut acPages, 5, 5, , 1Leave a comment:
-
I noticed that the function you posted is public. Is it in a separate module than the form that has the command button?
If so, you will need to pass an argument to the function, in this case the value of Text28. Depending on your answer, I have some suggestion to make your code more efficient.Leave a comment:
-
Not quite sure what you mean by biometric attendance...?Leave a comment:
-
Nauticalgent replied to Need to search each line in RTF field / return lines that contain specific stringin AccessWow...that is a LOT of work!...Leave a comment:
-
Nauticalgent replied to Need to search each line in RTF field / return lines that contain specific stringin AccessSpeaking of Wolves...thanks TwinnyFo.
P.S. How do you quote somebody on this forum? I have not been able to figure it out. HTML tags?Leave a comment:
-
Nauticalgent replied to Need to search each line in RTF field / return lines that contain specific stringin AccessWell done JenniferM/Perplexed, glad I could help get you pointed in the right direction...
That being said, I have to ask: I am assuming the txtMedications field holds a list of medications for a patient.
If I have that correctly then your tables are not structured correctly. You should have table with a Primary Key (PK) for the patients and another table that hold the medications for each patient. The medication table...Leave a comment:
-
Nauticalgent replied to Need to search each line in RTF field / return lines that contain specific stringin AccessHi Perplexed...
A couple of ways to tackle this. Having never used RTF on a table or field level, I had to educate myself on the HTML tags.
I did a quick mock-up of your form and table and in my opinion the best (easiest way) to go about this would be to use the Split() function to populate and array to hold the data:
...Code:Private Sub Form_Current() Dim strArray() As StringLeave a comment:
-
Nauticalgent replied to Need to search each line in RTF field / return lines that contain specific stringin AccessDear Perplexed,
Just so I understand correctly, you have a Memo field (Long Text) that is formatted as RTF on the bound form? Also, where are the <div> tags coming from, are they imported from an external source?Leave a comment:
No activity results to display
Leave a comment: