Search results

Indeed - I would have thought opening exclusively was a very specific process rather than anything that could happen accidentally? A front end .accde couldn't open the backend exclusively "by accident" could it? Unless it was designed / coded to do so (it's not) I also hide the backend (as...

Just to confirm - backend was indeed the source of the problem Restoring the last backup has rectified it Can only guess that one of the local front ends forced a permanent record lock on one or more tables that was immutable - to be honest, I've never experienced that before, nor can I see...

Hi CJ, Correct, it's a standard split DB, everybody has their own local copy of the front end and a single production backend on the server It seems to be the backend that's corrupt Thanks AOB

Thanks again Colin The SQL is correct (as it has always worked) The issue seems to be the production backend - I switched in a backup and the recordsets are all updatable so there must be some corruption issue in the live version. If there is, it's not immediately obvious as there are no...

Thanks Colin, It's not a saved query, it's generated at run-time - but very vanilla and has ever been an issue before : Dim dbs As Database Dim rst As Recordset Dim strSQL As String Set dbs = CurrentDb With dbs strSQL = "SELECT [tblTable].* " & _ "FROM [tblTable] " & _...

Hi there, I have an Access DB which has been in production for several years. This morning, users reported issues loading it up and running any of the functionality. It appears that recordsets which were previously used for data manipulation, are no longer updatable (??) These recordsets abide...

That escalated quickly... :D So I got around the problem by replacing my single plain textbox with a handful of other controls. First I added three local tables; one which stores all the "valid" codes, one which holds any duplicates of the valid codes (and the count of the dupes) and a third...

Yup, it is, but the process splits it down to its constituent parts - it's actually a giant delimited string of 7-character codes (it's not one single record of 64k+ characters, it's more like 7k sets of 7-character codes, which when you factor in line breaks, carriage returns and rogue...

Hi experts! I have an unbound multiline plain textbox in a form, into which users can enter text (or, paste text, usually from a column in an Excel spreadsheet, or from an email etc.) which is then taken as in input into a process I've just discovered that users can't enter, or paste, more...

Perhaps I'm looking at the wrong control - when I insert a Web Browser Control from the Design ribbon, I'm immediately prompted to specify the address of the webpage to which the control should link? It doesn't appear to be something the user could edit themselves as a raw HTML editor? Am I...

From what I can see, a Web Browser control is a static link to a specified address which then displays the target of that address in a control object on the form. That's not what I'm trying to achieve. The contents of this textbox will eventually be transformed into an HTML email message. The...

Here is a severely stripped down version of what I'm seeing (apologies for any clumsiness in the code, this is just a fast and dirty example of the problem rather than anything polished that I'd actually put my name to!) Three textboxes - on the left, the user input textbox (where a template...

Yes The problem is definitely in the textbox / form rather than the database - there are no issues storing the value in the field, I can read and write the HTML with zero issues, so I don't see much point in changing the properties of the field in the table. And I can't change the properties of...

Hi, Not sure if what I'm trying to do is simply outside the bounds of what Access 2013 can provide or if I'm just missing something stupid but hoping somebody can help... I have a user form which acts as a method for users to create saved templates for emails. The form has a textbox (unbound)...

Thanks guys I'd prefer to just remove the redundant records entirely but I guess this will work for me adapted to SELECT UserID, Max(LoginTimeStamp) AS MostRecentLogin FROM tblMyTable GROUP BY UserID;

It's not a one-off operation; I'm building the Access database as a quick tool for some folks to run some reporting on an ongoing basis. These reports will be refreshed / regenerated on a weekly basis. I don't want them to have to do anything manually, just click a button on a form and have the...

A fair point, Mark, and duly noted, however let me explain... The Access database I'm building is for reporting purposes. This is only a temporary copy. The main table (elsewhere) remains unchanged. Once the local table has been populated, there are a series of queries which need to be...

Hi guys, I have a table of records, multiple fields but key fields here are a UserID (Text) and a Login timestamp (Date/Time). A UserID may appear across multiple records (different devices). I want to run a delete query that deletes all but the most recent record for each distinct UserID...

Took some adaptation but that works perfectly! Thanks very very much jdraw!

Hi guys, I have a query which retrieves a summation of fees grouped by two fields (business and client) : SELECT IIf(qF.Business Is Null,"Unknown",qF.Business) AS Business, qF.Client AS Client, Sum(qF.Fee) AS SumOfFees FROM qryFees AS qF GROUP BY IIf(qF.Business Is Null,"Unknown",qF.Business)...