Search results

So it's definitely SharePoint list related. As a test I converted to a local table and the function works as described.

Ok, now I'm getting frustrated. Everything I've read suggests the solution you've given is sound and should work but it's still giving the lock violation on the last clicked text box. I've even gone as far as to set every single form/subform as dirty and same issue. If I fully close the form...

I don't think I have explained this very well. A picture might be better. My tickbox is part of the table being shown via the subform. I want to be able to use the tickbox to select multiple records, press the assign button and those records which have a tick against them are modified using the...

Ok, now my button click has the following code. If Me.Dirty Then Dirty = False DoCmd.OpenQuery "AssignToMeUpdate" It gives the same lock violation. I don't quite understand the dirty property, would I not have to check the dirty status of the subform rather than the main or does the main...

Please bear with me while I try and explain this... My tables are linked sharepoint lists. I have a form with 2 subforms showing in datasheet view. They each show data from the same table (Exceptions) with slightly differing criteria. I have a column in each table that is a tickbox which is...

Thanks Mark_. This is what I've done as I couldn't get any VBA commands to reconnect/link tables to work. Import to a local table. Use an append query to add to sharepoint list and then a delete query to empty the local table.

Thanks MajP. I'll have a look into this.

We're using Office 365 which I think is equivalent to 2016?

Thanks The_Doc_Man. I have been 'googling' for a few days to try and find a solution. I've seen the same or similar question asked a few times without a real answer. Was just hoping asking might refresh peoples memory or catch someone as SharePoint lists don't seem to be that popular or well used.

Hi, I have a small database working fine from a fileshare but have been asked to migrate this to SharePoint. I've uploaded my tables to SharePoint lists without many problems. If I append single records from my dataset they synchronise fine. I have a button to import multiple lines from an...

Ok, so I've gone with another simple and unsexy solution. I've created a new field that concatenantes the company and date fields and set that as requiring unique values in the SharePoint list. That will have to do for now as many of the other options are over my head.

I'm not sure SharePoint lists allow specified unique keys either. I'll do some research.

I have an access database that has a button to import data from an specific excel document into a table. The table had Name, and Date as primary keys. When importing the doc this obviously stops duplicate name/date entries from being added. This is probably a really bad way of doing it but was...

Thanks isladogs. Appreciate the help. I'll read through all the changes you've made and find some reading materials to familiarise myself as to why.

Latest DB attached. From switchboard click Perform Password Check button. This opens the form 'Checks'. Ignore everything other than the 3 combos at the top. TeamID shows a list of all TeamName from Teams table. CustomerID is filtered depening on the entry in TeamID. AccountTypeID should in...

Thanks arnelgp and isladogs for your help so far. I've done a bit of reading in the last 48 hours and 'fixed' some mistakes I made building my tables. I'm now using proper foreign keys and don't have any lookups in my tables. Tables: AccountType - ID, AccountType Customer - ID, CustomerName...

I'm really appreciative of all the help being provided. Ok, so I've really screwed something up here. I'd initially used lookups on tables but read that's not a sensible way of doing things so have removed those and used just the form combos to handle the entries. I've also amended 2 input...

Thanks Arnel, I think the End If at the end was meant to be End Function? The AccountType combo is still blank though. I'll upload a copy of the DB. EDIT: Arnels code is giving a value but it isn't visible in the combo box. When I check the datasheet view of the table the form is servicing...

Thanks Isladogs, I'll have a play for the rest of the day and upload the db tomorrow if needed.

I get a compile error: End If without block If