Search results for query: *

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

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

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?

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