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

    Combo Box Value with VLOOKUP

    So, I've created a named combo box control in a MS Excel 2007 workbook containing file names that are stored on another worksheet (DriveFiles) in the same workbook. I've set the combo box cell link to D1 on my worksheet and set E1 =IF(D1="","","S:\Accounting\Financials\Linked Spreadsheets\[" &...
  2. Jean9

    MS Excel - Trap delete range and underlying query warning

    How can one trap the event when the user attempts to delete a range and thereby the underlying query on a worksheet? Currently, the default warning message (The range you deleted is associated with a query that retrieves data from an external source. Do you want to delete the query in addition...
  3. Jean9

    Excel Macro results differ when stepping through code

    When I step through the code below, the results on the worksheet are as they should be (the total label is in J whatever and the total is in K whatever) but when I run through the macro without any code breaks, the worksheet header rows (in this case range A1:K7) are shifted over to range C1:M7...
  4. Jean9

    Creating a temporary queryable dataset in Excel via VBA

    I'm wondering if anyone has any code to create a dataset from a selected range on a worksheet that can then be queried against and the resulting rows be written to a worksheet within the same workbook. I need the dataset to remain until a series of queries have been executed and then it can be...
  5. Jean9

    Treeview Control - Set node forecolor via VBA

    It there syntax to change the forecolor of a treenode that can be executed while the nodes are being added to the tree via VBA? I'm trying to set the forecolor of a treenode to red under certain conditions (black would be the default). Thanks in advance.
  6. Jean9

    Syntax for Datasheet Caption reference in VBA - MS ACCESS 2007

    How does one refer to the the Datasheet Caption property of a field in a Datasheet form in VBA? I can set it on the Other tab of the Property Sheet but need to set it on Form Load rather than a fixed value for the form. I can't seem to find any syntax out there for referencing it. Thanks in...
  7. Jean9

    AllowEdits False still allows Edit

    From a form, I am opening a form that has two subforms and one of the subforms also has a subform. I don't want any of the forms to be editable. I am opening the form with: DoCmd.OpenForm sDOCNM, , , sLINKCRIT, acFormReadOnly I can edit the form. I have tried the following code on both...
  8. Jean9

    How to tell when input mask data entry is complete

    How might one be able to tell when the user has completed entering a date in a field with a short date input mask? I was checking for length of the data on the KeyPress event to capture when the user had keyed 8 characters because I want to set focus to the next field when they have completed...
  9. Jean9

    Run and Display Dynamic Query Results

    I know this has got be so easy that even the question is going to make me look dumb but what code can one use on dynamically created sql (sSQL dimmed as string) to run a query with that sql and display the results in grid format (read only) to the user? -User enters criteria -SQL is created...
  10. Jean9

    Pass parameter to query from form

    I know this has probably been answered before but I can't seem to find it when I search for it. I have created a dummy subform (An unbound subform/subreport object that does not truly exist in the database) that I set the SourceObject on via code based on a combobox selection. Within the...
  11. Jean9

    Pass subform name to parent form function

    I have several subforms on a main form that are set to invisible. Depending on what button a user clicks, I want to make visible a single subform and set the others to invisible. I would like to just pass the subform name to a function that makes all subforms invisible and just the subform...
  12. Jean9

    Getting Office 2007 to work with People Tools 7.63

    Does anyone know how to get these two to play nicely together? I have altered the configuration manager and updated macro security. Still am getting errors when running PeopleTools query to excel and nvision reports. Thanks in advance for any help, J9
  13. Jean9

    Listbox ItemsSelected Issue

    On my form is a single listbox that when a value is selected in a combobox object, code is executed to select certain list items based on the combobox selection. The issue I am having occurs at the time when the user de-selects one or more items in the list and leaves other items selected (or...
  14. Jean9

    Reference record.field in another panel within group

    In PS 7.53 I am using the following code to insert a row into a table: [code/] If Not None(INV_ITEM_ID) Then &BUSINESS_UNIT = BUSINESS_UNIT; &PO_ID = PO_ID; &LINE_NBR = LINE_NBR; &INV_ITEM_ID = INV_ITEM_ID; SQLExec("Insert into PS_PO_LINE_ITM_REV(BUSINESS_UNIT, PO_ID, PO_LINE_NBR...
  15. Jean9

    Copy Paste Looping

    I have created a listbox containing all the tables in the database. Each table stores permissions for users for different applications. The adminstrator would like to copy user's permissions to add a new user. Once the user is selected that the administrator wants to use to copy permissions...
  16. Jean9

    Import Autonumber indexed records into a new table

    I have a database which I am unable to compact and repair as this action causes cascading issues with the user forms and functionality. So everytime the user has run into a record issue, we have just restored the database from a previous backup. Ideally, the database needs to be repaired...
  17. Jean9

    How to tell User typed value not in list without Limit to List

    I have added a combo box to a form that I want the User to be able to type in a value to that is not in the list. I don't want to use the limit to list property unless there is way to get past the limit and continue processing without adding the value the user typed in to the list. I want to...
  18. Jean9

    Setting the value of a control to opposite boolean

    I have written a function that is passed a boolean value that I am using to set the visibility of the controls on the form. In some instances, though "True" is passed, I still want to set some control's visibility to false. How can I still use the passed parameter in an opposite fashion...
  19. Jean9

    How to turn on a COBOL SQL trace in PS 7.53

    I am using the EDI manager to upload external vouchers and the vouchers keep getting placed in a "recycle" status for the same error over and over which isn't really an error. The error reads "TSE Prompt table edit; value not found in prompt table." for SUT_BASE_ID. There is no place to set up...
  20. Jean9

    SQR Debug

    We are currently on PS Tools 7.63 and I am trying to debug an sqr. I have appended -debughv to my Process Definition Options tab of the sqr I am running because these are the letters that are being used in the program. I have tried both upper and lower case -debughv. I have run this numerous...

Part and Inventory Search

Back
Top