DeltaEchoMikeIT
Last Activity: Feb 19 '19, 04:12 PM
Joined: Mar 21 '16
Location:
-
Thanks for your reply twinnyfo. I would probably go with your 'smart apostrophe' suggestion, but I'm not sure what you mean by a "smart apostrophe". In your illustration, it looks like a standard apostrophe, which appears to show no difference from how I input the data and by how the error response looks in my opening sentence. Does this mean that in all databases, an apostrophe can never be used or is this just a quirk in Access? -
Runtime error 3075 Syntax error
Hi Folks,
I keep getting the error when I select a name with an apostraphe, such as in the name "O'Connor" :
Run-time error '3075':
Syntax error (missing operator) in query expression
'([Surname-Change]='O'Connor')'.
A Debug highlights the line:
Me.LoansReserva tionsSubform.Fo rm.RecordSource = myCustomerSN
...Code:Private Sub Combo18_AfterUpdate()
-
External platforms suitable for hosting Pivot Charts with slicers
Hi everyone. I have created a pivot chart speedometer type that indicates key performance within a classroom situation. The pivot chart was created in Excel 2013. I was hoping to display the charts within a platform, such as Microsoft Office 365, Google Docs or on a VLE such as Canvas or Blackboard.
However, it would seem that none of these platforms will display pivot charts, apparently because the browsers (IE or Chrome) will not... -
OK I have solved the After Event Update issue in VBA. It was simple. Oralloy's solution to create the parameters as text fields (eg...
Works only for ordinary parameter queries with no related VBA coding. If the query is then translated into an After event update,for...Code:iif(NameChange IS NULL..."[NameChange]&")"&"... AS "Composite-Name", NameChange AS "Name-Change"Leave a comment:
-
I have another query...followi ng on from the above...
As already mentioned, where appropriate I have applied the code for the manually generated text fields (["Full-NameChange"] and ["Name-Change"]. These query the name changes to apply to fields sitting behind the forms used to enter and reserve users against loan equipment. I have applied this successfully to several forms, but there is one form with 6 comboboxes...Leave a comment:
-
Here is the exact code I used. I adjusted Oralloy's code suggestion, which really created a composite name of the original surname and the surname change. I wanted the surname change to replace the original. I used the query text fields ["Full-NameChange"] and ["Name-Change"]to query and return to a form the full name and surname changes, respectively. Here it is:
[CODE]
SELECT tbl_Person.Pers onID AS ["Identifier "],...Leave a comment:
-
Thanks for that code Oralloy. Only needed to do a couple of adjustments and then it worked like a charm.Leave a comment:
-
Help writing IF/ Else statement in Access SQL query
Good Evening All,
My query involves a database that reserves and books out loan equipment to users. When The database was originally designed it took no account of users who as the result of marriage might change their surnames. This presents some issues when those users return under a different name.
I have created a search form that allows the administrator to check their surname against their userID number, then add... -
Thanks again for your reply and patience in equal measure.
I have looked through all your points. Here's my observations against your comments italicised...
..."you may have at the table level the field property "required" set to yes or have included the field within an index with the "ignore nulls" set to no.
I learned something here. I confess I had to do some internet searches how...Leave a comment:
-
Hi, Thanks for the update, much appreciated.
In short, it seems the macro goes into an infinite loop when it reaches the message popup on the EquipmentID = "Tablet-01". Consequently when OK is selected in the message pop-up, it closes. Then when the save command is clicked, the same message pops up again.
The macro goes through the controls and cancels each event if the control has no data entered(cboUser , Dates,...Leave a comment:
-
Thankyou, code as requested...
...Code:<?xml version="1.0" encoding="UTF-16" standalone="no"?> <UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application"><UserInterfaceMacro For="Command11" Event="OnClick"><Statements><Action Collapsed="true" Name="OnError"/><ConditionalBlock><If><Condition>IsNull([cboUserSelect])</Condition><Statements><Action
Leave a comment:
-
Hi Zmbd,
Thanks for the reply, I was beginning to think that no one had any interest in the issue.
However, for all your advice, the simple OK doesn't let the save command operate either. That's why I looked for the Yes/No options.
I'm not proficient at VBA. That's why I went for the Macro options, which worked perfectly so far in providing blocks against users checking out items without selecting dates, times...Leave a comment:
-
Macro pop up reminder
I have a save button on a form that enables the database user to run command to save and reserve equipment that has been selected via a Filter box.
The macro runs behind the button to check if equipment and loan period has been selected and that a loan agreement has been signed and checked. I have added to the database some auxiliary equipment that is intended to augment a specific piece of kit. For example the administrator should be...Last edited by Rabbit; Mar 22 '16, 01:43 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: