Recent content by TurboBeagle

Yes, that is a typo, should say "1" instead of "2". The field "LINKS" is formatted as a hyperlink. That is the source of my fustration. I can't say the field LINKS = 'address', wouldn't that change the value in the field instead of the field's hyperlink address? Sorry for my stupidity...

HELPPP!!!! Ok, I admit defeat. I don't seem to be able to get the Hyperlink object set. This is my code: Public Function HyperlinkAddresses() Dim DB As Database Dim cs As TableDef Dim cs2 As Recordset Dim Field1 As Field Dim links As Field Dim Name As String Dim Hyperlink1 As Hyperlink...

I am still a programming baby. I want a module that will update each fields hyperlink address. I can't seem to find the code that will specifically point to the hyperlink address property and then enable me to update the value. Any suggestions?

Rose, thanks so much, it did the trick.

The first part of the module I am trying to create is where I am creating a new table based on an existing table. At this point, I am just trying to assign each record in the newly created table the same value as the records in the original table. The error I keep getting is: 1-You tried to...

I am querying on a query. The first query is taking out bad data (and replacing it with NULL). The second query is using the TOTALS function, and I am trying to use the AVG of the field. The query says the field is no longer a value field ("DATA TYPE MISMATCH IN CRITERIA EXPRESSION"). The...