Search results for query: *

Thanks for the suggestion of printing out the string. That yielded some results. I'm not a SQL Server expert, but an Accountant. So, some of the more sophisticated ways of doing things aren't going to be for me. Also, the reason this has to be put into a string variable is because other...

I have a sql query that works fine until I place it into a string variable and try to execute the string. First the Good Code is below: INSERT INTO ESOTempTables.dbo.GLPayRunEmpsEarnings (CompanyNum, PRID, VoucherNum, VoidRunIndicator, ekPRV, ekPRL, EarnNum, EarnAmt, Labor4, EmpDept, mydept...

Thank you very much! It pays to know where all the bells and whistles and switches are.

Does anyone know how to clear the immediate window in vb.net? I've tried selecting the text and hitting delete and it won't disapear...

Thank you all I finally got it to work with a combination of all your suggestions!

I thank you for your reply. However, If you look at the text of the stored procedure I have above you'll note that I know how to pass in and declare variables. I need to place the blue highlight variable in place of the key word LIKE N'%' also highlight in blue. Just placing the variable in...

I have a stored proc with some variables being passed in. The variable that I'm having difficulty with is a string or nvarchar. You'll see the variable and the location of where it needs to be placed highlighted in blue. I just need to know how to properly place the variable in the Stored...

I need to just get at the raw data in an Excel Pivot table. How do you undo this Pivot table and get at a data table?

Can you show me the syntax that you would use because i've tried Forms![Formname].[SubformName].visible = true also Forms![Formname].[TabcontrolPage].[SubformName].visible = true

I have a Form and inside it I have a Tab control. On Page(0) I have a subform named frmTest. frmTest is a datasheet. I want to programatically make this subform visible. How do you reference the subform on a tab page?

Does any one know how to call a stored procedure and have it populate a listbox on an Access Form. The sp is already created with input variables. I don't know if I need to use declare a cursor or output variable and then how to get those row into the listbox. Anyone have a clue or an example?

What your doing is setting the value of the text box based upon what is in the option group. I need to set the option group itself.

Is it possible to set the value of an option group in a report in code? Please provide tested code 'caus I tried and it didn't work.

Situation. I have 50 Forms. Each of the Forms has a tab control with 1-15 tabs or individual pages. Each of the pages has an image control that has been placed on the tab using the CreateControl(formname, controltype[, section[, parent[, columnname[, left[, top[, width[, height]]]]]]]). I...

Thanks for responding. I've gotten this far ,but what I need is to set imgCustomer dynamically. How do you refer to imgCustomer dynamically in code?

Does anyone know how to refer to an image control on a form from a basModule. I need to know how to refer to an image in a form when I'm running code outside of that form. Example: Form Name: "Customers" Image control: imgCustomer Code Module Forms!Customers.????? the ...

Does anyone know how to Programatically Set an Image on Tab Control. Examples: on a form this works Me.Picture = "\\Devsql2001\Dev_Team\Reports_Online\Files_Images\Working_Directory\NewForms_IT\GIFS\test.gif" on a tab control This doesn't work me.TabCtl0.Pages(1).Picture =...

Situation: I have a form with a text box that I want the user to type into. I need to detect the characters as they are being typed into the text box. Then execute some other code such as passing the text in the text box into a variable and then passing the variable into a SQL statement that...

I need the syntax to change a varchar to a datetime: I have a table that contains "Date" values and they are being stored as varchar in the table. They are in this format "mm-dd-yyyy" or "09-06-2002" I need to convert or cast it into a Date form at in a View...

Thanks!