Search results

Hi, Thanx Steve it worked. Stay well. Joseph

Hi, Please, I need help to print Foreign Keys (CrimeID) back to original values (eg Theft) as stored in the table tblCrimes. My tables are: tblPersons (PersonID=PK) tblCrimes (CrimeID=PK) tblPersons_Crimes (Person_CrimeID=PK, CrimeID=FK) Please, how can I do this? Joseph

Hi xpts, Before I had all my forms set to Modal=No, Pop-Up=No. This way I was able to close any form with a Ctrl + F4 keys on the key board. Just wondering if there is a similar combination to close forms when they have both of the above properties set to YES. Thanks always. Joseph

Hi, I have a form with three field: CaseName, CaseDate, CaseStatus All I need is a small code that would display message and close the form automatically after user enters data in all the three. All fields should be mandatory. Thanx. Joseph

Thanx for your help. I made the details form a subform and it works just fine. Stay well. Joseph

Ok, Let me go through again. Joseph

Hi, I think my table relationship is set well. But why the Foreign Key is not populating I don't know. Please, help. TBL_Cases (CaseID=PK) TBL_CaseNotes (CaseNoteID=PK, CaseID=FK) FRM_FileCases is the mainform with only two cases and the details form (FRM_CaseNotes) with the CaseID=FK in...

Hi Doc, No, I don't think so. You're more valuable now. Thanx for the explanantion. I will now search for DMax and learn from there. Regards. Joseph

Thank you freshman. Yes, I noticed it worked only when the form property is set to single form view mode, but I am working with the form in continous mode. How else can I make it work? Joseph

Hi, Thanks. I just tried your suggestion but all records getting (1). I want them in sequence 1, 2, 3

Hi all, I have two tables: 1. tblFiles = FileID(PK) 2. tblFile_Cases = CaseID(PK), FileID(FK) The first table is the records source for the mainform (frmFiles) from which i open the details form whose record source is the second table. So then details (frmFile_Cases) opened for the first...

Hi David, and theRainman, Thank you so much for all the help you have given me on this one. The query counts all records. Is it possible to count only records (cases) with the status "Open" and if status is "Closed" the value should be "0". Joseph

I am trying to help my office in tracking cases recorded on individual files. 1. tblFiles (FileID=PK) 2. tblCase (FileID=FK) 3. tblCase_Notes Any one File can have many Cases on it; and one Case can have as many notes as possible. In the table "tblCases" I have included a field to store...

Thanx, I got it:

Hi, How do I set form width and height from code? Thanx. Joseph

Hi, I am trying to construct SQL statement. The first one worked with only few criteria (PersonID, Person_LastName and Person_FirstName): SELECT tblPersons.PersonID, tblPersons.Person_LastName, tblPersons.Person_FirstName FROM tblPersons WHERE (((tblPersons.Person_LastName) Like...

Hi, I have an issue linking a subform (frmPerson_Crimes) to another subform (frmPerson_Crime_Notes). On the first subform are crimes commited and the second subform shows details of each crime ( all details in one memo field). So the relationship is one crime to one crime note. The tables...

I was admiring the Google Maps application here http://www.access-programmers.co.uk/forums/showthread.php?t=163624&highlight=Google+Maps+access posted by ChrisO and was wondering how I can add my new streets and locations in Zambia, Africa. I tried to locate local a few places but could not...

Thanx I found a solution to it. Stay well.

Hi David, Thank you so much for the sample. That is what I was looking or, but please more help. Am trying to replace TBL_Employees with tblPersons and added into it a field as yours 'fldFlags' but am still maintening tblSampleData. However, on my form when I drop down combo and select...