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

    Reply Address

    We have a distribution list which has an internet email address. The users in the list can all receive any emails sent to that address ok, but I would like to have the system setup so that if any of them send emails, the reply address is that of the distribution list. Is this possible? Many...
  2. mattcottrell

    Running VB Script in a web page

    I am trying to create a html page which has a button on it which logs off the user. The script works fine when I do it in VB6 but all I get is the message box when it is in the html page. are there any limitations to what scripting you can use in html. Here is the html script: <HTML> <HEAD>...
  3. mattcottrell

    Running VB Script in a web page

    I am trying to create a html page which has a button on it which logs off the user. The script works fine when I do it in VB6 but all I get is the message box when it is in the html page. are there any limitations to what scripting you can use in html. Here is the html script: <HTML> <HEAD>...
  4. mattcottrell

    Column Range Variable

    Supurb, You are a true genius. That worked a treat. Once again many thanks Matt
  5. mattcottrell

    Column Range Variable

    It hides columns C to AL ok, but it doesn't set the column width of the specified columns to 8.43 (does nothing, no error) It does work if I hardcode the columns in instead of using the variable. eg: &quot;Columns(&quot;P:AA&quot;).ColumnWidth = 8.43&quot;
  6. mattcottrell

    Column Range Variable

    I am trying to hide certain columns based on a value entered into a cell. This is what I currently have: Sub Prepare() Dim MonthNumber As Integer Dim MonthRange As Range MonthNumber = ActiveSheet.Range(&quot;C3&quot;).Value If MonthNumber = 1 Then Set...
  7. mattcottrell

    Turning off Replication

    We have an Access 2002 database which has been setup for replication. Does anyone know how to turn off replication for the database or any other way to delete the fields automaticaly created in each table by the replication process. Many thanks in advance. Matt Cottrell
  8. mattcottrell

    Passing null to a user defined function - Help!!!

    Many thanks for your help Christiaan, but unfortunatly that didn't fix the problem. I did manage to fix the problem myself however by declaring Value1 as a Variant rather than a string: Public Function NumberCorrection(Value1 As Variant) As Double Dim Var1 As string If IsNull(Value1) Then...
  9. mattcottrell

    Passing null to a user defined function - Help!!!

    Hi, I am trying to write a function is passed a string and returns a number It works fine untill I pass it a null value, I get an &quot;Invalid use of Null&quot; Error Here is the code I have use for the function: Public Function NumberCorrection(Value1 As String) As Double Dim Var1 As...

Part and Inventory Search

Back
Top