Search results for query: *

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/

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'...

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()...

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...

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...

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...

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...

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 =...

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...

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...

Hello, I am hoping someone can help me find a solution for this. I have reports in .txt format that I receive from outside offices. I need to import these files into Access and then match the data to existing orders. That's all fine but the report formats have the data on 2 lines like below...

Hello, I am probably missing something obvious but can someone please help me trouble shoot this code. I am trying to pass the office value stored in the table in the querystring but it's not working. Thanks in advance! <?php include(&quot;Connection.php&quot;); $strQuery = &quot;SELECT *...

I have a db that allows users to import text files into a pre-built table. On occasion, the imports create import error tables. The errors in these tables are not important data and I would like to automatically have the error tables deleted so the db doesn't get polluted with a bunch of...

Hello, I would like to display how many hours have elapsed between 2 times. The times are stored in the MySQL database as time data types. I have been able to calculate the difference in seconds but haven't had any luck converting that to hours. Below is what I am currently using...

Hello, I am displaying data on a page with a repeater. Currently its looping through each record and displaying the data from top to bottom like: value1 value2 value3 value4 value5 value6 I would like it to display the data from left to right 3 at a time like: value1 value2 value3 value4...

Hello, Is there a way to load another page when the back button is pressed? I have a Flash intro page, which then leads into the main site. The client doesn't want the Flash intro page to load again if the visitor clicks back, he instead wants another page without Flash to load. Thanks in...

Hello, I have a function that hides certain elements in a page, changes the background to white and is supposed to change the font color to black when the page is printed. Everything works except it doesn't change the font color. Below is my code. Can someone glance it over and shed some...

Hello, Can someone help me out with the following error? I am stumped. Thanks! Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code...

Hello, Can someone please help me out with the following error? Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding...

Hi, I am not very familiar with PHP and am hoping someone can help me with sessions. I am trying to store a querystring value in a session and if the value doesn't equal something, I want it to route the user back to the main page. If it does equal the specified value, I want it to stay on...