Search results

Thanks for all

In a combo box without control source, it comprises 3 columns: id, a_name, amount. I use it to recall data from a certain table. Is it possible to fill in the combo box based on the data in a text box. Ex. When entering a name in the a_name text box, combo box should show the same...

Great! many thanks

Pat Hartman I appreciate a lot if you give me the syntax for: 1) two text 2) two numbers. Sorry for bothering you

It works, thanks alot

Sorry for disturb! I need to open a report from a current form with two where conditions; first is numeric and the second is string. DoCmd.OpenReport ("abc"), acViewPreview , , (where condition) Thanks in advance

It's almost ready. The only issue now is the last period as it could be a fraction of a month. i.e. the contract expires on 16-12-2020 for example.

Thanks a mile. I'll try it.

It should be like that, where the start date and end date will be taken from external fields Contract_id Period From To 1 1 5-1-2020 4-2-2020 1 2 5-2-2020 4-3-2020 1 3 Etc. Etc.

Thanks for your kind support. I have a table already for that

Good day! I'm working on tenancy contract project. I enter the start date and end date manually. I need a code to break down tenancy contract to periods automatically. i.e. if the contract starts on 6-12-2020 and ends on 15-5-2020, it should break them down as follows: period 1: from 5-12-2020...