Search results

Thank you MajP and arnelgp perfect, this is exactly what I need - works like a charm

Interesting MajP.....

Sorry, I probably didn't explain myself correctly. Form B is already open, so I can't use the On Load event in Form B to fire my procedure. That is why I put a button on the form, to check if the code would run and function correctly when the data had been passed from Form A

@Gasman, yes this is correct

@Gasman, The problem isn't with Form A, this performs it's intended function, the problem is that Form B needs to be open for the information to be passed from Form A and only then can the additional code be run. @theDBguy, I am not sure if a timer would work, at least, not from the point...

Hi DBguy, I used the Control wizard for a command button to open another form initially and then changed the Macro it wrote to VBA using the Access function.... DoCmd.OpenForm " Frm_B", , , "[ID] = " & Me.txtZiff.

Hi everyone, I have 2 forms: Frm_A & Frm_B. Frm_A is a small pop up which contains a combo box to allow the user to select a record to be passed to Frm_B and a command button ‘EDIT’ Frm_A and Frm_B are opened by another form at the same time with Frm_B being hidden until a command button...

@cheekybuddha & @bob fitz, thank you both for taking the time to look at this for me, I am in awe of how you guys navigate around code like you do! The code works like a dream and removes yet another hurdle in my way. It was the [Manual Type] that was tripping me up, had tried just about...

Hi @cheekybuddha, thank you for your message, to be honest, this is far above my knowledge level / skill set. I have located the Record source for the text box and tried various permutations of the code you kindly suggested, but other than syntax errors, my text box returns the same: #Name? The...

Hi All, I wonder if someone could help please? I have a simple DB with one table, one form and 2 queries. (attached). The form has a pair of cascading combo boxes. The second query returns the highest number to the second combo box. Instead of displaying / choosing this maximum value in a...

Hey Manic, Reading what you have posted, I believe (and forgive me if I am wrong) that you may have misunderstood the code posted by Arnelgp. His code is designed to be used like this: Submit a new report using the 'Add Record' button To perform a revision, select the record you want to edit...

Hey Manic, I just looked at the code posted by arnelgp and commented out the following line in the form code: ' strMaxReport = Replace(strMaxReport, intMaxNum & "", (intMaxNum + 1) & "") It seems to work how you describe and has given me some fresh ideas

Hey Manicduck, No worries, I don't mind as long as the Mods don't! Dag

Thanks All! I am still looking at the various methods offered, although I am having a couple of problems with the code for the audit trail. Still researching, but again, thanks for all of the input.

@arnelgp & @Uncle Gizmo, thank you both for your response, much appreciated I will see how I can work your suggestions into my project Stay Safe Dag

Hi all, This is my second post on the forum, and I am very much a novice. I hope that the following explanation is sufficient. I have a project where a form allows the user to record a series of events. Many of these events are chosen by cascading combo boxes, whilst others are just text input...

Thank you so much, that works a dream, now I need to do some research as to record Source, I really appreciate your assistance

Hi, First post here, so please excuse any transgressions. My skill level in Access could be described as very basic (at best)! I have used Access over the years but have always stuck to using form wizards to help me achieve the basic databases I need. However, I now find myself in need of...

Hi All, I am new to the forum and thought I would just say Hi! I live in the UK and enjoy foreign travel, although not at the moment given the current pandemic. I also enjoy photography and wildlife and try to combine all 3 hobbies wherever possible. My skill level in Access could be...