Search results

Hi Pat & Arnel, Thanks both for your help and input, on this occasion I found that Arnel's solution worked easier (I really don't know which way is best but this I found easier and more suitable for my needs). Thanks again......this forum and the people on it I have found consistently...

The example you posted works great, just wondering how.......I have 3 different types of contract, would I make a table with the different contracts in that table.....then call the .docx from that table? I had been thinking of having the contract saved on the computer but it makes sense to have...

I was initially using mergefields in word merge, but changed it to go with Pat's suggestion of using bookmarks. That said am interested to know how to do both (bookmark method and automate access for the word MergeField method)

How do I automate it in access?

Getting there, I have an error code come up 5941- The requested member of the collection does not exist. I'm going to get told off for my field names having spaces in them, but I made this a long time ago and it have developed into something much bigger than I intended, to change them now isn't...

Thanks Pat, looks ideal, I've only about 15 or so entries, the form wont change and so is straight forward to do......he says! lol. Thanks again, will have a try today and let you know how it goes

Further to this I should say that I've tried to copy and paste each page of the word document into a report then put a textbox linked to the data in the correct position, this works however the formatting doesn't resize to the correct page size.....other than writing the whole contract out I...

Hi All, I've got a 10 page contract that I currently use mail merge from Access to populate, it works fine (ish) when I'm using it, sometimes it opens up and doesn't recognize where the data source is (could be that the BE is on a server), but anyway when I'm using it its no problem as I just...

Sorry for delay....busy with the day job!! Thanks Pat, all working now, very much appreciated!!

Is there some simple code that I can use so that when I minimise a popup form it also minimise access program at the same time? I still want to use the MS access minimise button to do it so not sure how I'd add code to do this as there is effectively no button and its not onload, on exit etc..

OK cool, thanks guys

Hi All, Just wanted to know if there was a way for a popup form to remain in the background when opening other forms? Or maybe a different way to do what I want to achieve. When you open a popup form and maximise the form onload it takes up the whole screen so there is no menus or anything...

Ah OK, thanks for this, here is the SQL from qryPODetail SELECT tblPODetail.DetailID, tblPODetail.ItemDescription, tblPODetail.Quanity, tblPODetail.BudgetCode, tblPODetail.Currency, tblPODetail.Price, tblPODetail.VAT, tblPODetail.TotalPrice, tblPODetail.EDD, tblPODetail.Ordered...

Thanks Pat, have made the changes as above and renamed the control to Clone_Click() It clones the PO now and gives it a new POID but then I get an error code 91 and it doesn't copy the subform data, I have this code below but have tried a few different options but can't seem to figure it out...

Hi Pat, Having some issues.......I don't get any error messages, but it also doesn't clone the record...here is the modified code: FYI: tblPO - The primary key is POID (autonumber) tblDetail - The FK is called DetailID So it should copy the mainform details into tblPO and give a new POID...

Hi Pat, thank you so much, will try this out over the next couple of days...most likely with some more questions! lol. Thanks again and I'll keep you posted how it goes

🤪🤪🤪

On other thing....haha!! I want to be able to 'clone' an order including the line items, obviously I'll have to make an append query but how would I do this and the PODetails FK recognise the new Primary Key for the new PO?

Yes I removed this as well, all working good now, thanks again.

HI Pat, thanks for this. It was getting very messy so deleted them and started again from scratch taking into account everything said. I now have it working properly, the FK is automatically done because the parent/child relationship is correctly setup, RI is enforced and all is good, thank you.