Recent content by Lyncroft

I've a field and in each row the data is AB1234, ABC1234, AB235, etc. I want to extract just the letters at the beginning. Usually there are either 2 or 3 letters before you hit the numbers. Is it possible to do this. I was thinking along the lines of trying to find the first number and...

I've converted a 2002 database to 97 but when I launch the 97 version I get the message "can't assign to array" and takes me to the code. I also converted it to 2000 and it works okay so there's something I need to do with 97 version. Anyone point me in the right direction. Thanks in advance.

Thanks for all your advice. It's given me something to think about over the weekend. I just find it quite annoying that the people who obviously haven't done their jobs properly now expect a database to simply solve all their problems. :rolleyes:

Thanks and I can see the sense in that. Sadly, they don't even know what licences they've got!

I've been asked to create a database to look after our licensing issues to control who has what software on their machine. A nice project I thought but my problem is the current data is a complete mess in that there has been no control over people sharing/putting software on their machines. For...

Thanks for that. Yet another case of thinking so hard about it I missed the obvious :cool:

I've a query using the Totals feature which is counting the number of licences issued (column 2)to the actual number of licences available (column3) SName CountofSname NoLic Photoshop 6 5 Word 5...

Thanks for all your help Mailman. I've learn quite a bit here. I'll sit down and have a good think about it. Thanks once again.

Thanks for all your help on this one Mailman. Think I’m going to have to admit defeat. Spent hours on it. I made your changes and I can see what’s happening. My qryAllData shows LabID LabName OutHrs Analyte Matrix 45 Foxys Yes Carbon Apples 45 Foxys Yes Calcium Apples 50 Murphys Yes Calcium...

Hello again. Thanks for being patient! Here is the code. There is another list showing yes/no whether the lab works out of hrs (this isn't essential). I'm using qryAllData to give me a list of LabID, LabName, OutOfHrs, Analyte, Matrix. Off this qry I'm creating qryDataType to produce a list of...

Hi again! I've two list boxes: Analyte Sulphur Carbon Sodium Ore Zinc etc Matrix Fruit Fish Marrows Shellfish Say we want to pinpoint labs that can do a very specific combination of Sulphur, Carbon and Fruit I would select the relevant items from the listboxes and it loops thru and picks...

Cheers for that Mailman(Namliam). You're right I've got 5 tables including the 2 look ups. At the moment I've a main form with the Lab details and a separate subform each for Analytes and Matrix in tabular form using a combo box. This works well enough for inputting. My problem is getting the...

Some general advice needed here. I've a list of laboratories who deal with Analytes(eg, ore, zinc, iron). There could be 200 plus of these. The labs also deal with Matrix(eg, fish, herbs, shellfish). The way I set it up was: tblLabs LabID(PK) LabName tblAnalytes AnalyteID (PK LookUp)...

Thanks to you both very much. Got it to work finally!

Had to admit defeat I'm afraid. I got the following code to work to produce a dynamic query using 3 multiselect list boxes. Works fine. The 3 listboxes are lstConsulation1, lstStakeholder1 and lstCountry1. However, it only works if I make a selection from all 3 lists. If I leave one out I get a...