Recent content by spherey

I worked it out. Thanks for your time. I don't recall what the error message was that I was receiving, but I was able to work around it by creating the .pdf using the individual Frame files instead of the book file. I convinced the users that creating a giant Frame file when there was already...

Well, sort of. I was talking about pasting one document after another, and another one after that, and so on, so that you'd end up with all the smaller documents combined as one .fm file instead of as a .book file. I actually didn't know about the page up/page down feature, and that's helpful...

Hello all. I've already made a book file out of 30 individual docs. I'd also like to make one great big doc file out of all those smaller docs. In most other programs out there that can handle text & images (at least the ones I'm used to - Acrobat and Word and various other text programs)...

Hey Twoodd and Ken, I made some more changes - I made all my variables one word and removed the brackets, and set it to Option Explicit, but I'm still getting that error. It may well be a problem with having too many references, but unfortunately I can't remove the other two, as I need them...

Twoodd and Ken, Thanks for the additional suggestions. Fixing the rst = seems to have fixed the issue with the SQL. Now, I'm instead getting an error that reads "Compile error: external name not defined" whereupon it hightlights this portion: [Company Name] = of this line of code...

Hey Twoodd, Here's the latest. In the modAppendCompanyInfo, I changed the SQL statement to what you suggested. Now it's giving me the following: "Compile error: invalid use of property" and it's highlighting rst = in the line rst = CurrentDb.OpenRecordset(MyQuery, dbOpenDynaset)...

Twoodd - Wow. Thank you so very much for all your time and energy in helping me out so much. I have been coding steadily since I got your first response, and so far, I haven't gotten it to work - I'm thinking that this is most likely a mistake in my code that I've made in the process of...

Larry - I think that that would work, but it wouldn't create a report which would look the way these people want it to work. I wish it were that simple, but they're picky. Twoodd - That's exactly what I'm looking to do. And yes, I'm keen to write some code. I'd welcome any coding expertise...

I don't follow you - I'm certainly open to using a subreport, but I don't see how that would solve either problem. Whether the notes field was a part of the main report, as it is now, or was part of a subreport, I'd still have the same issues with it - I still don't know whether it's possible to...

This is either going to be a very odd question or a very simple one. I have a report which is built upon a query which draws from more than one table. One table is "company information", and the other table is "company notes". The company information is always the same...

Ken - You didn't add any confusion - it was your suggestions, in fact, that got my code up and running! Jim suggested that I change the format in the underlying table to Text from Date/Time, and you suggested the change in code (and yeah, I saw from your example that in that case, I'd have to...

Jim and Ken, Thanks so much for your help! Jim, the fields in the table were set to Date/Time, and I changed them. It still didn't work, but that was because I was using the wrong code, like I thought - Ken, that was the right code. Once I plugged that in instead, everything did exactly what...

Hi everyone, I have a series of check boxes all linked to date fields in a form. The check boxes have an 'after update' event that automatically places the date in the date field when the box is checked. There are also a second set of date fields which are dependent upon the first set -...

After getting some advice from the other forum members, I've decided that it's a good idea to split my db into FE and BE. But I also want to set up user-level security. My question is this: does it matter if I split the database first and then run the user-level security wizard (and if that's...

Good call. I'll do that. Thanks again!