Search results

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

Thanks for the clarification. I redesigned the table and have now a date field, I also have the StartTime and EndTime set to time format, I have also abandoned the idea of considering 25:15 format as 01:30 in the morning and have using the normal short time criteria As i have only a start date...

I need to track the length of a duty, some duties go beyond the midnight therefore are recorded as 24:15 for a 00:15 and 25:35 for a 01:35 the next morning as the date is referred to the start of the duty. The StartTime and EndTime fields are currently set as numbers with input mask ‘00:00;0;_’...

Thanks for helping out with the code and spotting the error in the table!!