Search results

I have an SQLServer DB which contains times for competitors who have taken part in standard distance running events. Some competitors have taken part in these events more than once. How can I show their best result without showing any of their subsequent results. J-F

The trouble is that the DB comprises of hundreds of competitors, some of which have taken part on more than one occassion. I just want to show their best times without deleting their other times, so I can't see how TopValue would help.

This is for a website which holds triathlon results for standard distance triathlons throughout the year. The following gives me a list of results from the year for all competitors. The trouble is that if a competitor enters more than once, they will be shown with more than one result. What I...

Is this a known problem? I have a table which includes some times (00:22:22 etc). When I do a query asking for all times <#00:22:22#, 00:22:22 always shows up. If I do the same query using a lower time, it returns the correct results. Whats going on. What I'm trying to do is get someones placing...

Is this a known problem? I have a table which includes some times (00:22:22 etc). When I do a query asking for all times <#00:22:22#, 00:22:22 always shows up. If I do the same query using a lower time, it returns the correct results. Whats going on. What I'm trying to do is get someones placing...

how can I just display the MM:SS of a HH:MM:SS time?

Is the 2184 characters limit actually recognised by Microsoft? It tried to do the same thing a few weeks ago where access would crash after setting up and sending the first email from a whole list of addresses. I thought that it might have been the fact that the content of the textbox was too...

Instead of entering UK address in full, how can you enter the post code and street number only? Is it a case of connecting to a comercially available database and transfering data from the postcode query to the address fields? If so, where can I get a post code database? And how much? J-F

I don't think it can be done in code. The easiest way is to set your default account in Outlook before you run the procedure. You can then reset the default to whatever it was before.

I have a database where I record the results for competitors of Triathlons. TotalTime SwimTime BikeTime RunTime etc etc etc I need to get their positions both overall as well as for the swim, Bike and Run, using the COUNT function. Do I have to do a seperate query for each discipline or is...

I have 2 times (hh:mm:ss) where I need to show the difference between the 2 but show a negative value should the second time be larger than the first. I have tried the following which works but doesn't give a negative result. FormatDateTime(((oRSMyResults.Fields.Item("TotalTrans").Value) -...

I have a database with a time field (hh:mm:ss) amongst others. There will be hundreds of entries to be made. The times entered will be the times taken to do an event and will never be more than 1 hour long. To simplify the data entry, I want to have a minutes textbox and a seconds texbox only...

Looks like were working on the same project. This works for me. '*********************************** 'NAVIGATING USING THE CALENDAR '*********************************** Private Sub DutyCalendar_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "MyForm" stLinkCriteria =...

Thanks a lot. it works like a dream. What I want to do now is have criteria copied to the clipboard? What I have done, which works fine, is make an invisible TxtBox.Value as criteria and copy that. Like this: '===================================== 'SELECT MULTIPLE PCS AND COPY TO PASTE...

How do I get the selections from a multi select box into a string seperated by a space? ie "2 6 8 13" Thanks in advance. J-F

Done it. After a lot of messing around, I managed to do what I wanted. Appologies for the post.

I have a form with a large textbox with line feed enabled. I presume that this inserts a VbCrLf into the string. On this particular textbox, I need to manipular the data in a way that the number, which is at the start of every line has a space both in front and behind it in order to perform a...

Thanks SC. I've actually done it the way Microsoft suggested but your way would have been so much easier. Thanks again. J-F

Brilliant. It works. Thanks a million. J-F

Has anyone solved this yet? I'm having problems galore with a report. Because I want to run the report in collumns as opposed to rows, on Report_Open I open a recordset and run through the records assigning the relevant values to the textboxes. Everything works appart from the assigning the...