Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Melagan

    New Records are not updatable

    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.
  2. Melagan

    Problems with this query

    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...
  3. Melagan

    Problems with this query

    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.
  4. Melagan

    Problems with this query

    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.
  5. Melagan

    Trying to add +1 to record revision number automatically

    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...
  6. Melagan

    Moving Outlook emails to ACT 2007 Notes

    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...
  7. Melagan

    Open Dialog Box

    ...= "Please select one file" 'Clear out the current filters, and add our own. .Filters.Clear .Filters.Add "All Files", "*.*" 'Show the dialog box. If the .Show method returns True, the 'user picked at least one file. If the .Show method returns...
  8. Melagan

    Open Dialog Box

    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.
  9. Melagan

    adodb.command

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

    Way to allow different formats for different records in same field?

    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...
  11. Melagan

    change data type of a query field

    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.
  12. Melagan

    get to from query in DoCmd.SendObject

    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...
  13. Melagan

    change data type of a query field

    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.
  14. Melagan

    get to from query in DoCmd.SendObject

    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 " _ &...
  15. Melagan

    get to from query in DoCmd.SendObject

    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...
  16. Melagan

    get to from query in DoCmd.SendObject

    My bad - I meant to concatenate all of those fields into one field. Try this for strSQL. strSQL = "SELECT TBL_CARRIERS.PREFIX & " _ & "TBL_RECIPIENTS.PHONE & " _ & "TBL_CARRIERS.SUFFIX & " _ & "TBL_CARRIERS.DOMAIN AS theRecipient" _ & "FROM...
  17. Melagan

    get to from query in DoCmd.SendObject

    Alrighty - I understand where you're at now; no problem! The thing with SQL is that you can not, to my knowledge, directly populate a variable using SQL alone. If you are really wanting to use SendObject, then you're going to have to put your SQL into a recordset and then populate your variable...
  18. Melagan

    get to from query in DoCmd.SendObject

    Where does this 'FOO' variable come from? Are you using the above SQL to populate a recordset, then populating your FOO variable from said recordset? There are some guys here that are smart enough to put a solution together with all of the given information, but I am not one of them :) I need...
  19. Melagan

    Access, change the security user using VBA???

    One thing I've noticed about Access User Level Security is that the login dialogue box automatically fills the username field with your windows profile username. If you create each user with the same username in Access as Windows, that'll save your users from having to type in a (different)...
  20. Melagan

    Access, change the security user using VBA???

    Why not just build Access user accounts under Tools > Security > User and Group Accounts ? To take full advantage of Access User Level Security, each user logging into the database should have their own username and password. If the database is on a network with multiple LAN users logging in...

Part and Inventory Search

Back
Top