Recent content by PeterWieland

Thanks for the reply. Unfortunately it does need to be the other way round. The set of fields is only an example, there are several more and don't fit easily on a screen width. The number of dates (i.e columns) would rarely go above 5 (5 year write-off of electrical equipment) and never more...

I have searched for ages and can't find quite what I am looking for. I want a subform, in table format, that expands depending on how many records there are. I will try to explain. The parent form brings up the inventory record for a particular piece of equipment e.g. a desk lamp which has all...

Thanks for the replies folks. In the past when starting a database from scratch, I've always started with a table for the primary information and use that as the 'master' table. In this instance the primary purpose of the database is to store PAT results, so that's where I started! I think I...

I take care of the portable appliance testing for several charitable organisations, as well as my own equipment. I want to move from paper Word document records, and thought it would fairly simple! I've designed some fairly complicated databases in the past (over 10 years ago!), but I seem to be...

I am trying to connect to a remote MySQL database. This is a database that is linked to an eCommerce solution on my website, and as such cannot be changed. When I link via ODBC (Oracle v5.03.04.00 ANSI or Unicode) and look at the tables, all the varbinary fields that should contain English text...

Not sure if this is the best way to phrase the title, but I couldn't think of any other way. I have 2 tables; 1st table is automatically recorded data from a scientific instrument that has columns for date, record number and then around 50 measured parameters. Each new day starts the record...

Thanks for that. Yes, there are nulls, but not just in the Finish field, there are nulls in the Colour field as well. This seems to do the trick. There are a lot more fields involved in the full query, but this gives me the basic principle so I should be able to sort it from here. Thanks again

Hi, I thought this would be really easy, but I am struggling to find a solution. I have several part lists in seperate spreadsheets which I want to import into access as one table. Each spreadsheet has the same columns, but some parts appear in only one spreadsheet, some in several sheets. I...

I have 2 seperate workbooks, both with many worksheets. I need to get some data from one of the workbooks and copy it to the other, and I need exactly the same cell range from each of the many worksheets (the worksheets have the same name in each workbook). I have the following formula which...

Thanks Lagbolt, I knew it would be something simple!

I have a main form (Form 1), with 2 combo boxes and a subform. The record in the subform is dependent on the 2 combo boxes. This works fine. I have added a subform to the subform, the record displayed should be selected by a combo on the first subform. This doesn't work. When the first subform...

Thanks RuralGuy, I checked the query, and yes it is updateable. I commented out the line that disables error checking, and got a 'data type conversion error'. Changed "yes" and "no" to True and False and it works. I hadn't realised that On Error Resume Next disabled error checking! Note to...

I am running some code based on a query to update a field in a table:- Dim db As DAO.Database Dim rst As DAO.Recordset Dim FileExistsbol As Boolean Dim stFileName As String Set db = CurrentDb Set rst = db.OpenRecordset("qryTestMediaFiles") rst.MoveFirst Do...

Thanks for that, works fine. I just need to try it on my live DB, with over 10,000 records to see if speed is an issue. It seems that Randomize does not do quite what the documentation would seem to suggest! Ah well, thats Micro$oft for you!

No, makes no difference. I have attached a cut-down DB to show the problem. Only has 1 table, 1 query, 1 form and 1 module. If you load the DB and open the form you should get records 7,4,5,2,3,1...... Close the form and open it again, you should get 3,9,10,6,5,1....... Completely quit...