Search results for query: *

Thanks MajP, this looks useful. Duane, couldn't find any properties for a hyperlink field and searches suggested there weren't any options.

Is it possible to format a hyperlink field and change its behaviour when clicked? I'm displaying a list of links in a subform in datasheet view and it looks messy with the underlining and colour changes.

Thanks Strongm, already did a compact & repair but it didn't remove them. Seems like the only way is to export everything to a new database, huge task. Since the database works fine I'm inclined to leave it as is and just use On Error Resume Next so the code export routine completes.

Thanks for all the suggestions so far, much appreciated. Stepping through the procedure the thing that's tripping it up is one of the temporary forms, Form_~TMPCLP624811. As before there are also several temporary reports. For all TMP files the Remove option is greyed out so what's the...

Thanks Duane but this gives a 'permission denied' error instead, on the line strFolder = strFolder & "" I've checked the working copy and AllCodeToTextFile("C:Code", "txt") definitely works, somehow sending the text file to My Documents. In the latest attempt I went back to Remou's code here...

Any help would be appreciated. A run-time error -2147024809, 'Invalid procedure call or argument' has suddenly appeared in a procedure that worked fine in earlier editions. The changes I've made since then have been cosmetic ones on form and report formats. I'm using Call...

Great, thanks, just what's needed

I'm creating a map in Mapometer, exporting it as a gpx file and importing it into Google Maps. This works to a point but only segments of the route show, and then as dense collections of trackpoint flags. How can I get a simple line for the complete route? My objective is to be able to embed...

In a query that asks for a Start Date I'm trying to cater for people just hitting return when asked. If they do this I'd like the start date to be some default value. This SQL produces no results so suggestions what's wrong? PARAMETERS [Enter Start Date] DateTime; SELECT...

Sorry, false alarm. The reference was in the Grouping and Sorting setup.

This is driving me mad. When modifying the fields used in a report I keep getting 'Enter parameter value' for original fields no longer in the source query. Running the query doesn't produce the same result, ie it opens properly. I can find no reference whatever in the report design and there's...

Top man PHV, that does the trick. How does it work?

Did try that and while it clears the list box it then prevents it being repopulated after choosing an Activity. The list box source uses Select Distinct dates from the original table, with the combo's Activity as criterion. I've put in a Recalc and Requery to no effect.

I'm setting up a selector form for people taking part in a series of activities. This will draw data from a table including Activity, Date, Person and ActivityType (Regular or One-Off). The selector form contains and an option group a combo and a list box. The option group sets the rowsource...

Thanks PHV, just what I needed. Didn't even think of that.

The form I want to open to a blank record displays data collected in an earlier activity booking form that builds records in tblBookings containing names and Activity. The new confirmation form uses tblBookings as source and there's an unbound 'Find Activity' combo using as source all unique...

I have now circumvented this problem by removing the attachment field and using links to the documents needing to be recorded against a Job.

Thanks Duane, you're continuing help is much appreciated. I found a good solution in TheAceMan1's contribution to this post http://www.tek-tips.com/viewthread.cfm?qid=1289131 This does what I want and allows selection of a file then creation of a link to it in a text box. To make the link...

Thanks Duane. I've done this for my own use but my client would probably find it tedious to have to find the file location and paste it in, compared with the convenience of using an Attachment field. Would it be possible to create some sort of browse facility so she could steer to where the...

My client uses a Jobs table with attachment field to store JPG scanned images of the work being done, maybe as many as 8 images. The backend database containing the table is growing rapidly, already up to 0.75GB and likely to go on growing at the same rate. Instead is there a way to store just...