Search results

Thank you. I haven't tried importing to Sharepoint from Excel, but that's worth a try.

I had a quick test of this by exporting a couple of tables as lists, where Opportunity had a field ContactID (secondary key from Contacts table). If relationships have been deleted from within Access before export, the option to make a Lookup field is not available, apparently. It is possible...

Apologies, but I don't understand this reply. I have relationships within my existing database, for example Organisation > Department > Contact > Opportunity > Quote. If I export from Access to Sharepoint, some, but not all of the tables are being created as lists in SP. Those that are...

Thanks both. SQL server may be possible for us, however in the short term I'd like to see if I can make this work. Regarding the number of records - my current largest table has around 1100 records. It's a customer/quotation type database and is unlikely to reach 20k for one table in the near...

Thanks for the quick reply and the link. I assume the relationships are reestablished within Access?

Thanks both for your replies. Minty - I will take a look through those related threads. Nautical Gent - as I'm just starting down this route I'm not sure what other issues I'm going to encounter. However, it is troubling me that I'm duplicating data within Sharepoint. As far as I can see...

Hello all, I have a split database, the back end of which I'd like to have sitting on Sharepoint, so as to be accessible to two users remotely. I've managed to export Sharepoint lists from my Database but I have hit a snag. Access seems to only create sharepoint lists for a subset of all...

Appreciated. I merely want to use it a means of capturing a snapshot - so the ID fields (for example) would be a foreign key in the destination table.

That looks logical. So I assume that I could substitute the code you have: .txtSubjectF2 = me.txtSubjectF1 .txtMessageF2 = me.txtMessageF1 with ContactID/OrderID or whatever I wanted to pass?

Hi again, Thanks for taking the time to respond again. Apologies if I wasn't clear enough in my original question - I am a new access user so I really want to understand the underlying methodology for passing data between tables. Let me try to explain the thinking behind what I want my...

That's a very kind offer. I will see if I can do that tomorrow morning.

Hi, Thanks once again. Is the OpenArgs method suitable for use where I wish to pass more than one piece of data to the new table? Best wishes, Pete

Thank you once again for taking the time to reply - I'll take a look through the links you've shared and report back with any further questions. Have a good weekend. Pete

Many thanks for your quick response. To clarify what I'm trying to do, I think I need to give a bit more info. The subform is to give me an overview of the opportunities raised by a contact, so as such does not contain all the fields within the opportunity table - I've put control buttons...

Hi, Sorry, yes I mean subform - that's a bit of a red herring though - essentially I just want understand how I can select a contact from one table and using a button control, copy that contactID through to a new form (opportunity). The tables are linked already via contactID in the database...

Hi, I'm afraid it contains confidential information, so I'm unable to do that. Pete

Hi all, I know lots of people have had similar questions, but I've been unable to find a solution that works in my instance, so please be gentle! I'm developing a database in Access 2016. I have a form called frmContacts, which contains contact info (plus a sub-table with a snapshot view of...