Search results for query: *

Thanks guys. I'll go with PHV's solution as it was what I was trying to do in the first place. Thanks again. OM

Apologies - just to clarify: Tempbatchid is the table field that I am checking to see whether the form value against. The form value is also called tempbatchID: DoCmd.RunSQL Delete tblStoredBatches.TempBatchID FROM tblStoredBatches WHERE (tblStoredBatches.TempBatchID) = Me.TempBatchID.Value OM

Hi I have a form in which the use enters a batch number. On clicking Continue, the table is referenced to see whether the value exists or not. If it does then the user has the option to delete the row in the table. The code I am using for the delete query is as follows: DoCmd.RunSQL Delete...

Duane Believe it or not - your post solved it for me. I'm trialing code and I had a lot of misc unused code that I skipped with GoTo. Based on your thread I decided to take out all the garbage and hey presto it now works! Thanks OM

Hi all I have the code below in my on click event in a form. The append query referenced will not run and I am getting no error alert. When I then go to the database window and manually double clik the query it works with no problems. My call for the query is simply: DoCmd.OpenQuery...

Perfect. Thank you. OM

Hi all I have a module written to import a text file into my access database. The name of the text file will change about every 3 days or so and is not predictable. I need the user to enter the name of the new file on my form such that my module can then read the name and open it. Can anyone...

Thanks for the information fneily. I've plenty to think on. Owen

JB - Correct. 12 is physically the number of weighing cells on the machine and 12 capsules are weighed at any point in time. JB - Your formula is for summing columns in a row as opposed to counting the number of values across columns in a row that meet a certain criteria. PHV - Union query...

Thanks for the reply guys. fneily - Funny you should mention the Fundmentals of Relational Database Design as I read it last night! As far as I can work out my table satisfies 1NF, 2NF and 3NF. Maybe if I give you a little more detail about the data. I have an utomated weighing scales that...

Hi all I have a table with 13 columns. Column 1 is my primary ID. The other twelve columns are all weights measured against the primary ID. I need to create a query to count against each primary ID, the number of weights that meet a certain criteria. I can create the SQL for the count for...