Recent content by GaryCanuck

Thank you both for your suggestions. However, I have tried both and the problems still persist. It seems to have to do with null values but I have an "Nz" so I'm not sure how that could be. Is there any information that I could post that would clarify the situation? If so let me know. Any...

In situation 1) above no error message pops up but the Client# half of the Open#.Value doesn't appear. In situation 2) the error message is "Runtime error 3464: Data type mismatch in criteria expression". I apologize for not including this info in the first post.

Hi all, I'm running access 2007. I have a form with two subforms that make up a client index. On one of the subforms I have an autonumber field where the field is populated with the value on the double click event. It works as desired most of the time but under certain circumstances it produces...

I have a word document that I'm opening from access. All are office 2007. The word document has a number of ASK Fields and so when it runs it opens 20+ popups boxes one after the other asking the questions and this works fine. However, is it possible to combine these popup boxes into one so that...

I've switched to using an update query to do the same thing. Seems to be working. Thanks for sticking with me!

Update, I've gotten a little further with it. The parameter problem was that the field municipalities_status and properties_status should have just been written as [status]. I'm now getting an error that "only one record can be returned by a subquery". Are there ways around this?

I gave your code a whirl, thanks kindly for the ideas. Particularly with the boolean values. Your assumption was correct that it is a yes/no field. The "getmunidischarge()" function gets a value from a table, however I've used it in this context successfully before so I don't think it's the root...

I have this line of code to update certain values in a table. I'm getting the error that "there are too few parameters, expected 2". It's a little tricky but I can't spot the problem. Any help appreciated! db.Execute "UPDATE [Properties] SET [Discharged?] = YES WHERE [Owner#] = (SELECT [ID]...

I ended up moving my recordsource chunk to the beginning of the code to separate it from the word references. This seemed to do the trick for now. Thanks kindly to the both of you for your replies.

If I take out that line the it will run the first time, and error on this line the second time: objWord.Application.Run "ScratchMacro" The application.Quit line is there for a reason though, without it an instance of word stays open in the background. I'm assuming this is from the instance of...

PHV, I tried your suggestion and when I do that I get the error that "the object invoked has already disconnected from its client". This occurs on the first time the document is run, where it normally only errors the second time. Any other ideas?

Okay so I did those things (thanks for the tips) and it errors on this line: Set Lrs = db.OpenRecordset("Discharge Schedule", dbOpenDynaset) The error says it can't find "Discharge Schedule" However again this error only shows up on the second time the document runs. The first time it runs it...

Sounds like you need to use switches. Assuming it is Word "Fields" that you're using. Right click the field and click edit then add the appropriate switch. Something like \# ",0.00". See http://www.gmayor.com/formatting_word_fields.htm Cheers.

I do not know which line of the code is causing the problem. Just that the error occurs after the call to run the second query. I can't seem to figure out how to step through it. As for your suggestion, yes there is only one record and so it functions without a where clause. Thanks for the...

Hi All, I have a somewhat messy chunk of code to run a mailmerge for 2 documents. I've attempted to set up and qualify all of my variables but it appears that I haven't succeeded. The code will run as desired the first time (on click event of a button). And then error the second time which is...