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...
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
Thanks in advance
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
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.
Using Access 2016
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'.
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...
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?
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:
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...
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...
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...