Search results

Not exactly elegant but does this work for you?

I am trying to create a DB that was Originally an Excel Spreadsheet. The Spreadsheet performs a Cumulative calculation based on values from the cell above. e.g Row 2 =(SUM($E$2:E2))/(SUM($D$2:D2)) Row 3 =(SUM($E$2:E3))/(SUM($D$2:D3)) Row 4 =(SUM($E$2:E4))/(SUM($D$2:D4)) The cell is formatted as...

Finding the autonumber just added. This is what I need to acheive but don't know how to code it can you assist? Thanks

I still don't get but its working and that's what counts right?

I have now and its working again. I have no idea what the decompile did, if anything, maybe just the act of rebuilding the MDE made it work. But this has been done many times before, it may be just a matter of time before it will fail gain. As I said in my original message just loading and...

Thanks Tony Ok, done that. The db opened I did some work, added records etc and navigated through the forms. It behaved correctly and without errors. What should I be expecting to happen while in this mode? Error messages? Because none appear. I am fairly confident that my code is not to blame...

No. How would I go about that task?

I have a database split into two parts, one for forms and the other for data which is linked (FE/BE??). The Forms one has been compiled/converted into an MDE type. The files are both on a network drive. The MDE is called via a shortcut from the desktop. Firstly, are there problems with this...

The results of the query gives me the record I want. If this record type cannot be updated how can I get the record I want without using aggregates? I don't know the LastUsedDate so I can't implicitly use it. Sorry but I just don't get it.

Fuzzy, Using the DAO example you gave, my code still states that 'Database or object is read-only". It gets as far as rst.edit. I did not use the opendatabase line as the database is already open (I assume) instead I'm using Set db=CurrentDb. Dim db As DAO.Database Dim rst As DAO.Recordset...

Thanks guys it worked a treat, would never have thought of that. Anyway, now thats working I have come across another problem. I need to be able read a record and update it. I've managed to retrieve the record using OpenRecordSet(SQL) but can't update it as its read only., understandably, I...

I'm trying to use : Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.openrecordset("Tablename") etc... to add a record before anything else happens. The table I'm trying to add a...