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!

  • Congratulations Mike Lewis 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: RJL1
  • Order by date
  1. RJL1

    BackgroundWorker progress bar

    The label appears but the % is not updated either. When it is done the message box and label are updates fine
  2. RJL1

    BackgroundWorker progress bar

    500 records take about 23 seconds
  3. RJL1

    BackgroundWorker progress bar

    Style of the progress bar set to "Blocks" = Yes Enabled=true = Yes
  4. RJL1

    BackgroundWorker progress bar

    Sorry forgot to specify. The list is prepared OK and the stored procedure to move the files executes but the progress bar never shows any progress at all.
  5. RJL1

    BackgroundWorker progress bar

    I am using Visual Studio 2012 Microsoft Visual C# Compiler version 4.6.1586.0 for C# 5 Thanks
  6. RJL1

    BackgroundWorker progress bar

    I have the code below and I am trying to get the progress bar to update as the files are moved. SO far no luck I am not sure what I am missing or what I have wrong with the code. Any help is appreciated. I am trying to move 500 records for testing purpose Thanks RJL public WEPK_Data_Mover()...
  7. RJL1

    Refresh DatagridView on Main Form when another form closes

    Hello I am struggling getting my DatagridView refreshed when the confirmation form closes. Here is the layout of my application Form_Appt_Main - this has the datagrid which on load populates with all the appointments schedules. I have a button btnNew which opens Form_Appt_New Form_Appt_New -...
  8. RJL1

    Enable / Disable MenuStrip Items based on a UserAccess Table from Database

    Hello, I am trying to control my Windows Form Menu Item based on a list of access (already in place) by user. When the form loads I am getting the current user name and getting a list of forms the user has access to. So my store procedure return a list like this Receiving 1 Receiving 2...
  9. RJL1

    Windows FormTreeView from Datatable

    I have been trying for a while to get his to work. I have a table that list the root folder, sub-folders and reports in a database. I am trying to bind this to a TreeView in a windows form My raw data looks like this Type IDParent NameParent ReportName Root NULL Management...
  10. RJL1

    Dynamic Top N by group

    Hello I have a new project. I have a table with customer number and a numeric value that represents the number of record I need to retrieve. For example Customer Records 042 10 317 25 I want to be able to run my query against my item master table and get 10 unique...
  11. RJL1

    NEWID() By Group

    Hello again, I been trying to get my query to return a NEWID for each group in my results. Here is what I have so far SELECT NEWID()M WAREHOUSE, ITEM, SUM(QTY) AS 'QTY' FROM INVETORY GROUP BY WAREHOUSE, ITEM This returns something like this NEWID...
  12. RJL1

    Update records based on Count

    Hi folks, I got this issue where I need to flag certain records so I can process them differently (or not) based on the count of the number of items per line number. My data looks like this. ERP_Line_Num Item Count 001 0083104 001 0210901 002...
  13. RJL1

    Stored Procedure Loop Incrementing Incorrectly

    Hello everyone. I have a piece of code that I am working on to print some container labels. The application allows the user to put in the quantity they want to print and the code loops that many times executing the stored procedure which returns a container ID with check digit already...
  14. RJL1

    Date Conversion YMMDD to YYYYMMDD

    Thanks for the response. It turn out the customer had only sent the middle of the manufacturing date. There was a leading alpha character and a trailing digit so this is what I came up with after a couple of hours of playing with it. DECLARE @mfdate VARCHAR(7) = 'S405061'; SELECT...
  15. RJL1

    Date Conversion YMMDD to YYYYMMDD

    Sorry I should have posted that. We are going under the assumption that is current decade since we do not think they have product 10 years old coming to us since it perishable items. Thanks
  16. RJL1

    Date Conversion YMMDD to YYYYMMDD

    I have a customer that is goign to be sending us a manuafacured date in the following format YMMDD Example 40506 Year = 4 Month = 05 Day = 06 I need to convert this to a YYYYMMDD so 40506 would be 20140506 Any suggestions on how to go from a single digit year to a 4 digit year is...
  17. RJL1

    Select records based on colum value

    Hello, Ran into this and there may be an easy way to solve but I cannot seem to find it. Any help is appreciated. I have a list of order and the qty that the requested. However some of the order are for the finigh goods item and the components that make that finish item. So for example I have a...
  18. RJL1

    SQL Querie with Variable DatDiff by row

    Thanks for the super fast response. Will try first thing in the a.m.
  19. RJL1

    SQL Querie with Variable DatDiff by row

    OK is been a while but I am in need of some suggestions. I have a new request to get a report for out invetory records that show invetory that is whitin a certain number of day from the expiration date. The problem is thta each family of items has a different days to expoire value Here is some...

Part and Inventory Search

Back
Top