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 derfloh 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: *

  1. michellecole

    Time calculation: adding and displaying hours greater than 24

    Beautiful! Thank you!
  2. michellecole

    Time calculation: adding and displaying hours greater than 24

    I am attempting to calculate many time durations and then sum them. The durations can be 4 seconds to 2080 hours. Cool Function, and if I understand it correctly it determines the difference between (2) dates and displays the results. I am needing to determine the difference between (2)...
  3. michellecole

    Time calculation: adding and displaying hours greater than 24

    Ok, I give. I've tried to incorporate several Time Calculation Tips and now I've confused myself to the point of not knowing if I'm way off track or almost there. Below is what I want to do and what I have done thus far. Is this the best way? I am working in Windows 2000, in Microsoft...
  4. michellecole

    How do I pass an integer in the sql stmt of Adodc RecordSource?

    Thank you for the feedback. I think the lesson I've learned (from other sources as well) is to limit my use of the adodc control. I usually access the databases with ado with sql in the code - but wanted to allow the user to easily scroll through records on a particular form thus the adodc...
  5. michellecole

    Visual Basic Combobox Limit to List Question

    Thank you for your responses! I tried them out and here are the solutions I settled on to allow the user to type the code, auto expand and limit to list: To allow for a Drop Down - this was provided by thread222-953023: On Form: Private Sub cboErrorCode_KeyDown(KeyCode As Integer, Shift As...
  6. michellecole

    Visual Basic Combobox Limit to List Question

    When I change the style, the user is no longer able to type the value manually. They are entering errors codes which are only 4 digits so I want to allow them to quickly type the code in if they know it but select from the list if they don't. Is this possible?
  7. michellecole

    Visual Basic Combobox Limit to List Question

    Is there a property in VB for a combobox similar to MS Access where you can select LimitToList or does one need to write code to validate what was entered in the combobox on a particular event?
  8. michellecole

    How do I pass an integer in the sql stmt of Adodc RecordSource?

    I am working with an Adodc in VB with Access as the Back End. There is an ODBC Driver called "BranchErrors". Here are the settings on the adodc1.property page: CommandType = 8 - adCmdUnknown ConnectionString = DSN=BranchErrors CursorLocations = 3 - adUseClient CursorType = 2 - adOpenDynamic...
  9. michellecole

    Importing data from SQL Server to Access

    OS: 2000 Front End: MS Access 2000 Back End: SQL Server For over two years, one a month we have imported monthly billing data from SQL Server tables into Access tables via many queries which do many things to the data as it is imported - including counting field widths. I only mention this...
  10. michellecole

    Passing data from unlinked subreport to Main Report

    Thank you for your response - it worked! I was missing the syntax in bold. Please forgive me - the subreports are indeed linked via CustomerID - I was thinking linked meant something else so I went and looked up what it meant. subreport formula: whileprintingrecords; shared numbervar...
  11. michellecole

    Passing data from unlinked subreport to Main Report

    Crystal 8 Microsoft Access I have a Main report displaying CustomerIDs. For each CustomerID there are (3) unlinked subreports - one is displaying AccountIDs, one is displaying SiteIDs and one is displaying ScannerIDs. I would like to have a grand total at the bottom of the Main report...
  12. michellecole

    Data repeater is not updating table with new values.

    Your "CurrentRecordChanged event" Workaround works beautifully! Many Thanks!!! Michelle
  13. michellecole

    Data repeater is not updating table with new values.

    The workaround does work, but it consists of adding a button to the form that the user must click after modifying data on EACH record :( Takes away from the essense of the control. Is there any other control that works similarly (displays data in columns that can be updated)? Thank you for...
  14. michellecole

    Data repeater is not updating table with new values.

    Bob, thank you for your response. I'm off to a class today but will try the workaround first thing in the morning and let you know how it goes. Michelle
  15. michellecole

    Data repeater is not updating table with new values.

    I'm working in VB6 with MS Access 2000. I have a data repeater control that is displaying properly, but it is not updating the underlying table with new values entered by the user. I built an ActiveX data repeater control, pubCtl.ctl, and saved it in a project called controlPrj.vbp. In a...
  16. michellecole

    Open & execute Command Prompt from a Form

    Gotcha! Thank you. Thought you were just referring to the 2 and True questions - didn't realize it was new code. All is good. Thank you, Michelle
  17. michellecole

    Open & execute Command Prompt from a Form

    I need he VBA to pause, but I am getting a compile error. What am I doing wrong? This code works - but I need a pause: CreateObject("WScript.Shell").Run ("%COMSPEC% /c copy " & sSourceFiles & " " & sDestinationFile) This code yields compile error as noted above...
  18. michellecole

    Open & execute Command Prompt from a Form

    CreateObject("WScript.Shell").Run ("%COMSPEC% /C copy " & sSourceFiles & " " & sDestinationFile, 2,True) The above syntax yields the following Compile Error "Expected: =". I removed the last part of the syntax, ",2, True)", to get past it and ran it SUCCESSFULLY!! Is this syntax required and...
  19. michellecole

    Open & execute Command Prompt from a Form

    Thank you for your quick response PHV, I have been unsuccessful in getting this to work so I thought I would send you my code - I'm sure I am leaving something out. It looks like the command window flashes on the screen, but too quickly for me to see what it says and the new file does not get...
  20. michellecole

    Open & execute Command Prompt from a Form

    Is there a way to programatically call a command prompt and execute commands from an on_Click event from an MS Access Form? What I am wanting to do, (unless there is another way to do it), is allow the user to click a button which will concantenate several "*.file" files into a single ".file"...

Part and Inventory Search

Back
Top