Search results

Think i have sort of sorted it - when changing the code to look at todays date it works. So for some reason does not like the TbChargeDate field. Me.tbRate = Nz(DLookup("Unit_Cost", "TblQCPreRetailSuppliers", "Supp_Code='" & Forms!FrmPreRetailJobs!CboxSupplier & "' AND DATE() BETWEEN...

This gives me a strange error - when i debug i get the below. ? Format(Forms!FrmPreRetailcharges.tbChargeDate, "#mm/dd/yyyy#") 4540mm/dd/yyyy7 Not sure if it matters but the back end is stored in SQL Sever, and data type is DateTime.

Trying to get my head around this VBA - This code currently works - but i need to introduce a new charge in my table starting from 01-07-2024 - So i need to change this code to look for the StartDate and The EndDate. Initial Code Me.tbRate = Nz(DLookup("Unit_Cost", "TblQCPreRetailSuppliers"...

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

I know this thread is old, but I get the same error when running the code - but it works ok if i step through the code using F8.

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

Thanks. What code should I remove from sub form that is unnecessary

Rem out this attempt save code did not resolve the issue.

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

DoCmd.RunCommand acCmdSaveRecord

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

NO Nulls, just True and False. Thanks for the advise on Integer Field - will look at this next.

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

Yes - When editing table directly I only need to input 1 field and it saves. Error is on the Me.dirty = false Record is not saved

Run time error 3022 - when the me.dirty = false code is trying to run. Table in background is set to allow Nulls apart from the Primary Key Job_Id is the identity specification, set to increment by 1. The BIT Field is set to Default 0. The code runs after TbReference has been updated...

Graduarly moving my tables into SQL Server. Each day at 19:00 i run a update query that copies 4 fields from a read only database, to a archive table (So i never loose the data) the read only database has approx 400,000 records, so daily i run a update query to store the data for any jobs that...