Search results

  1. Minty

    New Access / SQL backend bug - #Deleted showing in Tables

    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...
  2. Minty

    Flow - Email Moving problem

    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...
  3. Minty

    File Dialog Permission denied error on redirected folders

    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...
  4. Minty

    Bug? Access Form design - Copy and paste textbox controls not working

    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...
  5. Minty

    Outlook Monitoring with O365

    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...
  6. Minty

    Solved Nested Instr() Issues

    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...
  7. Minty

    Countries Table - Design Thoughts

    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...
  8. Minty

    User Voice will be leaving the Building!

    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.
  9. Minty

    Shades of Grey Disappeared ?

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

    SharePoint storage for FE database problem

    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...
  11. Minty

    Strange Un-editable Record with SQL Azure BE

    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...
  12. Minty

    When switching to design view All other open forms CLOSE?

    I've never seen this behaviour before. I have a set of hierarchal forms that are opened in a chain, as you dig into the data. Forms are overlapping design not tabbed. frmMainClient¬frmClientChildData¬frmSubChildDataDetails So from the client form, you select a child item from a list and it...
  13. Minty

    Tab Control and Events - Total confusion

    Hi All, I've been battling with a conundrum for a while on and off, and am going to admit defeat, at least for now. I have a Main form that has two subforms on it. Form one on the left side is a list based continuous form, that drives the data available on SubForm 2. All very straight forward...
  14. Minty

    Weird Conditional Formatting Error

    Hi All, I've been struggling with this for a few hours and Mr Google hasn't helped so... I have a continuous subform that has CF applied to it to highlight certain rows. On the subform header I have a button to apply a sort on one column done in VBA. Clicking on it a second time reverses the...
  15. Minty

    The Slightly Obscure Music Discussion And Quizzy Thread

    As discussed in a previous Off Topic Thread I have started this as a place to discuss all things vaguely related to Music & Lyrics, and a quiz just for good measure. I need to start with a picture quiz so here goes - An easy peasy one to get things going. Lyrics and song please.
  16. Minty

    SQL Pass through query returning numbers as strings woes

    Evening all - I have a passthrough query that is generating a dynamic Pivot result. It has to be dynamic as the number and names of customers are fluid. The problem is that Access thinks the values are text. They are definitely cast as Decimal in SQL (Azure) but if I use the pass-through...
  17. Minty

    Solved Power Query Automation from Access

    Has anybody done any automation in Excel from Access using Power Query? I have a need to generate a load of transposed data as a final report output, and Power Query can do it easily. There isn't a great deal on the web about this or I'm having a bad Google day. The only slightly salient...
  18. Minty

    Access SQL Query -> T-SQL Query Conversion ?

    Hi All, Before I reinvent the wheel, has anyone written a text convertor that would take most of the pain out of moving a massive bunch of Access queries (25 databases with probably at least 500 queries!) into MS SQL Server T-Sql ? I use Textpad and think I can create a dictionary and macro's...
  19. Minty

    Site Down intermittently?

    I couldn't connect for 4-5 hours yesterday, and again this morning for an hour or so ? Yesterday it appeared it wasn't just me, anyone else having issues today? :confused:
  20. Minty

    Build Criteria Function

    Is it just me or has this function completely passed me by? https://docs.microsoft.com/en-us/office/vba/api/access.application.buildcriteria I have never seen or even heard of it's use until I saw this thread...
Top Bottom