Search results

Hi I want any all companies that have a serial number associated with it, but only one instance of each of these companies

I have a need to limit the number of times a company comes up in a query result. I have two tables: tblStationData, and tblSerialNumbers I have tried SELECT DISTINCT tblStationData.StationID, tblStationData.[Station Name], tblSerialNumbers.SerialNumber FROM tblStationData INNER JOIN...

Hi Mark Maybe I did not explain clearly...your solution works fine for that table....I have another table...that requires a similar solution tblESSRates tblESSRates I was trying to change the KG field of the previous example to suit the OriginCountry field here...any thoughts would be...

Hi Mark I have used your code successfully...What would need to change if the field eg KG was a text field instead of a numerical field?

I have managed toimport my spreadsheet in to replace your existing table (my table ranges from 0 to 300KG) and your form is working

Excellent...above my level of VBA but seems to be giving a result for a KG twice that entered eg I enter 4.5 in the Kg box and 2 in the Zone box i get a result of 133.3 which is the number for 9KG?

Hi MajP, Managed to transpose the spreadsheet OK (learn something every day). In my instance where the user is quoting a possable sale and wishes to enter a product and get a freight cost for that product, do I need the weightstart and weightend? It seems that the requirement is one need at a...

Thanks for all replies.. see how I go Have to fit this into other requirements

Thanks Mate, I will wrap my old mind around this (80yrs). seem the solution

Thanks mate, I will digest this...2.75 is to round up

I have a table imported from Excel...(Screenshot below) It relates to freight charges and I am required to programme vba to allow the user to enter say 2.5 Kg and Zone 4 and have the answer 109.75. I have no idea so am looking for any ideas which will be much appreciated Thanks Bob KG...

Hi I have adapted your code to suit, and it works to find the first matching record...how do I get it to move to the next matching record This form is not a subform but one that opens with an ID from the previous form Here is my code: Private Sub cmdSearch_Click() On Error GoTo...

Not sure what you mean...what search button? Bob

Thanks mate will work on that approach Bob

I have a form (frmContactDetailsPower) with a form (frmProgressiveNotesEntryPower) linked by [StationID] from txtStationID. Form frmProgressiveNotesEntryPower is linked to a table (tblProgressiveNotes). I need to be able to search the table (limited by the StationID) for each instance of a...

Hi, I am a selftaught access programmer working for my son's company. I am by no means professional