Search results

Thanks for this!!

I need to concatenate "FirstName" and "Surname" from a table with a lookup on a form, I am stuck on how to use concatenate in the code. The code I have under the afterUpdate event for the textbox RefStaffN is: Me.FullName = DLookup("FirstName", "tblEmployee", "StaffN=" & Me!RefStaffN) This is...

@Gasman How would In go to have the DCount in the Current event as you suggest?

Thanks for the help this has taken care of the issue!! Yes I do give proper names, is just I am working on a dummy DB once I am satisfied I just apply all to the proper DB, I have learned from my own errors and this was one!

Thanks I got the DCount expression to work with the suggestion. I have the dblClick event on the icon working correclty and opening the frmSwaps to the relevant record. I am trying to make the icon visible when the DCount finds a match and returns the value 1. I used the after update event...

@Gasman I added a txt box in the frmDuties and used: =DCount("[IDDuty]","[tblSwaps]","[DutyDateNew] = #" & Format([Me]![DutyDate].[Value],"mm/dd/yyyy") & "#") But not getting anywhere

I am trying to keep track of duties that have been exchanged for other duties via a tblSwaps and a relative form which will have information about the old duty. The main reference is DutyDateNew within the tblSwaps, which will be a match as same date in the tblDuties The main frmDuties has an...

ahahah I am sure there will be a few here reading my post happy to load that gun and wait for me to fall over my logic :ROFLMAO: Now I have no clue how an update query is achieved to update one record......🤯

@arnelgp thanks for the help, just learned something new with refreshing forms! The solutions works perfectly! Now to add the cherry to the cake I would really like to have the total value copied to the tblDuties, I understand this is against the logic of programmers and you may cringe with...

Hi @June7 I have very limited knowledge of access and DB and have built this with the help from the community and every suggestion is greatly appreciated. The huge form is because I deleted some fields to upload a smaller file onto this site. Just to give an insight of the DB for every daily...

Thanks @arnelgp for the solution, is there a way to have the immediate response on the form, I noticed that the result does not appear when you add the record but only when you have closed the form and reopen it. How do I go for a more prompt visual information on the main form frmDuties whilst...

Hi @Pat Hartman @June7 I am a novel with access so I may need some more direction on this, the values on sfrmRun once entered they do not change at all so I would believe they are static (if this is the meaning of static). What is the best approach, and how do I go with the INSERT query?

I am slowly getting to the bottom of my project but have hit a further rock! I am trying to get the total of the field RIDOCR/RIDITSOR/RIDCPCR from the frmRuns into the relative fields on the frmDuties and copy that value in the table so that I can use it for statistic purposes later on. In...

@arnelgp @theDBguy was not aware of this, thanks for this info. Will look at alternative design on the form

@theDBguy thanks for looking into it, I don;t seem to see how you adjusted the error? Am I missing something? Thanks again

@theDBguy I attached an extracted version of it

@theDBguy I tried your suggestion now the erros if set to the focus

@theDBguy Thanks for the reply. I have tried your suggestion but I am still getting the same error

I have a main form with a Add command to add a new record and an edit command. The form has a subform which consequently has a further subform itself with a One to Many relation, all forms and subform are set no additions and no edits in the properties. So I wrote the code to allow additions...

Thanks all for your inputs. I found a way round it maintaining only 1 date, start and end time field, It may be a bit tedious but serves the purpose. I reverted back to the standard hour format as the duty latest finish time is 04:00 the following day I used an if statement to add 1 day to an...