Search results

Hi everyone, im hoping this is an easy question to answer. I found some code online for add or subtracting working days and excluding holidays utilizing a table to list the bank holidays etc. the function seems to be switching the dd/mm if its possible, i have a holiday date 10/04/2020...

Hi Pat, Thankyou for the reply, thats really helpful. I'll probably look at my existing functions and see about editing them and calling them from the beforeupdate like you said. Thanks for everybody elses replies as well i should have joined this forum a long time ago Thanks again

Hi Pat, it is genuinely a split form, as in an actual access split form, I set the fields in the individual half to Not visible and lay the subform over the top At the time it was the only way i could think of having a datasheet view whilst still being able to specify the selected record for...

Beyond me im afraid😅

the only other thing i can add is the form works absolutely fine with adding new records to the subform. If the parent record is selected without being edited. OR if it has been edited. Then select another parent form record and then select your original record That is the "saving/finshing the...

Sorry it probably sounds stupid but i dont know what you mean. I've always just used the macro's for new records etc and i only converted it to vba to see if there was a way of fixing this problem. All of my vba knowledge is literally from googling and paste and changing things until it works...

I have tried setting the focus to specific controls on the subform sadly without working. to the best or my knowledge i believe i just tried setting the focus to just the subform but sadly no. I have just realised that this is occurring if the parent record is in the progress of being changed...

Sure, i just used the "Convert Macro to VBA" function (again apologies for lack of naming the control). The button is within the subform Private Sub Command70_Click() On Error GoTo Command70_Click_Err On Error Resume Next DoCmd.GoToRecord , "", acNewRec If (MacroError <> 0) Then...

Thanks, This is the form: Top half = parent form bottom half = subform parent/child is" "ID" & "StockID" if the record is selected and the"New Stock Move" button is clicked it will create a new stock move Which is fine.. but if a field is being edited and has not been moved away from...

Sure, I am using a splitform with subforms, I dont know the terminology but i can tell that because the user has not yet moved onto the next field from the parent form that the field is still in a state of "not fully updated" so when the subforms new record button is clicked that parent...

Im not entirely sure how to do that, and i may potentially die from embarrassment if anyone with genuine access/DB knowledge saw my Frankenstein of a database I can have a look at stripping a copy back for people to see...

Hi everyone, Im hoping someone can help with this. I have a Splitform"Stocktable" and it has a subform "StockMove" (The splitform only displays the datasheet half and the individual fields are hidden) A user will select a line/record in the Datasheet and relating stock moves appear in the...

I agree as well, sadly i have filled my DB with badly named objects and yes its a major pain sometimes Thanks for the all replies :D

HI, that solution works perfectly. Thanks very much

Hi there, I have several forms (sales order, purchase order, invoice) that all use one "notes" form. When i click a button on the origin form it opens the "notes" form and populates the "Tbl_Note_Parent_Ref" field with the reference from the origin form but.. if the origin ref ([crm-1-ref]) is...

Hi everyone, Im jordon. I've been working on Access for about 5 years now but i've never learnt any VBA etc, i've just googled to find solutions to get things to work. Anyway im starting to focus more on the VBA aspect on my database but it is difficult as i cant write any code without having to...