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 Chriss Miller 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 humbleprogrammer

  1. humbleprogrammer

    Remove data after comma

    That did the trick. Thanks Much! http://www.gosmart4u.com/
  2. humbleprogrammer

    Remove data after comma

    Hello - I have a bunch of data that has a comma and I would like to replace the , and anything after it. For example.. Glendale Height, IL 60139 I want to update to just Glendale Height Can someone let me know how I can do this with Access? http://www.gosmart4u.com/
  3. humbleprogrammer

    onclick not working in Netscape but not IE

    I finally got it to work by using: <a href="javascript:Link1();">1</a> http://www.gosmart4u.com/
  4. humbleprogrammer

    onclick not working in Netscape but not IE

    Hello, I have an onclick event in a hyperlink that works in Netscape but doesn't work in IE. Below is my hyperlink. <a href="javascript:void(0);" onclick="link1();">1</a> Below is the link1 function and asp code function link1() { document.orderform.goPage.value='order1.asp'...
  5. humbleprogrammer

    Subscript out of range when printing a worksheet

    Thanks Tony!! http://www.gosmart4u.com/
  6. humbleprogrammer

    Subscript out of range when printing a worksheet

    Hello, I have a form with a combo box that allows you to select the worksheet you want to print. When choosing "ALL", it works correctly but when choosing a specific worksheet, it give a subscript out of range error. Below is my code. Any help is appreciated. Private Sub btnPrint_Click()...
  7. humbleprogrammer

    Time difference calculations

    Hello, I am trying to calculate the difference between 2 times in hours/minutes. It works for the most part accept if the AM is before 1:00 AM. For example, if I enter 12:00:00 AM for the start time and 1:30:00 AM for the end time, I get -10.-30 for the result rather than 1.30 Below is my...
  8. humbleprogrammer

    Add filter to report before runtime

    Thanks guys!! This will work... http://www.gosmart4u.com/
  9. humbleprogrammer

    Add filter to report before runtime

    Hello, What you described above is exactly how I am already scheduling the reports to run. I have a module with all my scheduled reports and created a macro that calls that module. I them scheduled the macro to run nightly. I am just not sure how to apply the filter in the DoCmd.OutputTo...
  10. humbleprogrammer

    Add filter to report before runtime

    Hello, I have a report that is scheduled to run an outputs to a snapshot format. This report needs to run multiple times with different criteria. I would like to add a filter to it if possible so I don't have to create a different report for each criteria. Again, this is a scheduled report...
  11. humbleprogrammer

    Choose fields upon import

    Yeah, I know you can use the import wizard and create import specs but I was hoping to avoid this. The import wizard doesn't show you the field names in the table so you need to know the field names and manually type them for each field. I was thinking more along the lines of a dropdown that...
  12. humbleprogrammer

    Choose fields upon import

    Hi, I need some advice and would like to know if anyone has accomplished anything similiar. I would like to create an import feature that allows the users to choose which field in the table the field in the file should be imported into. There will be multiple files in different formats and I...
  13. humbleprogrammer

    Directory Selection for file export

    Thank you very much!! This is exactly what I needed. http://www.gosmart4u.com/
  14. humbleprogrammer

    Directory Selection for file export

    Hello, I have seen the axtive x an api file selections within this forum but am having trouble programming a directory selection for a file export. Here is what I am doing. I have an automated process that creates a txt file from a query and currently saves it to C:/ with a particular name...
  15. humbleprogrammer

    Passing value to CommandText??

    It was actually a typo in my post. I have it correct in my page. See below for the entire code. Should I be declaring SortField somewhere else? <?xml version=&quot;1.0&quot; encoding=&quot;iso-8859-1&quot;?> <!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot...
See more

Part and Inventory Search

Back
Top