Replies

Sorry, I’m pretty lost.

Working first with your post, #3 How do I “Open a command prompt? Is that in explorer? If so, am I correct in assuming, I’ll be changing the last part to: N:My DocumentsProjectsAccessQuoteTest Areadb3.mdb, which is the location of my database?

Trying to understand the link…Resolution #2 I don’t know how to “save the code behind the form…” Actually none of it was very clear but it might make more sense once I see how to save the code…

I’m using Access 2000. I have not split the database.

I tried exporting a group of forms and the command buttons still aren’t working. I imported the tables and queries though. Was that okay?
When down to one of the on click event procedures to see if there was anything there and the screen is blank. (screen shot attached) Perhaps there is something that I need to turn on. I just don’t know!

I’m not sure where to go from here.

You were almost there. See the attached version.

That will make life much simpler! THANK YOU.

The combo box that I’m trying to work with is in frmStudents and is labeled cblDealerSearch1.

Thank you in advance!

Thank you for your reply Hans.
That put the AS8CODE in the end user’s combo box, which unfortunately make for a bad search as rarely do they know if. I may be going about this wrong. What I’m trying to do is provide the end user with an easy way to search for the customer that they serviced. Ideally, I would like to allow them to start typing and then select the correct customer from the drop down list. The combo box was working well until I realized that the sort order was scrambled because the original table that I imported was sorted by dealer number. I hope that makes sense. Thanks again.

Try the following:

– Create a query based on MasterList_Dealers.
– Add AS8CODE and AS8DESC to the query grid.
– Clear the Show check box for AS8DESC.
– Set the sort order for AS8DESC to Ascending.
– Save this query as (say) qryDealers.
– The SQL for this query should look like this

SELECT MasterList_Dealers.AS8CODE
FROM MasterList_Dealers
ORDER BY MasterList_Dealers.AS8DESC;

– Set the Row Source of cboDealerSearch1 to qryDealers.
– Make sure that the Column Count of the combo box is set to 1.
– And that Column Widths is blank or contains a single number.

Select Edit | Links…
You’ll see a list of links in the document.
You can select individual ones: click the first one you want to select, then Ctrl+click subsequent ones.
Or you can select them all: click the first one, then Shift+click the last one.
Click the Break button to break the selected links. You’ll be asked to confirm your choice.

Thank you Hans. He’s concerned that when he emails the document to others, they will have trouble opening it. They shouldn’t receive any kind of prompts once the links have been deleted, correct?

The name of the group footer *is* GroupFooter0 as you can see by selecting it and looking at the Other tab of the Properties window. So you should use

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)

instead of

Private Sub QuoteGroupNameFooter_Format(Cancel As Integer, FormatCount As Integer)

Thank you. It’s working as expected now!

In addition of Hans’ answer, you should have [Event Procedure] in the On Format event of GoupFooter0. See attachment

THANK YOU!!! I was trying to compare the differences but missed that one!

Have you added a control named QtyDiscount to the group footer? If there is a control bound to QtyDiscount but whose name is different (for example Text37), the code will fail – the code uses the Name property of the control.

And is the name of your group footer GroupFooter0? If it has a different name, you should use that instead of GroupFooter0.

My GroupFooter had a different name and I don’t get an error on QtyDiscount any longer BUT the fields and space allowed for the field don’t disappear when they are left blank. This is so frustrating. I think I have everything set as Can Grow/Can Shrink but I’m definitely missing something!

(I had to put each term on a seperate table so they could track when the terms change and I didn’t know how to do that without breaking them out.)

I’m attaching a new database. Any assistance you can offer will be appreciated.

Thanks,
Theresa

The subforms aren’t really empty – they do display a single record, but the field in some of the subform happens to be blank.

I don’t see the need for all those subforms. You can include the fields in the record source of the main report.
Since you want labels with the text boxes, you need a little bit of code.
See the attached version:

I have no idea why the logos wouldn’t appear in a PDF file.

Thank you for the reply. I wasn’t able to work on this last week. Sorry for the late reply. I hope you get this because I’m not quite sure how this new format works and have not been able to get the email reply to work myself.

I had to add an additional freight term and I’m afraid I must be missing some of the code. I clicked on QuoteGroupName footer, went into the module and pasted what you had on the sample database. Added the additional term that I needed (QtyDiscount) and I’m stuck.

This highlights in yellow:
Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)

This is what I tried to add:
Me.QtyDiscount.Visible = Not IsNull(Me.QtyDiscount)

Is there code somewhere else that I missed? I noticed that your module had (General) and (Declarations) at the top.
I’ve tried to adjust it to that but it keeps reverting back to GroupFooter(0) and Format.

I don’t know if my last attachment worked.

I’ll try this again. Would you mind checking the properties on the logo’s for me because they only go over to the PDF on occassion. Sometimes they are there and sometimes they aren’t…

Thanks

Make sure that Can Shrink has been set to Yes for both the group footer section and the subreport.
There shouldn’t be other controls that overlap horizontally with the subreport control; for example, there shouldn’t be a label next to the subreport.

I’ve checked and from what you’ve indicated this should be working fine. I took my access class a few years ago and I recall the instructor cautioning us that if when someone (in my case the IT dept) installs the software, they need to make sure that the old version of access is completely wiped away. Could that be the case here? I don’t remember how to check that but could that create a problem with something like this? I have unbound images on the report that randomly appear and disappear when pushing it to an Adobe PDF. My coworker has to do all of the printing because I never know if the logo’s are going to “stick” or not!

Horizonally, the subform goes from margin to margin with nothing next to it at all. There are several subforms both above and below it.

The subform is in the footer section (QuoteGroupName footer). The properties for the footer and subform are set at Can Grow and Can Shrink. Is there anything else that I should check?

Unfortunately, they want more then what I THINK the text field can offer them. I need to find out what my options are but they’ll probably have to go to a seperate document.

We will be offering several different freight programs. Some of the text will need to be underlined, some will be underlined and bold, they would like a blank row between paragraphs…clearly far more than a single text field can offer.

Please let me know if you have any suggestions because I’m not sure where to begin. If everyone got the same freight terms I would just create different text boxes and format the box accordingly but it will vary from customer to customer.