Search results for query: *

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

Thank you very much. This looks like it will work beautifully. I have read that an XML approach might be better but I don't have the experience to do that yet. Actually, I learned a great deal about using RegExp just by studying your code. I have used them in PERL but hadn't seen how to use...

Does anyone know of any code samples that show how to import a Bookmark.htm file (from MSIE or Netscape) into an Access table? Since the Bookmark.htm file is not a table, the built-in Access TransferText - Transfer Type - Import HTML will not work. Thank you very much, Penn

More info: Question: "How would i go about saving the data in a calculated textbox on a form into a field in a table? For example, on the form there is =[MatchedPages]+[UnmatchedPages] that I put into a textbox. I now want to store those results in a table with the field titled TotalPages...

I did find this and it may be the only way. Seems like there could be something a lot simpler but maybe not. - Penn http://support.microsoft.com/?kbid=209172

Ramsey - Same problem. Did you ever get (or find) an answer? Thanks, Penn