I have recently changed the structure of my table to not allow duplicates, using a combined primary key.
So in one respect i am happy now to stop the duplication, but how can i change the error message so it is more user friendly.
Access front End - with Error Logging - but it does not log this...
Sorry did not work.
Also Tried
ConcatRelated("Invoice_Number","Temp_Aged_claims","[Temp_Aged_Claims].[Job_ID] = " & [tblQCPlannedRTMCharges].[Job_ID] & "")
And i get all the invoices combined for all jobs.
I am using The Allen Browne ConCatRelated VBA code and this has worked well for me for a number of years.
I now want to take the Concat Field and store this data in a new field. - And i am struggling to do so.
Current Code - tbInvoice = Nz(ConcatRelated("Invoice_Number"...
Appreciate if someone can have a look at the enclosed and advise.
Add new record, Select Supplier Code, add a Comment, Select charge reason on sub form, add a Qty, then approve and send to finance. Fails at ChkApproved = 1
[CODE]Private Sub btnProgress_Click()
'On Error GoTo Handler
Dim TargetFile As String
Dim MessageBody As String
Dim tolist As String
Dim cclist As String
Dim AttArray()
tbapproverlbl.Visible = True
Me!SubfrmCSRChargeDetail.Enabled = False
If MsgBox("You cannot reverse this process. Are...
Changed to Int Data type, relinked, Changed code to Me.chkApproved = 1, still getting data has been changed, and this line is highlighted.
Noted that if i come out of the form, and then go back into it - the code runs with no issues.
Morning all, on my recent form, I am getting 2 errors when running the code.
vba below -
Access front end - SQL Server back end.
Me.chkApproved = true is a tick box in Access, Bit field in SQL Server, Default value is set as "0" but shows in SQL Server as ((0)). I get the error saying that...
Ok- working though the issue - created a new form - and it works without the me.dirty code - automatically assigning the job id - so it is definately a issue with the form, but not sure where to start.
Might just be easier starting a new form from scratch.
I have the record save at that point to assign the job number to the record. The job number is a link between form and sub form.
3 images below -
Image 1 - from when it was connected to Access Back end - and it worked,
Image 2 - is when i start a new record.
Image 3 - from now i have...