Search:
Type: Posts; User: Zvoni
Search:
Search took 0.06 seconds; generated 29 minute(s) ago.
-
Really?
I was under the impression, only "Objects" (Classes) can have Properties
-
Color me surprised.
Since when can you do a
Private Property Get in a BAS-Module?!?!?!
-
More or less my question, too.
What defines which 4 cards to be a set?
EDIT: Coming from a Poker-Cards-Deck:
You need a qualifier which defines which cards belong to which set
1) "i have all 4...
-
OK, i did a Test with my Data, and added Adam Sandler to Physics with Steven Spielberg (duplicate Subject, but different teacher).
Returns correct Sum
Same with teacher.
So no idea what you're...
-
You do realize that in your post you’re talking about teachers, but the query is for students?
-
not possible.
how do you want to get the fully paid teachers, when you want the SUM across teachers?
same with students.
this will only work, if you ignore teachers/students to receive a total...
-
TimeValue expects a (quoted?) Time-String
-
OK, got a few minutes to look at it
Students
The first query above returns this (for the Values i have)
Student
SubjectName
-
Will be thursday, since i‘m traveling the next two days
-
Did you uncomment the green lines?
And you have to pass a String-Variable as the second Argument (it's byref) for TokenizePages
-
?!?!?!?!
WITH
SC AS (SELECT SC.Class_ID, SUM(COALESCE(SC.Price, S.SubjectPrice)*SC.NumOfSessions) As TotalPrice,
TS.TeacherPercentage, SUM(SC.NumOfSessions) As...
-
Uh.... wrong.....
It's called a decision-tree.
We do it pretty much every second/minute of our life
"If it rains Then take Umbrella with me Else a Coat is enough"
Computers (and in that way:...
-
How do you figure that????!?
-
well, in that case:
you know what valid "input-characters" are: digits and "delimiters"
e.g. you only want to support two valid delimiters: "-" and ","
I'd probably throw the "input-String" at...
-
WITH
TR AS (SELECT SC.ID, SC.Student_ID, COALESCE(SC.Price, S.SubjectPrice) AS SubjectPrice,
S.SName As SubjectName, TE.TName As TeacherName, SC.NumOfSessions,
...
-
I'll add to this:
This would translate as "valid": 1-5,9-7 (Note 9 left of 7)
But how to proceed from here?
Print 1,2,3,4,5 (in that order), and then?
print 9,8,7 or re-sort to 7,8,9?
...
-
But that's exactly what tg is alluding to:
Your drier (probably) has a "beeper" --> Drier.RaiseEventBeeper("Done")
The question is: Is your Frontend (yourself) subscribed to this event (aka are you...
-
Just LMAO...
https://www.youtube.com/watch?v=S9WWz95ripA
-
And therein lies the problem, because people don't understand or are not even aware, that all those "concepts" (algorithms) are part of our daily life!
e.g. Just this weekend i had a full washing...
-
For me it was my very first "Database" on a Commodore C64 somewhere Mid-80s
My only source was the manual that came with the C64, explaining the "Basics" of "Basic".
Late 80's nearing the end of...
-
Since OP is using MS Access (My condolences, btw), i'd rather go the route saving all those "Sub-Queries" as "Views" (Saved Queries) within Access itself.
Then it would just be switching the...
-
Just use the Split-Function on any of your scenarios
what you are looking for is in Member 1 of the resulting array, irrespective if it's only one "@" or more.
As a sanity-check you'd just need to...
-
This not withstanding: What's so hard about to read the official documentation?
I have no clue about MS SQL, but it took me 2 minutes to find it...
-
Just to make sure i understand it correctly:
1) You need the Students/StudentTotal who have paid in full IRRESPECTIVE of the Subject
2) You need the Teachers/TeacherTotal IRRESPECTIVE of Subjects
-
Not just "thinking it was the issue".... IT IS the issue.
A Variant itself can be an array already
-
Works as well
Public arrLong(1 To 5) As Long
Public arrOutString() As String
Public Function DoSomethingLong(ByRef InArray() As Long, ByRef OutArray As Variant) As Long
Dim i As Long
Dim c...
-
Works for me
Public arrLong(1 To 5) As Long
Public arrString(1 To 5) As String
Public arrByte(1 To 5) As Byte
Public arrOutLong() As Long
Public arrOutString() As String
Public...
-
What DBMS?
many Databases understand SELECT COUNT(DISTINCT SomeField) AS MyCount FROM MyTable
-
Yeah..... fun question: And did you have a smartphone in 2003? :D
-
-
Use code-tags
Dim lbltst() As Label
Dim x As Long
x = 0
Dim C As Integer
C = 6
ReDim lbltst(x)
-
Well, considering, how old vbforums is (i remember a User having Reg-Date 1999)......
-
Do you have the "Save Copy in Sent Items"-Option activated (below a "new" message)?
-
WITH
SC AS (SELECT SC.Class_ID, SUM(COALESCE(SC.Price, S.SubjectPrice)*SC.NumOfSessions) As TotalPrice,
TS.TeacherPercentage, SUM(SC.NumOfSessions) As TotalSessions
...
-
std::string is a class. Basically you try to return a Class
https://cplusplus.com/reference/string/string/
Have you tried to change the returntype to "char*" ? Note the asteriks. Pointer to char
-
That one will definitely be Tomorrow at the earliest
(Currently my boss is looking at me from across the room)
-
WITH
TR AS (SELECT SC.ID, SC.Student_ID, COALESCE(SC.Price, S.SubjectPrice) AS SubjectPrice,
S.SName As SubjectName, TE.TName As TeacherName, SC.NumOfSessions,
...
-
No, he‘s right. I didn’t consider what he said.
unfortunatly, it‘ll be thursday i can have a look at it since i‘m out of office the next 2 days.
but i think it’s easy. I do have an idea, how to...
-
WITH
SSC AS (SELECT SC.Class_ID, SC.Student_ID, SC.NumOfSessions, COALESCE(SC.Price,S.SubjectPrice) As SubjectPrice,
COALESCE(SC.Price,S.SubjectPrice)*SC.NumOfSessions As...
-
And Elroy told you the solution: Late binding
|
Click Here to Expand Forum to Full Width
|