Search results

Good afternoon all, I've looked everywhere but I can't seem to find out if what I want to do it doable. I'd like to make a form that is used to add new employees, to prevent the IT department from having to do everything that's simple. Most of it is easy but the one huge thing I'd like it to...

Good morning all, First off, let me say that I'm not well versed in VBA. I can read it and understand what it's doing, but do not have the skill to sit and use all the functions from memory. To give an analogy of what I'm trying to do, imagine you're a game tester for some company. Every...

Figured it out myself. You have to take the PaymentDate out of GROUP BY, and put PaymentDate <getdate() into WHERE instead of HAVING. Was hoping MS Query was able to do it for me like in access, but apparently not. Learn something new everyday. Wes

Greetings, My apologies, for I am still a novice in all of this. I have a small issue happening when I'm creating a query though MS Query. SELECT Accounts.PurchaseDate, Sum(MasterPayments.PaymentAmount) AS 'Sum of PaymentAmount', Ownership.OwnerName FROM E.dbo.Accounts Accounts...

Awesome! Its working perfectly. Thank you all. Wes

Thank you for the assistance. The time issue is fixed. Turns out the < and > were somehow causing it to stick to the first case. Once I changed it to: Case # To # It worked fluently. My problem is that Ive been working in query expression so much that its rubbing off to my coding. Plus the...

Thank you, that is easier. So far I have this... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Select Case MPM Case Is > 540 < 545 If Minutes >= 1 Or Hour > 0 Then Outbound.ForeColor = vbGreen Else Outbound.ForeColor = vbBlack...

Ahhh, it was the "And" causing the error to pop up. I changed it, but am still getting the same problem. If you look at case 3, I changed it to 3:30pm so I could test it a few minutes ago. Anyone that has 20 and up minutes is still in the green instead of the 50. It's resorting to the first...

I get "Compile error: Expected: expression" on the "<" between "And" and #11:00:00 AM#. Would it be better to set up case names for the Time() at first, so I can declare a case by integer? Such as: Dim casename As Integer If Time() <> #10:45:00 AM# & #11:00:00 AM# Then casename = 1 End If...

I must have spoke too soon. From looking at the code, did I do the If Then Else wrong? The first case works, but when its between the 12:30pm and 1:00pm it still uses the number 20 instead of 35.

Thank you for the quick reply. I was just about to message back to say I got it. Ill post my code if anyone ever has my problem. Select Case Time() Case Is <> #10:45:00 AM# And #11:00:00 AM# If Minutes >= 20 Then Outbound.ForeColor = vbGreen Else...

Sorry for the delay. Wanted to try some things out before needing anymore help. My issue now is that when using the variable for minutes, it only lets me use "=". I need it to be => 20. Is there a way around this?

Thank you, no idea why I didn't think of select/case since it will have more arguements than I realized. The font will be easy enough. I've looked all over and can't seem to figure out how to use Time() in my kind of coding. Do I set it at the beginning as something else? I apologize if...

Hello all, I have a report that pulls a Phone Call report query I made, and sorts it by the person that has been on the phone the longest(minutes). The report shows the name of the person, total duration, and total calls. My first problem is that I need to make an If statement to change the...