Recent content by tca_VB

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

Found the solution: I was missing the default value in the common field on the subform needs to be set to: =[Forms]![frm_Client]![Client_ID] Just wanted to share the answer for those who might have been viewing and trying to figure out as well.

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 found a solution. I adjusted a few properties. Thanks for reviewing.

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'm reading other resources I can find online. One says something about the ListBox form being open when you run the query. Is this true? It mentioned something about putting a subform on the ListBox form that then runs the query. I tried to create a subform based on the query, but it would...

I've double checked spelling and can't see anything wrong. Do I need to set the Query-Parameter to something? I usually don't do that but needed to for something else. I tried setting [Forms]![frm_CategoryList]![lstCategory] to data type Text But I get the same result, still looking for...

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

Report Button in Form with List Box I also tried to follow the sample database posted with a list box selection to print a report. I'm missing something... In red is what I changed out from the sample database Private Sub btnRunReport_Click() 'Lister 30 Sep 2007, Waipawa New Zealand 'Loops...

Parameter set to Integer Yes, thank you. Setting the parameter to integer solved it! Many thanks!!

Reserved Date name Thanks for the tip - missed that one... I changed it to History_Date, but I'm still having problems with using a parameter.

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

Print Form view - current record only I'm trying to follow the various forum postings to print current record only from a form (that includes 2 sub forms). I've formatted the form view in a user friendly entry view. I would like to print this same view - current record only. Is it possible...

Your solution Elvaar, Yes, I would be interested in seeing your solution. I tried vb code to update the junction table shown in http://www.access-programmers.co.uk/forums/showthread.php?t=139975 That didn't seem to work and can't find the 'hole' in it. My next idea was a bit of a...