Recent content by BillR

Thanks Guy(s). That will do it!

I have seen one or more articles on this forum about a function for generating a proper name format from a string. Now that I need it, I can't find it. I don't want to re-invent an already good wheel. Ideas?

CompG, I hav an application where I faced about the same problem. My solution was: create a user table with an access level field ("1" - "3" in my case)and associated form; after my splash screen displays, a password screen is opened; database properties are turned on or off depending on a code...

In the samples that come with Access (I don't remember which one), there is a "set properties" module which works fine. I modified it slightly so that I can set 3 different password dependant security levels from an "Enter Password" form. ( I have a user table with a security levvel stored for...

Thanks Rich! I found 1 hidden text box that could come into play if user tried to enter null or "" date. It had an input mask instead of short date format. It could update dates from a multi-select list box - meaning it could corrupt many dates with 1 click of the button! All others are...

I have a rather large access application that inputs, stores and tracks, etc. a lot of dates. One user has a problem with various dates in her tables showing up 12/31/1899. I cannot make the system do it on my computer. I have tried adding and removing input masks, formats, traps etc. to no...

Why don't you create a query with 'date' as the criteria for the key field for your report. Change the data source for your report to the query name.

I have a Treeview control on a form that works great - except that all expandable nodes are expanded when the form opens. The control displays a rather large list and the user will likely want to expand 1 or 2 nodes at a time. Can I default the control to a not-expanded condition when the form...

I have placed a treeview control on an access2k form and successfully populate it in the form's "onload" using 2 tables: Depts and Associate. Generally it works great - except that when I open the form the control is displayed with all expandable nodes expanded. I can click the minus signs (to...

Mike, I use the following code to configure and open a hyperlink to a user selected Word document: Private Sub List60_DblClick(Cancel As Integer) Dim jprvar, mx1 As String, tx1 As String, resp As Variant mx1 = "Can't find JPR# " & Me!List60.Column(1) Me![Text56] = makelink(Me!List60.Column(1))...

Erick, I use the code below to create and follow a hyperlink from a list box line the user has dblclicked. "Command44" is not visible on the form. In truth, I don't think it has to physically exist but since it NOT VISIBLE, I can put it anywhere out of the way. Dim ctl As CommandButton, i As...

I recently installed O'P'2000. Now my Access application will not open Word via hyperlink or Object. It will not open Excel. Neither application becomes visible. Any ideas what I missed? Since I first posted this, I have solved the hyperlink problem. As usual, a really dumb mistake. Opening...