Search results

I'm sure this has been mentioned before but I thought it had been addressed, or we had a workaround. When importing data using SSMA that includes Boolean (Yes/No) fields, if you accepted the default mapping of Byte datatype then SSMA swapped all your lovely -1 data to +1's. Which meant that if...

I'll try and describe this as simply as possible. Take a multi-column combo box where one of the columns is a Decimal/Number field sourced directly from a table. The data type is a number type - Currency / Integer makes no odds, but it does allow nulls. In VBA you assign that value to a...

Hi All, After updating to version 2312 (Microsoft® Access® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20126) 64-bit) We have a new and nasty bug - if you check and reset a connection string using ? currentdb.TableDefs("AnyLinkedTableNameGoesHere").Connect The returned result is...

I have an interesting query involving moving vehicles around and optimising the drivers over those routes. I'm not sure this is even a sensible process to try and manipulate in Access but I thought I would ask as there are some very clever people in here :D Given the following data what would...

I have worked around this but thought I should highlight this as it's very frustrating. A SQL table (Azure SQL) has a Datetime2(7) column which when referenced from a form control in VBA come back with a TypeMismatch error (13) Even trying to debug.print the offending value fails. This is...

This is happening to a number of users but not all, which makes fixing it rather troublesome. I use the code below to return an IPv4 External IP address, so that we can automatically update an Azure SQL firewall, via some clever HTTP encryption. It's loosely based on a number of similar codes...

Recently I have had a lot of issues with opening databases not working (Various ones, almost all are Azure SQL BE). I either double click in file explorer, or right click the Access Icon that's a sticky in my Windows tool bar. The database opens, but not in a visible fashion, there is a...

I came across an interesting gotcha the other day. From a linked SQL server backend we were generating a sequence number using the Rank() Over function. This returns a BigInt data type, it appears that Access Runtime 2016 version doesn't recognise this datatype, but I can't find any official...

The Queen has died this afternoon. A sad day for the UK, even if you aren't a Royalist. https://www.bbc.co.uk/news/uk-61585886

As per this thread here https://answers.microsoft.com/en-us/msoffice/forum/all/ms-access-displays-deleted-in-every-field-for/593e5f12-3cbd-414e-841c-9df612504d3c?page=3 Originally about Oracle, we have now seen this in two Azure BE client databases in the last 2 days, making me think another...

Hi All, I suspect only @Isaac may know about this, but looking for clues. I can't get a cloud Flow process to move an email in a shared general email box. The process is triggered on new email receipt. (O365 account the It then checks it not internal. If not it calls a stored procedure to look...

Hi All, I have a file dialog I use to get the location of various files for importing (shown below). I have an issue with a client who uses file redirection at a corporate level and keeps getting an error - Error 70 Permission Denied. In my testing, if I set strInitialDir to anything that...

Hello Campers. This seems to be a repeatable bug - O365 here are the steps 1. Goto any old form and select a load of text box controls (ONLY textbox controls) 2. Copy them, right click or ctrl+c 3. Paste them. Anything happen? Not in any of my databases. Now repeat the exercise with subtle...

I've been asked to look at providing a method of monitoring a shared generic Inbox in O365. (Think of it like a service call mailbox service@yourco.com) This would be pretty straightforward in an Exchange/SQL on-site environment, but with cloud storage involved, it becomes a little more...

I think I am going mad. I am trying to extract a word in a variable-length string after a specific string. The field is imaginatively called Description. This really needs to work in a query and I'm a bit anti writing a function as it seems overkill. There is a string I can identify and find...

Hi All, I'm undecided about this so thought I'd ask the great and the good, bad and the ugly... I need to have a reference table for countries (and various other fields) and am wondering do I add a primary key ID and use that or store the ISO country number? Previously I have only ever need a...

MS are switching off UserVoice https://www.devhut.net/2021/03/10/bye-bye-uservoice/ If you read Daniel's excellent review of the stats I can see why - it's been completely ignored.

I seem to be stuck on Shades of Blue - or possibly "Shades of Blue with Green bits"? Wot's happened?

Hi All, and forgive my ignorance on all things SharePoint! We have a client who would like to store the current version of the Access FE file on share point as a central point for distribution to the end-users. This sounds really cool as we have access to this and can simply upload test...

Hi All, I have a strange problem that I sort of know the answer to but wondered if anyone had a sensible workaround; Azure SQL back end. Simple client table with a number of fields including CreationDate. CreationDate has a SQL default value of Getdate() Once a record is created you cannot...