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

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?

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

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

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

I'm trying to open a report using a date field taken from a form to build the sqltxt. The date on the form and in the table is in UK format (dd/mm/yyyy). I have read that access, when in vba, reads it in US format (mm/dd/yyyy). What can I do to the function below to convert the date from UK to...

I thought I'd got this one sussed but it's not working. I'm trying to find if any 2 arrays are of the same value. I have this.... while x < UBound(PcArray) While y < UBound(PcArray) If PcArray(x) = PcArray(y) AND (x <> y) Then msgbox PcArray(x) & " has been enterred twice!"...

Is there an easy way of finding out how times a certain character occurs within a string. In other words, String is "asf[asgfsa[sg[dfdf[df[fdg[gf" How many times does "[" appear. Answer = 6

I'm trying to do a duty roster for 70 workers. They are identified by a three figure number. Their numbers are enterred in various TexBoxes to show their tasks for the day. In order to check that I haven't missed anyone out, I have the complete list of available workers in a listBox. I'm...

How can I prevent someone from altering the design of a form. I know how to password protect the code but not the design. Many thanks.

Is there a way of including vbCrLf in a text box. I have a large text box where I would like for a VbCrLf to be inserted when you press enter. I would also like the carriage return and line break to be shown in the text box by way of a new line. Similar to a <textarea> in HTML.

How can I populate a list box using an sql query using variables from 'option group' controls?

I have a text box on a form with an 'On Lost Focus' procedure. I need this to work every time it loses focus but only seems to work on the first occassion of it losing focus. Is this correct? If so, how can I get it to work everytime it loses focus?

I have a form with a large number of text boxes where the info entered are all 3 figure numbers. In some of the boxes, there sometimes are 2 sets of number seperated by a comma (123,456) and in others, there may be nothing. I need to be able to add all those numbers together and display the sum...