Search results

Thank you for your help and sorry for the delay in getting back to you. I have looked through several threads and have found a "partial" solution to my problem. My form (frmMenu) has now an unbound list box (lstStudy) and 7 combo boxes used to populate and filter the list box as used as...

Hello, I have a form with a list box that gets populated according to the selection made in dynamic combo boxes. The list box is updated starting from the selection in the combo named cbofilterStudies. In my examples, please look at the selection “Age Study”. I am having a problem with the...

Yes. Thank you

Thank you all for your help. It works great. I will not add more queries. About the "1", that's just the criteria I need to sort the records in my query. Thanks

Hello. Sorry if posting this thread in the wrong section. I have a form on which I have a combo (cbostudy) and a listbox (lstStudy). I would like the list box to dynamically change the record source to different queries, depending on the selection in the combo. I have already created two...

Yes, possibly to the same cbo. Thank you

Than you for your help. I have been able to add the YOB field in my query but not the other ones. I have uploaded a simple example of my db which will probably help you to have an idea of my confusion. Thank you. Really appreciate your help.

Thank you for your replies. Still not sure if I got it clear. My combo lists the age (1,2,3,4,ect, up to 100). When I select the age, the query should return all records that based on the date of birth, will turn the age selected in the combo, in the current year. Example: The value selected...

Thank you for your quick reply. The problem is that I don't know what to write in the calculated field. Will appreciate any additional help.

Hello, I have a table with the list of my clients. A field of this table is their Date of Birth (DOB). I would like to create a query that returns the list of clients that in the current year will obtain a specific age (example 65). I will select the criteria (the age) from a combo. Thank you

Thank you for your quick reply. Since I am still having a problem I am attaching a very simple example of my db. You will notice that the cbo has different selections. All refer to a different criteria, in the same query. Each criteria will search in a different field. Thank you.

Hello, I have a form with a combo and a list box. The combo gets its data from TABLEA in which I have used a list of records which will be used as a query criteria. The listbox has its record source in TABLEB and is populated after the AfterUpdate event of the Combo. The records I am...

Thank you very much for your quick reply. Honesly I don't need a professional software that manages status of work etc. as it is alrady controlled by other programs. My need is simply to be able to assign workload to a given number of employees as described in my first Post. I will look at the...

Hello, I apologize if this is not the correct thread but would appreciate some help on finalizing my project. I am designing a workload assignment database that managers can use to assign workload to different employees (from 1 to 30) based on percentages. Managers will have the option to...

Thank you. Since I am not very good with VBA. I believe I place the code in a module and how will I call it so that is will show up in my result textbox? Thanks.

Hello, can anyone help me with a date function? I have two date fields and need to return the difference in years and months in an unbound txtbox. Thank you.