Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Larry1216
  • Content: Threads
  • Order by date
  1. Larry1216

    Forms Filter using drop down list?

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

    Importing Text Files - Access Column Limit using Import Specs

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

    Import Fixed Width File Wizard - File limitations

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

    Access Combo Box - Can't display desired default

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

    Data Entry Validation, Multiple Conditions

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

    MS Access - Form Validation Rule - referencing other forms or tables

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

    List Box - Selection on First Record Repeats thru subsequent

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

    Printing Forms - Can you skip Form Header on Page 1?

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

    Windows 2000 - Laptop reboots upon ISP Connection for some Phone lines

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

Part and Inventory Search

Back
Top