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 SkipVought 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. 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...
  16. humbleprogrammer

    Passing value to CommandText??

    Hello, Yes, I have tried that and have tried below Dim Sortfield If Request.QueryString(&quot;SortField&quot;) <> Nothing Then SortField = Request.QueryString(&quot;SortField&quot;) Else Sortfield = &quot;Firm&quot; End If I still receive the error &quot;Name 'SortField' field is not...
  17. humbleprogrammer

    Passing value to CommandText??

    Hi, I am trying to pass a value to a DataSets CommandText. I am trying to pass a sort value. Below is my code but it's giving me an error that 'SortField' is not defined. Can someone help? Thanks in advance!! <SCRIPT language=&quot;VB&quot;> Dim SortField SortField =...
  18. humbleprogrammer

    Sort a Repeater

    Hi, I have added sorting to DataGrids but have not had any luck implementing sorting with a repeater. I have a form drop down selection with the sort fields listed in it and 2 checkboxes (ASC and DESC). I would like the repeater to sort based on what is chosen from the form. Can someone point...
  19. humbleprogrammer

    Query Cache Help

    Hi, I have a VB front end that works against a MySQL backend. There is a search module that displays matching records and allows you to edit and delete records. If records are deleted and the user than does another search, the results still display the deleted records even though they are no...
  20. humbleprogrammer

    Import text file with data on 2 separate lines

    There is actually a CRLF. http://www.gosmart4u.com/

Part and Inventory Search

Back
Top