Search results

I am almost there!!! After playing around for quite awhile this is what I come up with... If DCount("[Incident Report Number]", _ "[Tbl-Incident Details Resident]", _ "[Incident Report Number] = '" & Me.[Incident Report Number] & "'") + _ DCount("[Residence Location]", _...

I think I got the brackets right??? This is what I have...I thought is was right...(that was the problem I was thinking!!!) If DCount("[Incident Report Number]", _ "[Tbl-Resident Surnames]", _ "[Incident Report Number] = '& Me.[Incident Report Number]&'), 0 + _...

Hi Mile So I deleted the Nz as you suggested with the only difference being the error message now displays "Expected list separator or ")"" on the first "(" of the DCount line. I searched my books and nothing about list separators... When I stop the debugger then I get the same error as...

Is this helpful? When I was playing around a while ago (learning very basic stuff), I used a crosstab query to count the selections that were checked. I did not know any code back then (still don't!!!) but I got the results that I thought were proper. I am not sure if this is helpful... Navyguy

Hi Wayne This is what I did... If (Nz(DCount("[Incident Report Number]", _ "[Tbl-Resident Surnames]", _ "[Incident Report Number] = '& Me.[Incident Report Number]&'), 0) + _ Nz(DCount("[Residence Location]", _ "[Tbl-Incident Details Resident]", _...

Hi Rich The criteria is based on several items. You are right the Incident Report Number is unique, but several surnames could be attached to the incident which are in a separate table. I added the Residence Location just as a thrid criteria to eliminate user errors when finding the required...

A few days ago Wayne helped me out (thanks alot again!!) using a Nz(DCount..) to search for null fields. Now I am trying to modify the code to do the same but using multiple fields. I have read my references and searched but have not had too much luck. I think I am supposed to use the AND...

Another Update I spent the good part of the day working on this and this is what I have come up with... I created a "module" and called it ModSampleNotice and used this code that I got from the MSAccess Knowledge Base site... Function MergeIt() Dim objWord As Word.Document Set objWord...

Hi Rocky I am probably the last person to be giving advice on access, and I hope somebody will correct me if I am wrong or at least giving poor advice... I have been reading about normalization allot and just by your questions I think that you may need to have a look at how you tables are...

update on this I tried copying and pasting the word document into a Access Report and I thought Ah Ha got it now, but when I opened the report the text was all misaligned and where I only left so much room for a memo field on the report, it expanded over the pasted word document and cut off the...

Hi to everyone…again I have been trying to learn how to print a merged word document from a button on a form. Have read the MS knowledge base site and numerous posts and I thought I had come up with a winner…but I was wrong, so looking for your tutelage once again. Name of DB: Test.mbd Form...

/Navyguy Jumping up and down/ He He He/Dancing in Circles singing out loud/ It Works!!! It Works!!! With many many thanks. There is a reason you have over 2600 posts and I have 22!!! Such a simple little feature makes all the difference, yet I think it has taken the most time for me to...

Hopefully this will work. I had to get rid of alot of stuff to get below the posting limit...reminds me of flying!!! I think there is enough to look at for this particular problem... Thanks for your help and patience Navyguy

Update or lack there of... I tried changing some things several items in the code. Even went back and changed the names and pasted it into an new DB but no luck. The error did change a couple of times back to the one that was first posted. As I reset everything I am back to the automation...

Thanks again Wayne I pasted your code and still get the error as before. I was wondering, since I don't have a control source for the field [Incident Report Number], because the user would input the number, would this cause a problem? I have checked all the spelling and /grinding teeth/...

As requested Wayne The "View Incident Data Form" is the button that is linked to the form that displays the record for editing. So I pasted your code inside that function as I would think it is associated with that action. I know that my naming conventions need work, and I was searching the...

All right Wayne Ok that makes sense...I guess. Just a different way to think about it. Count the records and if you get 1 carry-on and if you don't get any "All Stop". So I took your sample of code and pasted into where I think it should go and I get a new error stating that "The object...

Thanks dcx693, that was quick... Maybe you will have to point me in the right direction, but I don't want to count the records as it is either there or not. There will not be multiple instances of the criteria of Incident Report Number as this is a (PK). If the user selects the correct...

What I have is a form that I use as a filter to select a record for updating. It is called Frm-Resident Select Incident and the field I enter the criteria is called Incident Report Number. I then click on a button the opens another form called Frm-Resident Incident Data based on a query that...

It would be nice if people were taught this stuff long before the advanced courses!!!! Navyguy