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 Rhinorhino 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: pcdaveh
  • Content: Threads
  • Order by date
  1. pcdaveh

    The multi-part identifier "L.Labor4" could not be bound.

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

    Clear the immediate window

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

    Concatenation of variable in Stored Proc

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

    Undo Excel Pivot Table

    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?
  5. pcdaveh

    Subform in Tab Control

    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?
  6. pcdaveh

    Stored Procedure and List Box

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

    Option Group in a Report

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

    Picture Control

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

    Programatically Setting an Image on Tab Control

    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 =...
  10. pcdaveh

    Detecting New Characters typed as you type them.

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

    Varchar to Datetime

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

    Dynamic Reference to a form

    Situation: The code below is from a code module. Various form modules will call this code and feed the data back to the appropriate form. My hope is to be able to do this dynamically. You my or may not agree on why / how I'm doing this but I do have my reasons. Just not enough time to go...
  13. pcdaveh

    How to select an Item in a list box programatically

    Situation: I have a form with Two list boxes. When I select an item in list box one I want to programatically select its duplicate in listbox two if there is "unique" finding one or more instances of the same item. if not I want to send a message to the screen.
  14. pcdaveh

    Clear Selected Items in List Box Programmatically

    I have a list box and I want to be able to clear the selected items programmatically. Has anyone ever done this before with out setting he rowsource of the listbox to "" the resetting the rowsource? Is there another way to do this?
  15. pcdaveh

    Formatting Numbers

    I'm constructing a query with a float data type. I need to display the number as ###,###.## How do I get the number to display in this format with out changing the data type in the table?
  16. pcdaveh

    Accounting Report

    I'm trying to reproduce a report that has an Opening or Beginging Balance and then transactions for a month then a Total / Ending Balance. The Ending Balance for a given month will be the Begining balance for the next month. I can't get the Enging Balance to carry into the next month. This is...
  17. pcdaveh

    Format Syntax in a report text field

    What is the proper syntax to set the format of a text field in a report at run-time. txtMytext = 6900 Format(txtMytext,"###,##0.00) 6,900.00 that's what I'm trying to do in code.
  18. pcdaveh

    Programatically Selecting all values in listbox

    Is there a way to Programatically select all values in a list box? I have a list box that when I run a report I want it to select all the values every item in the list box and then dump those values into a table. I have the code to get it into the table. I just need to know how to select all...
  19. pcdaveh

    Validating data in a text box

    I want to validate the format of an account number in a text box. The number looks like this 13-2801.0 or ##-####.# How do I check this in code?
  20. pcdaveh

    Summing Totals Between Subreport and Main

    I have a main report with details of transactions. At the bottom of that report I have totals that are generated in the report. I have some code that will take the calculated totals in the report and dump them into a table. The next time I run this report for the next date range, I want to be...

Part and Inventory Search

Back
Top