Search results

Hello all, I am putting together a data entry form to input data into a Landings table. The aim is for the user to be able to put in several records for different vessels and landed weights but with some values staying the same e.g. Date and Officer Name. I Made a main form with the text...

Genius - it worked when i changed the columns to Expression Cheers again! Luke

I am indeed using a GroupBy cluase - how did you know that! mental. Anyway heres the SQL - is that what you meant? By the way i didnt write this - im using the query builder. SELECT SumOfficerObsQ.FshID, Sum(SumOfficerObsQ.SumOfLandedWeight) AS SumOfSumOfLandedWeight...

Hello all, I have put together a query which has several expressions in which are subsequently used, within the same query, to make another expression. The query runs fine and gives correct calculations however, it prompts the user to enter a parameter value for the expressions used to...

Awesome... so i could have multiple front ends and just one table and they could all still enter data into it at the same time? Just checked that setting and its set to shared. Cheers Paul!

Thanks for that Paul, I agree i have made this very difficult for myself - one of the things i need to be able to do though is set it up so more than one user can input data at once i.e. so it doesnt stop them from entering the db because someone else has it open already. Can i split a single...

Hello there! Yes very interesting job, very varied, lots of interesting characters too... I live in Norfolk (East coast of England), in a town called King's Lynn. Many thanks for the welcome, Luke

Hello, Firstly, apologies if this is in the wrong place - never used a forum before... So - I am trying to make an db that multiple users can input data into at the same time. My thinking has been to make a table for each user, split the database - a back end db for each user, get each user...

Hello everyone! I am Luke, a Marine Biologist from England, UK. I work for a local Fisheries Authority where i get to do lots of exciting stuff like chasing fishermen across the sea in fast RHIBs - i also do a lot of work with our data management. I taught myself some vb to make a program...