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,
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...
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...
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...
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...
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="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"...
Hello,
Yes, I have tried that and have tried below
Dim Sortfield
If Request.QueryString("SortField") <> Nothing Then
SortField = Request.QueryString("SortField")
Else
Sortfield = "Firm"
End If
I still receive the error "Name 'SortField' field is not...
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="VB">
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.