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!

Recent content by yoshe

  1. yoshe

    Checking data integrity in excel spreadsheet using vba

    Hello, I may not know exactly what words to search for, so I apologize if this question has already been addressed in other threads. I want to run some preliminary checks on data that is sent to me in excel form, just checking columns for appropriate variable length and character/numeric...
  2. yoshe

    sas ods tagset output even if no records

    Hi, I am outputting the results of proc tabulate to a series of sheets in an excel workbook. The problem is that each proc tabulate depends on a "where" statement. If the result of the "where" yields no records, I still want it to output to excel with null values. Right now the log just says...
  3. yoshe

    excel sort based on matching columns

    Thanks, #2 helped me work it out. I hadn't thought of adding a new column that would mark the original order.
  4. yoshe

    excel sort based on matching columns

    Hi, this probably is relatively simple, but I can't figure it out. I have a spreadsheet with many columns that I need to sort based on a unique numeric 'keycode', but the sort has to be in the same order as the 'keycode' in another spreadsheet, which is neither ascending or descending. I have...
  5. yoshe

    beginner charting question

    Hello, Is it necessary to first write data to a worksheet in order to create a chart for it? I have a model that reads data from a text file and would like to create the chart in vba without first outputting the data to a worksheet. Is this possible? Thanks for any help.
  6. yoshe

    trouble presenting nested subform/linked table data

    Hello, I have a main form for physician practices that contains a subform of individual physicians in the practice. This subform contains, among other items, tax id numbers. It seems the tax numbers can change so I need to add effective dates and allow multiple tax numbers per physician. I'm...
  7. yoshe

    Key down event for controlling flow

    TheAceMan1, yes, it works as desired if I switch the tab order and code it to go to one control previous in the order. Kind of ugly though and throws off the flow for people who click into a field. A google search brought up this: http://support.microsoft.com/kb/327821 Not sure if it applies...
  8. yoshe

    Key down event for controlling flow

    Remou, I'm not really sure what this is supposed to do. Tab is coming up as KeyCode=9 for me. I tried substituting that in the cases, but that basically prevents the cursor from moving. Also, I want to move between recordsets, ie from the end of one subform to the beginning of the next, or some...
  9. yoshe

    Key down event for controlling flow

    Hello, I am trying to use key down (If KeyCode=vbKeyTab) to control the flow from one control to another on a form with subforms on a tab control. I initially used the LostFocus event, but this drives people crazy if they use the mouse to navigate rather than tab (they click into a field but...
  10. yoshe

    Suppress welcome page when in design view?

    Works - thanks!!
  11. yoshe

    Suppress welcome page when in design view?

    Remou, yes I go in using shift. Initially it's ok, but if I go into datasheet view to test and then back into design view, that's when the welcome page pops up. Please elaborate on global design variable - I'm not very advanced. Thanks.
  12. yoshe

    Suppress welcome page when in design view?

    Hello, I have a welcome page for people doing data entry, with the rest of the database hidden. This welcome page pops back up when the user closes the form, and the user exits the database through a button click on this page. Is there any way to stop this page from popping up when I myself...
  13. yoshe

    Run check before leaving record

    DrGreg1408, it is a combobox, but my problem is not that the check is not working, but that the event fires too often (ie, when moving between parent and child records rather than just when leaving the parent record).
  14. yoshe

    Run check before leaving record

    Possibly, but I didn't really want to get rid of the navigation buttons at the bottom - people are used to those for scrolling back and forth, sorting on some field and then going to first or last record, etc. The form is used for ongoing edits (during which time they might accidentally blank...
  15. yoshe

    Run check before leaving record

    Hello, I have a bound form with bound subforms on tabbed pages. I have a field on the main parent form "Application_Status" that I want to check for null, but only before leaving the record. My initial attempt was to use the form's BeforeUpdate event, but this causes it to run (and pop up my...
See more

Part and Inventory Search

Back
Top