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!

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

    ...someone help? <script> function get_sec(time) { regextest = /^(\d+):(\d+):(\d+)\s+(\w)M$/i.test(time); with (RegExp) { var sec = +$1 * 3600 + +$2 * 60 + +$3; if($4 == 'A' || $4 == 'a') return sec; else return (1 - parseInt($1 / 12)) * 12 * 3600 + sec; } }...
  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

    ...report so I can't use a form to apply criteria. My current code works like below: DoCmd.OutputTo acReport,"rptOfficeCounts", "SnapshotFormat(*.snp)", "\\servername\reports\SouthOffice\ordercounts.snp", False, "" I would like to specify a filter for the different offices so I can run the...
  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??

    ...System.Configuration.ConfigurationSettings.AppSettings(&quot;MM_CONNECTION_DATABASETYPE_objConnMeritas&quot;) %>' CommandText='<%# &quot;SELECT * FROM qm ORDER BY &quot; & SortField & &quot; ASC&quot; %>' CurrentPage='<%# IIf((Request.QueryString(&quot;dsSatisfaction_CurrentPage&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??

    ...System.Configuration.ConfigurationSettings.AppSettings(&quot;MM_CONNECTION_DATABASETYPE_objConnMeritas&quot;) %>' CommandText='<%# &quot;SELECT * FROM qm ORDER BY &quot; & SortField & &quot; ASC&quot; %>' CurrentPage='<%# IIf((Request.QueryString(&quot;dsSatisfaction_CurrentPage&quot;) <>...
  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