Recent content by Melagan

To clarify, you're using an Access front-end with connects to SQL backend? What is the code behind your data entry form? (specifically the connection and command objects) ~Melagan ______ "It's never too late to become what you might have been.

SELECT t.SanEmployeeId, SUM( SWITCH( SanCategory = 'Verbal', -5 ,SanCategory = 'Written', -15 ,SanCategory = '1 Day Suspension', -40 ,SanCategory = '3 Day Suspension', -60 ,SanCategory = '5 Day Suspension', -80 ,SanCategory = '8 Day Suspension', -100, 0)) FROM tblSanctions t GROUP BY...

Hmm...I was just browsing around and found this older thread: thread701-941309 The Switch() function looks promising. ~Melagan ______ "It's never too late to become what you might have been.

I am pretty sure that there is no support for CASE functions in JetSQL. ~Melagan ______ "It's never too late to become what you might have been.

Is Revision_Version being stored as a string? Is it a number? If it is a number then use the appropriate definition - Long (or Integer depending on the length of your number). That aside, just a personal preference on error handling - I like to include the error number. Private Sub...

I've run into issues with Outlook 2003 + ACT 2007 integration and have been able to resolve most if not all by deleteing / reconfiguring the ACT Address Book. Make sure the username and password are correct when you set this up. Also, double check that microsoft word is not set as your email...

Oops - my line should go after: If .Show = True Then Incidently - if you wanted to allow multiple selections, something like this would do the trick. [code] Option Compare Database Option Explicit Private Sub cmdOpen_Click() 'Requires reference to Microsoft Office 10.0 Object Library. Dim...

You are 99% there man - all you need to do is add this line before End With MsgBox .SelectedItems.Item(1) ~Melagan ______ "It's never too late to become what you might have been.

...and the error is? ~Melagan ______ "It's never too late to become what you might have been.

This is just a guess - not sure if it'll work; I'm assuming you're using this on a form or report. If [Format] = "Currency" Then Me!myField.Format = "Currency" Elseif [Format] = "Percentage" Then Me!myField.Format = "Percent" End If ..just a shot in the dark. I can't even test it right...

Yes that is clear. Queries do not have field definitions like tables do, though. What method are you using to send your query to Excel? Are you doing it programatically or manually? ~Melagan ______ "It's never too late to become what you might have been.

My pleasure - I'm glad it worked out! I would like to ask anyone else who has been watching this thread if they would have had a different approch to this project. This was the first thing I thought of but still wonder if there are any other (simpler) ways. Cheers~ ~Melagan ______ "It's never...

I'm not quite sure I understand the question - or maybe the reason for the question. What are you wanting to do with PM Basis? Is this a text box on a form or a field on a report? ~Melagan ______ "It's never too late to become what you might have been.

And this? strSQL = "SELECT TBL_CARRIERS.PREFIX & " _ & "TBL_RECIPIENTS.PHONE & " _ & "TBL_CARRIERS.SUFFIX & " _ & "TBL_CARRIERS.DOMAIN AS theRecipient" _ & "FROM TBL_RECIPIENTS RIGHT JOIN (TBL_CARRIERS RIGHT JOIN " _ &...

You probably have your Immediate window hidden. In your code window, hit control-g to show it. If you don't have any luck with that - change this line: Debug.Print strSQL to ... Msgbox strSQL The goal here is to see the SQL in a more readable format and make sure that it is pulling the value...