Search results

Solved. I just changed my code as follows and works. Thank you Form_Current() If Me.cbo1.Value = "Hello" Then Me.cbo2.Enabled = False If Me.cbo1.Value <> "Hello" Then Me.cbo2.Enabled = True End If End If cbo1_AfterUpdate() If Me.cbo1.Value = "Hello" Then Me.cbo2.Enabled = False...

Thank you. The combo (combo2) now does get disabled but if I chance my selection in combo1, it does not get enabled. Its stays grayed out.

hello and thank you for any help you can provide me. I have a form with multiple combo boxes. Each combo gets populated according to the selection of the other combo. I would like that when I select a specific record in combo1, combo 2 get's grayed out (locked) as an additional selection...

Since I use dynamic combos I would say less then 10.

Hello, I have a form with a combo that is used as criteria to a queries. I would like these queries to be used as record source of a standard reports which should then be attached to an email in pdf format. Users will select the query from the combo and the report generated into pdf. I...

Yes. Works great now. My mistake, just overlooked a simple but important detail. My I ask just one more thing? What is the reason of the & "*" after the criteria? Thanks Like [forms]![myform]![txt1] & "*"

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...