Search results for query: *

Thanks!

That would be great! I figured it was a missing reference as other functions work properly. I appreciate your prompt reply to my inquiry.

Are functions like Now() and Date() not supported in Access Run-time? My code works in regular Access; however, it errors out when executed on Run-time and this is the only reason I can fathom as to why this is happening.

I have read-only access to a SQL Server view which has 350+ columns. The column I need is past the 255th column, therefore inaccessible to Access through a traditional linked table. Is there any way that I can get data from that column without manipulating SQL server?

I think I got it. I wrote the following function Public Function excise(strField As String, intStartTrim As Integer, intEndtrim As Integer) 'Function to trim a constant amount from the beginning and end from a string 'intStartTrim is the number of characters to be trimmed from the beggining...

I am looking for the right function(s) to trim a constant number of leading and trailing characters off of a text field of varying length. Example: I start with these strings: 123_abcdefg_789 456_zyxwvu_987 I want these results: abcdefg zyxwvu I can get the first four characters off using a...

Well done, TonyJollans! A star is a pittance compared to the jam from which you have freed me!

Is there a way to close every open form and then open another form (like a main menu)?

No hard formatting, just carriage returns.

I have a linked table residing in a SQL server 2000 database. When I query a memo field from that table, it shows the control characters as well. Is there any re-formatting that I can do at the table/query level that will switch those to control characters that Access forms can use?

Thanks alot, mikevh. That was the problem. I just tripped over that even though I looked at it a million times.

Oops...that was just a typo. In the actual code it is correct and it still errors out.

It is a text control bound to a field with a hyperlink data type. However, when I go to debug it, the line with the text 'on error goto err_command68_click' is highlighted. I have used this syntax alot of times for error handling without any problems.

When I run the following code I get a 'Compile Error: Label not found' on the second line: Private Sub Command68_Click() 'The following line is where the code errors out On Error GoTo Err_Command68_click FollowHyperlink Outage_Log exit_Command68_Click: DoCmd.CancelEvent End Sub...