Search results

In recent days, a colleague sent me an Access database to make some changes to, and I did, and sent it back to him. On opening it, my colleague encountered a compile error : Compile error : Can't find project or library On looking at the 'References' list (my suggestion), he saw amongst the...

The issue seems to have been resolved now, with the addition of the following on Subform2 : Private Sub Form_Current() Me.Field1.Requery End Sub Regarding linking Master & Child fields : Field1_FK on Subform2 was already linked to Field1_PK on Subform1. Reading back over my initial post...

The scenario : I have a Subform1 set within a 'Main' Form. Within Subform1, I have a control (Field1_PK) and a Subform2. On Subform2, I have a combo that takes its data from a lookup Query. Within the Query, I want to be able to limit the records to ones that have a value set to that of the...

'Tables' seemed the most appropriate section to post this in. I have an idea about storing blocks of HTML code as the Default Value in a Long Text field (for an application that'll allow me to cherry-pick blocks of code for compiling web pages). And I've been trying it out (placing the HTML...

Yes, I have the role of 'developer' in this case, and the other person is using a standalone, self-contained database in a single file. I've requested clips / screenshots of the instances where bugs are encountered.

Thanks. The database is just being used by one person. No back-end and front-end split. Not sure what to try next..

Thanks CJ_London and The_Doc_Man It seems that the same References are activated. (See the attached screenshots) . I didn't receive Location info from him. Is that (ie. Location info) worth pursuing, in itself ? To confirm : the file is a .accdb I'm really not sure I understand your guidance...

Thank you for your response, The_Doc_Man. Much appreciated....and definitely worth looking into. I've taken a look (and taken a screenshot and handwritten notes) of what References I have activated, and will ask the other chap to compare the Referneces on his side.

Hi. I hope someone can provide some helpful hints or tips as to what might be happening : A business acquaintance recently asked me to take an 'old' Access database (at least 5 or 6 years old) and make some changes to it, updating it to Access 2021. And that I did. Elements of it weren't easy...

Thanks ever so much, Pat. That worked really well with my numeric field. Josef and The_Doc_Man : thanks to you too; your suggestions have resolved some other elements I'm working on.

Thanks for your response, Josef. There's no input mask, as intField1 is Number data type. One can't set an input mask on a field of Number data type, right ?

On a continuous Form, I'd like - if possible - to be able enter two digits in intField1 and - without having to hit the Tab key, or click on txtField2, etc - to have the focus set to txtField2. Is that achievable.......in VBA or otherwise (maybe via a Validation Rule) ? I've been trying the code...

arnelgp, I've introduced your Function, and it works well. Thank you. minty, I can see how your method would work for this scenario....and many others. Thank you too. Thanks also to CJ_London.

Multiple lines of data : Yes More than one dtDeadlineDate on a line : No, just one per line Location of dtDeadlineDate & unbBusinessDay : in the 'Detail' section, in individual lines Bank holidays, etc : Don't need to take account of those. The 'working week' is Mon - Fri

In my example : dtDeadlineDate is 08-Nov-22 unbBusinessDay is to be 6

The dtDeadlineDate field is in Medium Date format. Is that what you mean ?

unbound ie. it's an unbound control

Hi. I've already been searching around for a way of doing the following, but I haven't yet been able to find it. I want to have a 'continuous' form showing various fields, including a dtDeadlineDate. Alongside the dtDeadlineDate field, I'll have a unbBusinessDay to capture the business day...

Thanks to everyone..

Yeh, I meant to say in my post : When I try to add an option simply by typing it in, it still doesn't appear in the list of options presented by the combo.