Search results

  1. AOB

    DELETE query with OUTER JOIN on sub-query (AC365)

    Hi all, Have a suspicion what I'm trying to do is simply not possible in Access (as opposed to SQL Server) but figured I'd ask before completely scrapping it. I have a table - consisting of two fields of ID's (basically a junction table) - but no formal relationships, so no foreign keys etc...
  2. AOB

    Solved VBScript to determine bitness of local MS Access version

    Hi there, I've run into some difficulties with a distributed Access DB (that is, a central ACCDB backend with distributed ACCDE frontends) The front end utilises some API's which obviously have to be declared differently in the two configurations (made pointer-safe in 64-bit) and I've...
  3. AOB

    Solved Access keeps crashing when trying to open ACCDB master file (MS Access for Microsoft 365 MSO 64-bit)

    Hi there, I've been making some modifications recently to an Access DB that's been in production for several years. Standard FE/BE split design, single BE ACCDB sitting on a network drive and distributed FE ACCDE's. I have a master copy of the FE locally and I make whatever updates are...
  4. AOB

    Solved EnumFonts across multiple Office versions (O2013 vs M365 / 32-bit vs 64-bit)

    Hi there, I have a module which I use to pull the local system font information into a local table (literally just the available font names) which I've done via EnumFonts as follows : Declare Function EnumFonts Lib "gdi32" Alias "EnumFontsA" (ByVal hDC As Long, ByVal lpsz As String, ByVal...
  5. AOB

    Continuous subform partly scrolls to the right on load / requery (AC2013)

    Hi there, I have a continuous subform residing inside a parent form. I recently added two columns to the subform and now for some reason every time I load the parent form, the subform is always partly scrolled, horizontally, to the right, by a couple of centimetres. I thought it may have been...
  6. AOB

    Question Simple select recordset suddenly not updatable (AC2013)

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

    Unbound multiline plain textbox 64k character limit (AC2013)

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

    Retaining formatted hyperlinks in a rich text textbox (AC2013)

    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)...
  9. AOB

    Delete all but most recent record per user (AC2013)

    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...
  10. AOB

    SELECT TOP 10 by group; multiple fields (AC2007)

    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)...
  11. AOB

    Insert records into one table based on distinct months in another table (AC2007)

    Hi guys, I have one table of records (table A) which contains a date/time field. I want to create a query that inserts a new record in another table (table B) for every distinct month that appears in the date/time field in table A (if it doesn't already exist in table B) I've uploaded a...
  12. AOB

    Editable recordsets with outer joins (AC2007)

    Hi there, I have a query which I use to populate a recordset (effectively, a subset of a table based on some criteria), which is then looped through and updated (can't avoid the loop - I can't update the table with SQL, it requires VBA code unfortunately) Stupidly, I forgot that if the query...
  13. AOB

    Lookup field based on parameter query (AC2007)

    Hi guys, I have a table into which a number of colleagues will be entering records manually (i.e. directly into datasheet view, not via any form interface) I have a separate, static, table which lists, among other data, users and devices (one-to-many) In the table to be updated, I...
  14. AOB

    Is it possible to query LDAP information without VBA? (AC2007)

    Hi guys, General question - title pretty much covers it; does anybody know if it's possible to query Active Directory without having to resort to VBA / ADO recordsets / looping etc.? I can pull the data via VBA no problem but that just gives me an ADO Recordset 'in memory' - I need the results...
  15. AOB

    Reply using a saved Outlook Message file (.msg) (AC2007)

    Hi guys, Anybody know if it's possible to create a reply to an e-mail if the 'source' e-mail is saved locally as a .msg file (as opposed to using a mailitem directly from an Outlook folder) Here is as far as I've gotten... Private appOutlook As Object ' Outlook Application Private...
  16. AOB

    Switching DAF's for queries (AC2007)

    Hi guys, I have a switchboard form which has a kind of dashboard element which tallies the counts of records according to a variety of pre-defined queries. At the moment I am just using domain aggregate functions to return the counts. So the Control Source for one of the textboxes in the...
  17. AOB

    Downward arrow as part of MsgBox prompt text (AC2007)

    Hi guys, Anybody know if it's possible to show a downward arrow as part of the prompt text in a message box? Or are you restricted to only the ASCII table of characters? I'm trying this : strResult = "(" & ChrW(8595) & " " & Format(dblReduction, "0.0%") & ")" MsgBox strResult...
  18. AOB

    Handling a user cancel with FollowHyperlink (AC2007)

    Hi guys, I have a continuous subform of attachments which includes a command button for the user to open/view the attachment in question. It's fairly straightforward : Private Sub comViewAttachment_Click() On Error GoTo ErrorHandler Application.FollowHyperlink...
  19. AOB

    Really odd filter behaviour (AC2007)

    Hi guys, Was investigating an issue this morning and came across some very odd behaviour when filtering a table. The table has a number of date fields but concerned with one in particular (ImportDate) When I open the table in datasheet view and filter on ImportDate (i.e. scroll down the...
  20. AOB

    MQ feeds into Access BE - is it possible? (AC2007)

    Hi guys, I need to create an Access database to house and report on some data. The data is held elsewhere and the correspondence I've had with their tech team is that they can supply the relevant data, however they would expect to send it via some form of MQ feed rather than a basic extract...
Top Bottom