Search results

OK this is even wierder, I thought maybe the Microsoft pdf writer was translating the field incorrectly so I opened the report and created a pdf using an outside pdf writer and same thing happened. I thought that was my backup plan...

Yes...and no. The field is calculated in the source query but as far as the report is concerned, no. Exact same thing with the extended cost field that does display.

This is wierd but when I generate a report in Access (2007), everything looks fine but when I save as pdf, the data in one of the fields is not displayed. Attached are snippets from the access version and the pdf version. Both the Price per unit and cost fields are in a subreport. The...

Keep your eye out - I'm sure I'll have lots more 2007 questions in the coming days :eek:!!

My thanks once again!

Thanks, that helped a lot. I just started with 2007. I used a template for this form that obviously used anchoring, a function of which I was previously unaware. Seems llike a useful feature. Since you obviously have some experience with 2007 features, can you perhaps explain another feature...

Thanks Leigh - after much research, I did come to that conclusion so I came up with a bit of a workaround. I have checked out mztools and will try to spend some time with it in the near future. Thanks for the tip. The link to 'Wayne's tool' didn't work. Is there a benefit to using the...

I know this will be a simple answer but I can't find it. When an error is thrown, I want to capture the name of the current sub and the form object to a function that adds the error details to a table. I'm going to pass the caption property of the form but how the heck do I get the name of...

Oh...and BTW, the form looks fine in design view.

This is my first time working with Access 2007. See the attached screen shots. When the form is opened (capture1), it is auto-sized and it's all nice and tidy. It gets really messed up when maximized tho' (capture2). I will likely remove the control box from the forms to preserve the look...

I guess I can do that. I know I'm being nitpicky but I'm aiming for a real clean web-like interface and if I do that I might as well highlight the close button. I was just trying to avoid the border thats applied when an object has focus. You're the awesomest :) for responding so quickly!

Sorry Bill, doesn't the SetFocus method do the same thing? If I set focus on any of the unbound text boxes, it fills the box. If I set focus on the transparrent cmd button, it adds a select border. I guess what I'm trying to accomplish is not setting focus on any control or object.

Wierd that I haven't run into this before. I have a static form with some unbound text boxes. When the form loads Access wants to select a control and therefore selects one of my unbound text boxes. Problem is they are hyperlinks and I don't want any selected which fills in the text box. I want...

I do understand that results of calcs are not in stored in tables and are only displayed on the form/report. There still might be followups as I continue to work on this but I wanted you to know you've been an awesome help Bill. I appreciate it.

OK I think I got it. You're being such a huge help - here's another wrinkle. We want the flexibility to do a line item discount which we can just manage by changing the line price for that item. However, to win the quote, we might have to apply a 20% discount to the total. Would you put the...

Wait, I made an error - what I've described is what I was already doing. What you mean is putting the revision number in the detail table - right?

Hmmm...that's an interesting approach. I think I like it. Just to clarify...so you're saying QuoteID would be the Primary Key in tblQuoteHeader and would link to the child table tblQuoteDetail?

Thanks Bill...would it be a problem on the composite key, that you'd have to revise the Quote number manually (or I guess autoincrement via code) The other thing I thought is maybe the quote table should be broken up and there should be a master quote table and a child revision table with one...

Here's the scenario...I am working on an application that will provide complex customer quotes. A quote is drafted and sent to the customer. They ask for a revision and the original quote is revised, but we want to keep the original one intact (just in case the customer changes their mind and we...

BTW - I did mean both and your response was useful for both. (Gemma's adorable)