Search results

Thanks for all your help on this one :) I'm now a happy bunny - changing the references via the module's tool menu worked a treat. And of course I could of used an update query - I've done that before - doh! Thanks once again

I didn't write the code - It just lives in the Contacts Database example that comes with Access - It must be ADO where rs.edit doesn't exist because if you try to retype this it only comes up with rs.editmode - but none of us here know what we can replace this with to get it to run or even if...

No I haven't changed any of the field names and yes printflag still exists (its a check box)

Can someone help me on this one - I have a database that was set up using the contacts database wizard - One useful feature I'd like to keep is just not working - it did in the begininng - but since adding my own stuff to it its not working anymore! This piece of code falls over at rs.edit -...

Thanks! Thank you both for your help! You are right Pat - can't believe I missed that one! Anyway it's all working fine now. Thanks once again to this forum! :D

I have an Append query that is triggered through a macro when you exit a field on a subform. Trouble is that it just doesn't run when you first enter the data. To get it to run, I have to leave the row and then overtype what I did! Anyone got any ideas as to why - I've tried it on After...

I Gave up with that one After plodding on through the night - I couldn't get that code to work at all. So I gave up and now am using code from another post on this forum. Which works great I'm pleased to say. I am now considering using my Developer's handbook as a doorstop!! I still have a...

OK I sussed that one - I don't know what the problem was but I retyped the first part of the code and it now works up to the next point where you supply it with information to be used in the documents bookmarks. And then it falls over saying that the "object is required" The bookmarks are in...

Thank you - I've been having a look round the other posts and I'd just got there with the path thing but I've now got this problem... It says that my template does not exist! It flipping well does - I can see it! I even copied the name from the Word file to make sure I wasn't spelling it...

Many thanks - that got over that hurdle... Now I can't fathom out how to put the document path in... The example in the book isn't exactly helpful. Here is what is written at present: objWord.Documents.Add _ Application.CurrentProject.Path & "\FactPackLetter.dot" I've left it the same...

I have lifted out of the Access Developers Handbook the code for opening a Word document and entering data from the db into it. However it falls down on this first line!!!!! Dim ObjWord As Word.Application I get a compile error: User-defined type not defined with the words ObjWord As...

Thanks Thanks for your help! Searching works better if you know what you're searching for!

I have a query which summarises the totals on a receipt. Put simply it looks up each entry for the ReceiptID and outputs to one line the sums I have asked it to do using the Group By method - which for me is quite an achievement! Taking it one step on, is this possible... On each receipt the...

Thanks for your help Len. I will follow your thinking and see if I can get it to work. I may be back.... Thanks once again

In answer to Rich - sold stock is true when sold to the general public - we use the shrinkage field to reduce the plain stock item that is going to the printers it then takes on the printed stock item product ID and becomes sold when its sold - if we didn't use the shrinkage field we'd be...

Ok - I've been up half the night thinking and I've come up with this. If I have a field in my Products table called Base Stock ID for me to put the plain stock ID number against the printed stock item. Could I then attach code to the # Ordered field in the transaction sub form on my purchase...

Yes the db will need restructuring - all my products are currently in one table and all their transactions in another - so I know I'll have to split them from each other. I'm just struggling to get my head round how to do the take it from one and adding it to another bit. Also when doing...

I have a db based on the original Inventory control template. I've modified it to do all most all that I need thanks to reading many of the posts on this website. I have stock products that are all contained in the Products table. All the transactions are recorded in the Inventory...