Search results

yes it does ask for ItemID. The Table Item has an intermediate table 'ItemStatus' which is linked to the table 'ExaminationStatus' to create a many to many relationship. This all works fine when entering all the initial information but not when an edit is required. I just cant figure out how to...

Hi Arnel, I've tried a few things and nothing works and now I have currently run out of ideas

Hi again, Been working on this for a long time and getting more confused. I have tried so many different things but I think I now have to ask for help I'm afraid. I have an active DB which is working fine apart from this minor but important part. From the view all Items form, the user...

Once again - that was it! Thank you!!!!

Sorry i don't quite understand but i'm thinking it something to do with the sequence? I have attached a screenshot showing the form as it is after the user has created the record in the subform and after the user has selected the image. The error message comes up immediately after this

Hi again, As i don't fully understand the code below i get the above error only when i add an image to a new record i have entered in the subform as in the attachment. It fails at this line - rstMain.Edit Once i select Save and then go back in again it allows me to add the image with no...

Right, i have just come back to this and it literally was that initial link from DBguy! I simply changed DAO.Field2 to DAO.Field Amazing. Once again - so many thanks to all of you!

So did that which compiled but when run it fails at the same line and on mouse over it says 'rstAttach.Fields("FileData") = Null'

I haven't split this database

The actual name in the 'EmployeeCert" table is CertImage so i changed FileData to that and got the error 'Item not found in this collection'

Hi, Now this worked before but for some reason it is throwing the error message - Runtime Error '13' Type mismatch at this line: Set fldAttach = rstAttach.Fields("FileData") I've set breakpoints and broken it down and checked the tables and associated forms but still get the same error? Here...

Tried that and now I get the message attached. I'll take another look with the debugger

Hi and thank you. I will try that code shortly. If you open the DB with the the bypass key and open the form frmPO the error is generated from the 'Save' button after entering data into the subform

I would only keep one set once i can get it working but i really do not know what I am doing, so trying to find code and a way to do this which i will eventually. so thank you for any help and guidance. I have attached the DB and the excel spreadsheets I have to work with in case that helps

Right then here is the message I am getting

I just tried all again and its still failing at the same line? I'm going to walk away for a bit and do something else........ Back later :unsure:

Hi, the error is - "Object does not support this property or method" The StoresTemp table is only a temporary storage and is cleared after every save action

Ah! very good shout as i always do the same which i thought was fine. I'm learning all the time. Thank you

Hi, Done everything i think This - Why are you declaring/setting/using another set of Excel variables? is just because i copied some code to try and pasted it to see if i can get it working, thats all

Good morning and thank you guys. I have this for the form declarations: Option Compare Database Option Explicit Dim objExcelApp As Excel.Application Dim wb As Excel.Workbook