Search results for query: *

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.

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

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

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?

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.

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

Awesome, thank you.

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

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

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.

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

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.

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

I'll check it out. Thank you!!

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!!!

Thank you!

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.

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.

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.

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