Search results for query: *

Hi, I am using Access97 (I know!) and have a list of values populated from a table. These values represent items with errors. My problem is an item can have multiple errors but I only want to show it to the user once. After I have built my string of items containing errors, is there a simple...

Thanks Geoff! Works a treat.

Hi, I am trying to sort my record set (ascending) by a character field that contains either decimal values or "N/A". One subset has the following values: -29.7 -239 -199 The record I want (lowest value) is -293, yet the -29.7 appears first. I can see why but can't find a different way of...

Hi Zameer. The A2000 version returns only one engine with a negative or zero remaining life whilst the A97 version returns 3. A2000 Engine: Eng1234567 - 0 hours remaining. A97 Engine: Eng1234567 - 0 hours remaining 59K - -27.5 hours remaining 60K - -30 hours...

Thanks Zameer. I have the reference already. It won't compile with out it. Any other ideas?

Hi, I have converted my Access 97 database to Access 2000 and I now have a function behaving oddly. It works fine in 97 but now returns inaccurate results in 2000. Function below: Function getLifeExceedenceList() Dim rsEngineList, rsEngineComponent As DAO.Recordset Dim idx, x As Integer...

Thanks for that. I'm still not clear on how I can save the two queries and use them as sub reports. I'm not very experienced with VBA. Thanks again for your help.

My table is as follows: Field Name Data Type engineId text (puk) component text (puk) PartNo text SerialNo text LifeHours number LifeCycles number TotalHours number TotalCycles number RemainingHours number RemainingCycles number For...

Thanks for your help so far guys. What I have done is build a function which runs two queries, one to get the lowest bearing life and another to get the lowest component life. I then create a temp table record for each query for each engine. That's the easy part the data in the temp table is...

Hi, I need to generate a report but am not sure how to select the correct data. In my table I have a list of engines with a static number of parts. Each part has a remaining bearing life and a remaining component life field. For each engine I need to report the part that has the lowest...

Thanks to everyone that helped here. Much appreciated. It turned out the the solution that best fitted was Geoff's idea of using format$. Thanks again .

Thanks Geoff. Any suggestions as to how to get around it??

Hi, I want to order my recordset by a character type field that contains either "N/A" or integer values. When I sort it (asc) to get the lowest hours remaining for the currently selected object I get weird results. for instance "10000" is less than "1250"! Am I missing something? Any help...

Hi, I have the same problem. How did you get the print icon to show?

Hi, I have several reports which run in preview mode. The data displays on my screen OK, but I don't have any icons on the preview screen so I can print the report. I don't have this problem on my PC, this is happening on the client's machine. Any Ideas?? TIA Rod

Hi, WINNT/Access97. I have developed a database in Access 97 (I Know!) and have user level security activated. I have sent the .mdb and the .mdw to the customer, who does not get prompted to log in just goes straight in. Can anybody tell me what I need to do to get the user security going on...

Thanks PH. Sort of worked! My text boxes are now being populated with the data from the List Box, however I am now getting run-time error 2115. Any ideas? Regards Rod

Thanks for that. Maybe I am missing something...In the VBA editor when I type application. etc. I do not have the 'enableEvents' property in the select box. Simply typing it in generates a run time error. Is there some setup required for this? I am using Office 2002/WinXp. Regards Rod

Hi, I have a list box and several fill-ins on my form. I have populated the list box with data, and when the user clicks on it I want to populate the fill-ins with the list box data. In my listbox click event I grab the data I need, setfocus to one of my fill-ins and assign the fill in a value...

Hi, I am attempting to open a DB created using W2K using WinXP. Every time I open the DB the windows installer pops up then proceeds to 'Installing: Microsoft Access Feature'. After this completes I immediately get the following error: 'The expression On Load you entered as the event property...