Search results

Hi, can someone help me with this please? The first form of my database is a continues form based on a qry. The list contains about 400 records (frmFirst). When I select a record to work on I click on the selector and all details of that record show up (frmBook). When I close frmBook frmFirst...

Changed the save method to the proper one and have puttered around a bit some more with the rest of the code. No luck though. I'm spending way to much time on this so I've left it for later and made that button invisible for the moment. Will try again later to optimise the DB.

Thanks for that.

Would be nice if you showed us how you've solved it. Others (like me) might learn from it.

I'm trying to close a form (frmIN) that shows details of selected correspondence about a project and go back to the main form (frmMain) of that particular project. I'm using the code below that doesn't work properly. I get error message '2501 - OpenForm action was cancelled' Anyone any...

The comments given made me understand that I needed to have another good look at what this example actually does and I'm happy to say that I now got it to work! Very pleased with this option. Thanks all for the pointers. Walter

I will do so again. Have other pressing matters at the moment but will have time later today or tomorrow to do so. If I cannot get any further with it I'll gladly post the DB on Monday or so. No, I'm not saving the record automatically. Will do that. My form does have the text box. I have...

Nobody around that is able to give me advice on this?

Hi, I need to link lot's of files (mostly pdf and word, sometimes tiff or jpg) to records in my database. The example posted on this forum by GHudson (http://www.access-programmers.co.uk/forums/showthread.php?t=97787) looks great to me but I cannot get it 'transplanted' to my DB so I'm looking...

GOT IT! The mistake was that I referred to the open frmMain first to save it and not directly to frmIN. Don't understand why that was a mistake but since I've changed it the button acts as I want it to. Code is now as follows: Dim StrMsg As String Dim intRespons As Integer Dim...

Tried your suggestion (and several variations on it) but no good result. Still error messages No, the ProjectID field is a number field. Initially ProjectID is generated as an autonumber on the form in which new projects are entered. I don't get it. I've used this code before in another...

Thanks RG, your editing has made some difference but it's not doing all it is supposed to do. I get an error on .projectID line in: With Forms!frmIN .WorkingTitle = Me.WorkingTitle .SFNumber = Me.SFNumber .ProjectID = Me.ProjectID End With If I take that line out the frmIN opens nicely except...

Hi all, I have a frm (frmmain) that holds a subfrm (subControlIN_table) in wich incoming messages (correspondence about projects) are stored. To retrieve a message I click on the record selector and a new form (frmIN) opens that displays the message and further details. This works fine. A...