Recent content by PennWhite

Q: Is it possible to use a macro to open a new record that will be linked to a record in another table? Detail: I have two tables - Customers & Contacts. The Contacts are linked to the Customer by the CustomerID. I have a Customer Details form which contains a Contacts Subform. The Contacts...

PHV: Right. No particular reason to start with 0 since ListCount isn't zero based like the listitem index is. Thanks, Penn

Hmm. Never thought of that. In fact, I didn't actually know it was recalculating the listcount for each iteration but, now that you mention it, it makes perfect sense. Extending your thought, it would probably be quicker to assign rst.recordcount (which I use frequently) to a variable as...

Here's one solution that I just discovered. It ain't purty but it works. For cnt = 1 To rst.RecordCount Dim i As Integer For i = 0 To ctlList.ListCount If ctlList.Column(0, i) = CStr(rst!ServiceTypeID) Then varItem = i Exit For...

ACC03: I have an "F_Contacts" form which contains a listbox control listing types of services that person (record) provides. Some examples might be "Carpentry", "Drywalling", "Heavy Equipment Operator", etc. When the user moves from one record to another, I would like to display their previous...

That got it. Thanks very much. Penn Private Sub Form_Current() If HyperlinkPart(Me.URL, 2) = "" Then 'MsgBox "Hyperlink incomplete" Me.URL = Me.URL & "#" & Me.URL & "#" End If End Sub

Thank you very much. That helped a lot. I'm having a little trouble with the SQL for the Update query. This is what I have but it doesn't seem to work. UPDATE tblURLTest SET tblURLTest.URL = [URL] & "#" & [URL] & "#" WHERE (((tblURLTest.URL) Not Like '*#')); It adds the URL to the end...

ACC03 I have a hyperlink field in a form. I enter the URL in the filed by hand or imported from a bookmark.htm file and the nothing happens when I click the link. I looked at 'Edit Hyperlink' and the 'Text to Display' shows the URL but the 'Address' field is empty. If I cut and paste the URL...

Oops. Sorry. Just discovered you can do this... If you'd like to download the database (ACC00 ImportFavs.MDB), click here: Download

Just discovered you can do this... If you'd like to download the database (ACC00 ImportFavs.MDB), click here: Download

Cool. Thank you very much! Penn

Does anyone know if it is possible to use a 'toggle' button to switch between form view and datasheet view for a form? I've tried working with docmd and with a macro openview but neither seem to work. I can do it from the View option on the Menubar but can't figure it out programatically...

In the spirit of 'giving back', I have written a little database application using the above techniques. It allows you to locate the Bookmark.htm file on your machine and bring it into the database, creates 'Categories' out of the Internet Favorites Folders and SubFolders and then displays the...

Got it. Thanks. Penn

VBSlammer: I tried out your code and got a lot of compile errors (couldn't find various object types - RegExp, FileSystemObject, TextStream, etc.) My guess is that I need a Reference but I don't know which one to use. I tried including Microsoft Scripting Runtime but it didn't solve the...