Recent content by manito2000

Hello everyone, I have two tables that need to be exported on one .txt file. One table has the header record. And the 2nd table has the detail record. My issue is as follows: 1. Need to create one .txt file 2. The header record has one set of export specs and the detail record has a...

Hello everyone, I have a .csv file that I am trying to import. I have the import specs from the file layout: However, when I use the import wizard and cut/paste the Field, Type, Start, and Width...I get an error saying: An Import/Export specification must contain at least one field. I am...

See attachment. thanks for offering to look at it. I've placed it on my google drive: https://drive.google.com/file/d/0B50hIEiMxsD_ajVzQjVyZnFoNUU/edit?usp=sharing Hopefully you can take a look at it. BTW...I've tried using Diskinternals Access Recovery software and it is repairable...however...

Tried .laccdb ...can't find that either.

I cannot open my database because of the following error: The Microsoft Jet Database Engine Stopped the process because you and another user are attempting to change the same data at the same time. I've already tried looking around on the internet and most resources tell me to look for an .ldb...

Hello everyone... I have a database where I am using a combo box with 3 columns. It has a total of 3 rows. The reason for the 3 columns is I have a term that is translated in English, Vietnamese, Spanish. For example: English text in Column 1 = Yes Spanish text in Column 2 = Si Vietnamese...

Hello... I have a DB where I'd like to include on the form 3 e-mail buttons...3 different e-mail recipients. I'd like to be able to press the button and have my Outlook e-mail the person (assigned to each button) and pull the record number field and the due date field and put it in the Outlook...

I'm not allowed to update it

Nope...I just need them to show up in the managed patients table.

Correct...I have those ID # in the case managed patients file. However, not in the new file from the query. Those 40 patients will never show up in the patient demographic file. They are "extras" that simply need to be case managed but will never show up in the patient demographic...

Ok... However, how can I append the demographic info to the first 660 patients... This is what I've done... 1st table has patient ID# (700 case managed patients) 2nd table has all patients (90,000, however, missing 40 patients from my 700 case managed patient file) I do a query to show all...

Not all the demographics exist. There is only demographic info for 660 patients.

So basically two tables... One of the tables only has patient id for case managed patients (I need to extract their demographic info) from the 90,000 record file for at least 660 of the patients. The other 40 I need to enter their demographic info seperately because they are not in the 90,000...

Thanks...however, I am having a huge dilemma. I've got 700 patients (that are going to be case managed)...I also have another table with patient demographic info (90,000 records). I've already done a quick match in excel to see how many of the 700 patients are in the (90,000 table)...

Hello, I need some help. I have the following tables: Patient demographic info (Patient ID, First Name, Last Name, Address, date of birth, etc...) Physician demographic info (Physician ID, Name, Last Name, Specialty, Phone, Fax I also have another table with patients that are being case...