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: *

  • Users: darude
  • Order by date
  1. darude

    ListBox Question

    I'm actually populating a detached datarow of the actual data. The purpose of the listbox is to show the user what they are doing in english rather than displaying data fields that won't make any sense. So,the listbox is getting populated by a string build from the datarow.
  2. darude

    ListBox Question

    Good Afternoon, I have a listbox that contains the string 'Q1. AnswerID 24(0-20%) Unlocks Q2a.' When I use the following code I get the full string. I need to get the Values 24 and Q2a from the string to determine if this is the row the user wants to delete. Thank you in advance for any...
  3. darude

    UPDATE Question

    Hi All, My update statement doesn't seem to be working. I want to update JobStatus to Active only if ContactLastName OR ContactFirstName meet the criteria below. Does my statement look correct? Thank you in advance. UPDATE j SET JobStatus = 'Pending' FROM Jobs j JOIN Contacts c ON...
  4. darude

    Text Align Image

    Hi Guys, I'm new to this and modifying another person's code. I'm using IE. When I try this code in an independent of the website, I get the same issue. The first line appears alongside of the picture, the 'Starting at 9 PM' appears below the picture. Should I use a table?
  5. darude

    Text Align Image

    Thank you for your response. I am new to this and working with code from someone else. When I add the align="left", I lose the picture and it becomes the text of the link.
  6. darude

    Text Align Image

    Hello All, I am trying to place an image on the left and then place text to the right of the image. So, the image is a local entertainer and to the right I want to write: Joe the Magician Starts at 9PM The second line shows up below the picture. Help! Below is my code. Thank you in advance...
  7. darude

    Add new row to an unbound data grid view

    Awesome, thank you.
  8. darude

    Add new row to an unbound data grid view

    Good Afternoon, I have a bound data grid view. When a user double-clicks it I want the selected row to populate an unbound data grid view. This is for a survey and I want the second data grid unbound so the user can change the order of the contents before I add the data to a production table...
  9. darude

    UDF

    Thank you, I'll try it. I meant October 1.
  10. darude

    UDF

    Hello, I would need to create a UDF where if I feed it the current year it returns 10/1 of the previous year. Is this possible? Thank you in advance.
  11. darude

    DatePart

    I added criteria to the question. So yes, your solution works, but not past the current year the record was created in. Thank you.
  12. darude

    DatePart

    Thank you for the quick response! This works as long as the created year is 2008. Jobs that occured between 7/1/2008 and 8/31/2008 can be created 2/1/2009 and greater and I don't need those in the dataset.
  13. darude

    DatePart

    Good Morning All, I have a dataset based on a job start date between 7/1 AND 8/31 for years 2006 to 2008. Jobs can be entered at any time, meaning a job could be intered in 2009 that occurred in 2007. The qualifier for my dataset is createddate < 10/1. My sql statement is below. How do I...
  14. darude

    User-built query

    I'll check it out. Thank you!!
  15. darude

    User-built query

    Good Afternoon All, One of my clients would like the ability to select a table, select a set of fields and some criteria to build their own queries and would like to do it from a GUI. I'm not sure where to start with this. Any help would be greatly appreciated!!!
  16. darude

    Get current user

    Thank you!
  17. darude

    Get current user

    Good morning all, Is there a way to get the current user in a stored proc without passing to a variable in the proc. So, in the where clause - WHERE Staff.Username = currentuser() - which is an access thing. Didn't know if I could do something similar.
  18. darude

    Stored Proc Question

    I did think of that, however, it's not the method my senior programmer wants to use. I think I figured it out. Thank you.
  19. darude

    Stored Proc Question

    Hello, I have an MS Access application where I populate a temp table local to Access from a form. I want to populate a SQL table using a stored procedure. How do I access the access temp table from the SQL Server. Thank you in advance.
  20. darude

    Textbox Color Question

    Perfect. Thanks so much for your help! Much appreciated.

Part and Inventory Search

Back
Top