Search results

Greetings! I have a report that is grouped by a field called GroupCode. The GroupCode can be either a 0 or a 1. Essentially, this is intended to divide the report in half, so to speak. What I want to do is show the group footer after the first group, but not after the second group. Something...

Thanks! Wow, thanks guys, for the effort you put into finding a solution for me! I was thinking that some code might be the way to go, and looking at Jon K's suggestions, this is something that will definitely work for me. Currently I do not store the calculated vote count with the...

Hi there, I wasn't sure whether to post in reports or queries, as I do want to end up with a report. I reckon it will all start with a query, however, so here goes.. I have a situation where I will be keeping track of people that are registered for a convention. Now, each person will be...

Hey, thanks for this! Almost perfect, I just had to add another Int() function inside each side of the equation (it was only working on numbers like 32.00 and 117.00, not 32.22 or anything with values to the right of the decimal. For example, 117.26 would return a 0). Anyway, works great...

Good morning, I would like to place a line after groups of records based on a value in the record. For example: Record 1 1.05 Record 2 5.77 Record 3 9.87 --------------- Record 4 10.50 Record 5 17.66 --------------- Record 6 23.00 --------------- Record 7 36.99 Record 8 38.99...

Yes, tried label wizard Hi, Yes, I tried the label wizard as well. The problem lies in the fact that the printer driver has a minimum top margin, basically. Even if I set the margin to 0", the printer driver will ignore this, and place the minimum margin there, which screws up the alignment...

Good Morning, I am having a heck of a time trying to get a report to line up properly! The report is to print out a large number of membership cards, on to pre-printed card stock. There are 3 cards on each page, with no margins at the top, bottom, or side of the pre-printed form. The cards...

Thanks, Kevin. This is a good idea that I will keep in mind for future projects. For this one, though, the products are displayed in a web page. How would you go about "hiding" the shipping charge item(s). Would you add a field to the products table (a flag to indicate whether to show or not)...

Hey Pat, This is probably the best way to do this, it would definitely be more organized. I just dislike using sub-reports, as I find them difficult to line up with the main report stuff at times. Thanks for the help! Cheers, Gord

Hi Wayne, No, the shipping charge field is in the ORDERS table. Each record of my query, however, includes the shipping charge (it queries both the orders and orderlines tables). I think I may have found a solution, however. By creating a text box in the footer for the order ID group, and...

Hello, I suspect there *should* be an easy way to do what I want, but I am having difficulty getting it right. Here goes... Let's say I have the basic tables ORDERS and ORDERLINES. Each order can have many orderlines. Now, I've created a query that gets the following: From ORDERS: orderID...

Hello, I have created a report that will act as a calendar. It contains 35 unbound text boxes and 35 subreports. Each subreport is linked to one of the text boxes. Now, the idea is to populate the text boxes with dates upon opening the report. The subreports will then each disply the...

Thanks DBL, This is exactly the problem I wished to address. Your sample provides me what I need to get it going. I guess adding the extra textbox control to display the item from the second combo box is the best way to do it! It's not the prettiest thing in the universe (having the bound...

Hello, I would like to have two combo boxes on a form (in datasheet view), where the contents of combobox number two are determined by a selection made in combobox number one. I read the Microsoft article on this subject, which explains why combobox number two will show blank records when...

Hi there, I want to have the simplest of charts on a form, but am with absolutely no clue as to what I'm doing! First, here is an idea of what I want this chart to look like: Payable ********************** Outstanding **************** Received ****** I have a query that gets the 3...

Hello, I have placed a linked image in a report that previews and prints just fine on one machine, but does not appear on two other machines. The image is located in a specific folder, which I have ensured exists exactly as on the one machine where the image works. Other images, such as some...

Thanks for the help guys. I managed to solve the problem by rebuilding the form from scratch. I am now wondering if the Compact and Repair would have fixed it! Oh well, too late, I already re-did it. Didn't take too long, and all is well with the world again :-) Once again, THANKS! Ace

Hello, OK, here is my best attempt at explaining what is causing me a great deal of grief! I have a form, with a combobox and a listbox. Selecting an item from the combobox causes the listbox to be requeried. The query for the listbox contents needs the value from the selected item in the...

Jack, Works great! Thanks so much!!! Cheers, Ace

Hey Jack, Thanks for the speedy reply! This works fine, except for whole number values, like 2.00, 3.00, etc. I guess I didn't include that in my example. I've set the textbox format property to "fixed" with 2 decimal places, and this works fine, but only once it has lost focus. So, if I...