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!

Recent content by SBM1745

  1. SBM1745

    EXporting Excel Attachment File from Outlook to my personal folder?

    First thought that comes to mind is a Macro and Scheduled Tasks. Setup the Macro to retrieve the email and extract Excel file and move it. Then set a Scheduled Task to perform that Macro when you like. FYI - Scheduled Tasks can be found in Control Panels. Reading that, I know it's not a lot of...
  2. SBM1745

    Outlook 2000: Have to reenter exchange server every time after reboot

    Have you tried deleting that profile (exporting to file if needed for backup) from the Outlook client and setting it up again? -Chris Starlight B. M.
  3. SBM1745

    Outlook 2000: Have to reenter exchange server every time after reboot

    I've encountered problems like this. I would check the Exhchange properties for Outlook (Right-click Outlook Icon>Properties>Microsoft Exchange Server), and make sure server name & mailbox name is correct there, can hit check name to confirm. Also, it helps to have the user use the same username...
  4. SBM1745

    Outlook 2000: How to reset install option? Or reset Address Book?

    I happened to install Outlook 2000 on a machine here at work and set it for Email Only during the installation setup. We used to use an exchange server, and we no longer do, the mailboxes and address books have all been exported to files. This employee got a new computer, so I loaded him up with...
  5. SBM1745

    Best way to print the data on a form?

    As was mentioned, I would use a report. When you have data that you know is going to variable, such as your subform data, allow the textbox to grow (textbox properties Grow=Yes). Depending on the width you set for the text box, the data will wrap at the right side of the textbox and continue...
  6. SBM1745

    Report problems

    What's the error that you get? -Chris Starlight B. M.
  7. SBM1745

    Multi-column unbound combo data to report: error

    Oh man! I set the bound column = 2 and that fixed it. I was basing the column bounding rules on a 0,1,2... type of list, not 1,2,3... PHV, you know a lot of great Access functions! I would have tried the DLookUp() had MajP's suggestion not fixed the problem. Thanks for the suggestion! -Chris...
  8. SBM1745

    using a listbox value with In() within a query

    I added this to OpenSchedule_Click()Dim strCriteria As String strCriteria = "[ScheduleID] In (" & txtSeeValue & ")" DoCmd.OpenReport "rptByChris_PrintMultipleSchedules", acViewPreview, , strCriteriaThat works perfectly! Thanks! No book I've looked through ever mentioned any of these methods! Can...
  9. SBM1745

    using a listbox value with In() within a query

    OH! I think that would work great! I didn't know how to run a criteria command like that on the fly. Thanks! -Chris Starlight B. M.
  10. SBM1745

    Multi-column unbound combo data to report: error

    PHV, UserCodeL_12 is a valid ID. I'll play with that. That addresses how to get the combo box to show the correct value. I'm getting the ID value on the report, and not the corresponding description. FYI: The contents of the table (tblEMPLOYEES_Extension_UserCode12) look like this...
  11. SBM1745

    using a listbox value with In() within a query

    I have a form, with a list box. The user selcts various items from the list. I want to print a report based on the users selections. So far I have this:Private Sub OpenSchedule_Click() On Error GoTo Err_OpenSchedule_Click txtSeeValue.Value = "" Dim intCurrentRow As Integer For intCurrentRow =...
  12. SBM1745

    Multi-column unbound combo data to report: error

    That combo box uses this as the RowSource: SELECT tblPAY_EMPLOYEES_Extension_UserCode12.ID, tblPAY_EMPLOYEES_Extension_UserCode12.Description FROM tblPAY_EMPLOYEES_Extension_UserCode12; ID is the ID/Key and Description is the corresponding description. The user selects a Final Check Disposition...
  13. SBM1745

    Access Query

    I am puzzling over your number of columns. I'm womdering if something like this might do:Dim ColumnSize as Integer ColumnSize = Len(qryMyQuery)Just a guess there. In Query Design Mode, enter -1 on the Criteria line for the first criteria. On the Or line for the rest of the columns, enter -1 for...
  14. SBM1745

    Access Query

    I'm a little confused at what you want from the column count, it sounds like you want to know how many columns there are in each table? or how many columns are checked? Check boxes store either NULL (No entry), 0 (False, no, or not Check), and -1 (True, yes, or Checked). To create criteria for...
  15. SBM1745

    Multi-column unbound combo data to report: error

    Read through http://www.tek-tips.com/viewthread.cfm?qid=1199817&page=1 and found an answer I needed. I was doing something similar in my form. I did get one oddity. My form loads and queries a table to populate comboTermFinalCheck. SELECT tblPAY_EMPLOYEES_Extension_UserCode12.ID...
See more

Part and Inventory Search

Back
Top