Search results for query: *

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

Using the shift key as you suggested worked, thank you! For future readers it also works to open a new blank 07 database and import the old one.

That's got it PHV. Thanks Again!

Ah Yes that makes sense. So then the next obvious question is how do I modify my code to reflect that and choose the actual largest number. Could I for instance set a minimum of five digits?

Thanks PHV. That's getting close to what I'd like it to do. There's some sort of glitch still though. It's returning 9999C which for some reason is "bigger" than 10000C etc. Is there a limit on the number of characters the function will count up to? Surely not. Or is it assigning a value to the...

Hi All, I'm currently running Access 2007. I have a field called Close# that I would like to increment from the previous highest Close#. There are a number of complicating factors however. First, the tables are shared with another program and the field is a text field. So it can't simply be...