Search results for query: *

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

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

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

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.

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

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

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.

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.

Good Day Folks, I have a data entry form. Required text boxes are highlighted in light green. After the user enters data into the text box I want to change the back color to white. I don't want to write the same code on After_Update for every text box, there's a lot. Can someone point me in...

Hello, I have a form in MS Access and want to change the query to a stored procedure. However, I have 11 fields that need to remain editable. Any ideas on how to do that would be greatly appreciated. Thank you.

Good morning, I have a form with multiple text boxes that are required fields signified with a green background. After the user enters information into a required field I want to change the color to white. Is there a way to do this without having an AfterUpdate() event for every box? Thank...

Hello, I was wondering if there was a method to allow users to select from a list of fields in a table that automatically builds a query from a front-end form. If so, how would you incorporate aggregate functions as an option. Many thanks.

Hello All, My company recently moved to SQL Server 2005 from Access so we are attempting to move our queries to SQL. With that said. We upload mass student data into our system. We then check for school transfers. If a school transfer occurs I want to assign the student to the new school's...

Good Day All, I just want to check if a local table (which actually gets imported) exists and can't find any information at all for that type of check. Thank you for any help on this.

Hello, I have a stored procedure where I need criteria on the YOG that says if the current month is > 9 then YOG = Year(date() else YOG = Year(date() - 1). I have this case statement but don't know where it should go in the SELECT: CASE When month(getdate()) > 9 then Year(getdate()) else...

Good afternoon, I have 4 bit fields in a table and I need to sum each so that the result looks like: Field1 Field2 Field3 Field4 5 10 15 23 My statement looks like: SELECT Field1, Field2, Field3, Field4 FROM YTFIntakes WHERE Year(IntakeDate) = '2008' and...

Hi All, I am working on an Excel project. I download data from a state agency, store it in multiple sheets in the same workbook and manually reformat each sheet. I want to automatically: delete the first 3 rows delete columns A, B and C insert a top row with titles studentid, score I have...

Hi All, I am new stored procedures and want to write one that: First, check to see if a Contact already exists in our data If not, then I want to do an append query If it does, then I want to send back a message that "contact already exists" Thank you in advance.

Hi All, I have an .mdb file. I open another .mdb file from within this .mdb file. Below is the code I use. Users are getting the error "The database has been placed in a state by user 'name' on machine 'machine name' that prevents it from being opened or locked". Does anyone have any...