Search results for query: *

Have a main form for Health Plan Member Demographics based on a table. A subform with Physician Demographics that the members have seen is based on a second table. The member usually has seen more than one physician. The two tables are connected in the subform by a common identifier in each...

Checked to view the system files. The MSysIMEXColumns is read only Do you recreate the table elsewhere, add your desired fields and import it back into Access? When you speak of the Data Type Values ------------------ Yes/No = 1 etc Does that refer to the MSysImexColumns table, another...

Importing a Fixed Width Text file and want to name the fields and start-stop positions for each field. Was using the Import Specification to do this but when I get to the 60th field-78th Character. The wizard lets me add but won't save the specs. Field Name Data Type Start Width Indexed...

I have a file with a large number of fields and was trying to create a fixed width file specification. It was working well until I got to the 62nd field and Start field 77. Now, I can add the additional field but when I save the specification, any fields past no 62 disappear. Saw from the...

Row Source = SELECT [Reference 04 MRR Reviewers].[Order], [Reference 04 MRR Reviewers].[Reviewer Name] FROM [Reference 04 MRR Reviewers] Reviewer Name is what is displayed in the form - the control source is another field with a unique code for each reviewer. "ReviewerCode" Thanks/ LMc

Implemented Remou's suggestion on the "row source" line of Control Properties but unfortunately it does not work although it should! ThankJoes suggestion is beyond my limited technical abilties. Thanks to both of you for making suggestions. /LMc

I have a combo box based on a table going to files for different users. Wish to display a particular person in the combo box "Order" field is set as primary but the first record MP is not displayed - another record is instead. Thanks for Input - did not see this specific item in knowledge...

For validating Data Entry. 1. Date has to be between [Date1] and [Date2] AND it also has to be 2. If[Date3]="A" and [Date4]-[Date3]<15 - Do not permit data entry - Otherwise give the validation text It would be nice to have a different set of validation text for 1 and 2 but maybe...

M8KWR and The ACEMAN1; Thank you both for responding. I did not have the form open and that made the difference. Is there a way I can use this type of validation rule without having the or table or form open? Thanks, Larry1216

I want to have a validation rule for a form reference another form or table in the same database. I have a table [Reference 03 Data For Forms] with a field [RYEndDOS] in the Short Date Format. There is a form [Switchboard] where the user enters a date for the end of the year. In the...

I have a form that is based on a table t_XXX. The form has a list box that is bound to a 2nd table with the following values. Order Comments 1 Not Excluded 2 Hypertension was not Confirmed 3 End Stage Renal Disease (ESRD) 4 Actual Age is less <46 or > 85 as of 12.31.CY 5 Other Data Error...

I would like to avoid having the Form Header Printed on the first form. Cannot seem to find a way to do this. Any assistance would be greatly appreciated. Lawrence G. McLaughlin Office: 757.546.7195 Cell/VM: 757.675.8486 Fax: 928.563.1316 400 Meridian Drive Chesapeake, Va 23322

Windows 2000 laptop reboots upon ISP connection for some phone lines. Here at home with a digital phone line - it reboots consistently and I have given up (have cable now wo problems) On the road, some places connect and some places don't -- consistently. Thought the issue was modem or...