Search results

  1. B

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

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

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

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

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

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

    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'.
  8. B

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

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

    Is this a site fault?

    Why can't I upload a db file now. Have never had any problems before:banghead:
  11. B

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

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

    Re-Install Access 2013

    Can anyone tell me where I can download Access 2013 from.
  13. B

    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?
  14. B

    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...
  15. B

    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...
  16. B

    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...
  17. B

    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...
  18. B

    Question No Thanks?

    What's happened to the count of "Thanks" given and received.
  19. B

    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?
  20. B

    How to mark a thread as solved

    How does one mark a thread as "Solved" and what has happened to the "Thanks" button? or am I getting confused with another forum.:confused:
Top Bottom