Search results for query: *

Hi TheAceMan! The Code was on the subform form itself (Not on any buttons fields etc). MajP I created the form using the wizard, but then went on to alter the links manually in terms of the join types ( could this have been put in during the wizard use, but hen become redundant when I set the...

Hi all Thanks for the suggestion TheAceMan1, I will try that in a little while, have only just seen it. Though I think I have found the problem, but don't quite understand. The first part of the subform code above (copied below) seems to be causing the problem and if I remove it all seems to...

Ok thanks for having a look and the book reference. It is a lot more money here in the UK, but if it contains good info then ok. I hate these books that promise the earth and tell you how to make a picture move, so thanks for the recommendation. I suspect what I'm trying to do is simple and...

Thanks MajP The form and subform are based directly on Linked tables not a table as a result of a query or directly on a query itself. The Master table holds all the possible parts that any depot may have or get access to from another depot. Each depot ( on subform) can see the location (shelf)...

Thanks for you help MajP I'm not running a query, or at least I don't think I am. I am running the code for the find command ( the same as if you use the binocular icon). The only other thing is I have a filter, filtering on the OwnerDepot field (on the subform). I'm running this on access...

Not sure if this is what was requested, but here goes.( Please note i'm quite a newbee at Access & VB, I have used and programmed in Paradox in the past) Option Compare Database Sub Form_Current() Dim ParentDocName As String On Error Resume Next ParentDocName = Me.Parent.Name...

How do I attach the code ? there is a little icon that looks like a paper scroll with greater and less than signs on it, should I just paste into that ? I had some problems just submitting the post yesterday, first I didn't have a subject ( so fair enough) but after I would press it an nothing...

Hi all I’m looking for help again, I thought I had solved a problem but have not. I have three database tables. One with part numbers description make etc in it and another with part number, location, depot and quantity in it, the third will allow booking in and out. This is in Access 2002 and...

Thanks for the information both. When I tried to change the Field / control ( or whatever Microsoft wants to call it) it kept telling me I could not as it did not have focus. I sort of thought that you had to daisy chain from one field to the next changing things as you went, which seemed...

Please can someone help, I’m new to writing VBA code and got myself stuck. I have to use Access 2002 VBA. I’m trying to move focus from one field to another, then another on a record in a subform, that is in datasheet format. I have a record (row of info) in a subform that has the field...