Search results

I inherited a database that has a form with a lookup on a name field. When the name is typed into the field for lookup it seems to go in an endless loop and doesn't return anything. Prior user added a text message box that simply needs to click on OK and record returns. I'm assuming that it...

I would like to open a second form via a command buttom on the main form. I'm avoiding a subform because I don't want it to display until clicking a button. Main form: frm_Client Second form: frm_ClientPersonal In the properties of frm_ClientPersonal I have record source: ClientPersonal...

I hope this is an easy one... I have a table in which several fields are populated from a list box (values provided in a list or table). When I preview/print a report with these fields, the fields have a solid box over the field instead of displaying the value selected. See attached. Any...

I have a query which is based off all fields of the main table. I want to run the query based on one or more choices made from a list box on one field: category. tbl_ClientMain qry_ClientCategory - all fields of tbl_ClientMain with criteria under Category as...

Problem: I have a datediff function as a field in a query: DateDiff("d",[ClientHistory].[Date],Now()) When I put in the criteria: >30 I get two results based on the datediff values equal to 37 and 110 for the two records. Now problem: when I use >[Enter value] for the criteria and enter...

I need a little help; I think I'm close. I'm trying to run rpt_MainClientCategory based on Category selection from a list box. I have the report based on qry_ClientMain_Category and in the criteria of Category "=[Forms]![frm_CategoryList]![lstCategory]" I have frm_CategoryList created with a...

I'm trying to add records to a junction table based on additional record added to one table via form in the many to many relationship. Junction table = ClientAssociation Main table = ClientMain (qry_NewClientNullAssociation identifies new record added) Many to many table = Associations I'm...

I've reviewed many threads and FAQs about multi-select list boxes, but I can't get to the next step on how to save the values in multi-select for use in queries/reports/form view. I have a main form - frmClientMain (writes to ClientMain table) Client_ID can have multiple Type_ID from table...

I am debugging an access database that is pre-2000 and converted to 2002. There are several errors I'm trying to resolve, but the first couple relate to User-defined type not defined. (I have updated the reference to Microsoft DAO 3.6 and have tried adding Microsoft ActiveX Data Objects 2.8.)...