• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Search results

  1. bob fitz

    Solved Disable Red Cross Puzzle

    Please forgive me if I'm just having a "Senior Moment". They seem to be getting more frequent with every passing day :rolleyes: Some years ago I found/copied/wrote some code to disable the use of the Red Cross in an app, forcing users to use a Quit button on a form. Naturally, I can't find...
  2. bob fitz

    Confirm Print

    If you have a button on a form which sends a report to the printer, is there any way to establish whether or not the printer worked correctly.
  3. bob fitz

    Undefined function 'Nz' in expression

    Can anybody explain why I get the error message in this thread title when I try to open query1 of the attached db. The SQL for this query is:SELECT Table1.ID, Nz([Num],0) AS n, Table1.txt FROM Table1; DB attached Thanks in advance
  4. bob fitz

    NotInList Problem

    Can someone please look at this and tell me what I'm doing wrong. The code adds the NewData to the table but I get a message which tells me, "The text you entered isn't an item in the list" Private Sub cboCusFilter_NotInList(NewData As String, Response As Integer) Dim rec As Recordset If...
  5. bob fitz

    Thoughts and comments on this set up

    MySQL backend residing on Azure. Single Access frontend on MS OneDrive which will be shared by five or six users. Two or three of these users will be away from the main office and using the shared front end on laptops. Would be interested to hear any thoughts or advice on this setup.
  6. bob fitz

    Anybody used Access app with "Remote Access" software like Team Viewer

    Hi folks Has anybody used an Access app with "Remote Access" software like "Team Viewer" or "Go To My PC" and if so, what was the experience like? Thanks for taking an interest in this post. Bob
  7. bob fitz

    Run App on a Data Stick?

    Just wondering if anyone has tried using an access app on a data stick. Any one have any pros and cons or opinions on its success.
  8. bob fitz

    Error with DoCmd.RunSavedImportExport

    Using Access 2016 DoCmd.RunSavedImportExport "UpdateCo" Anybody know why this line of code would cause the following error: Run-time error '31602': The specification with the specified index does not exist. Specify a different index. 'UpdateCo'.
  9. bob fitz

    Import data from excel.xlsx

    Is it possible to import data from an Excel.xlsx file into Access 2013 if you don't have Excel application installed.
  10. bob fitz

    Question Missing Tread

    Can anyone tell me what has happened to a thread that I was following about a week ago. It has disappeared. The OP was called Loup. The following link is one that I have copied from another forum where I had informed members that the question had been cross-posted...
  11. bob fitz

    Is this a site fault?

    Why can't I upload a db file now. Have never had any problems before:banghead:
  12. bob fitz

    Is it possible to open an A2013 file using A2007 runtime?

    Is it possible to open an A2013 file using A2007 runtime?
  13. bob fitz

    Re-Install Access 2013

    Can anyone tell me where I can download Access 2013 from.
  14. bob fitz

    Error 2485 Microsoft Access cannot find the object 'Custom rpt'

    I keep getting the following problem. The following lines cause the error: stDocName = "rptSales" DoCmd.OpenReport stDocName, acPreview, , strWhere I don't have an object in the db called 'Custom rpt' or a reference to it in any of my code. Any ideas on what might be wrong?
  15. bob fitz

    Form Appearance

    I have recently switched from using A2003 to A2013. Can anybody please tell me which property/setting in A2013 needs to be changed to affect the two different appearances of a form, as shown in the attach file. I must have changed something but I have no idea what :confused: EDIT: Have...
  16. bob fitz

    Error 2485

    I am trying to use the following code to open a report in preview but I get the following error message: The error occurs at line 30. I do not have a report called "Custom rpt" that is mentioned in the error message. Private Sub cmdRpt_Click() 10 On Error GoTo Err_cmdRpt_Click...
  17. bob fitz

    Sending emails from access

    Hi guys, I made a db for a client some years ago in A2000 who wants me to add some new features. In the old db I had a report that created statements of account for each of his customers which he printed out and sent by post. He would now like to send these by email. Can anyone give some...
  18. bob fitz

    References Problem?

    For many years I have been developing apps with A2003. I have now installed A2013. When I open a db now with A2003 I get an error whenever I try to run some code. The error message says, “The expression On Click you entered as the event property setting produced the following error: ‘Object...
  19. bob fitz

    Question No Thanks?

    What's happened to the count of "Thanks" given and received.
  20. bob fitz

    Re: Sample Date Functions

    Re: Sample Date Functions --- In reference to… http://www.access-programmers.co.uk/forums/showthread.php?t=238821 --- Hi Pat Would it be possible to post a version in A2003 mdb format please?
Top Bottom