Search results

How would I use that code in a function? I don't think I could use me. Also I'm not sure how to use recordcount. But this is a good start.

It Worked!!! I read somewhere that listboxes were not a prefered usage in a report. Thanks everone for your help. Everything from this point forward is extra credit. All hail SUBREPORTS!!! (I am such a loser)

How would I create a subreport?

I can't figure out how to write that code. I tried this: Private Sub Report_Open(Cancel As Integer) DoCmd.RunCommand acCmdPageSetup End Sub But I get an error. I am not very good at coding either. Although I don't think this print data thing is the solution. I am willing to try...

if so, I just turned off the print data only and it disappeared for a one record. The next time I went to a different record the same problem happened again. Another weird thing I noticed was that if I move the box to different parts of the header the box borders will change randomly.

are you refering to the page set up?

Have you found anything?

I'll post a A2K copy. here

Here is the DB, press F10 to open the report. Thanks for you time, JOe K.

I made sure the special effect property is "Flat", still no change.

It's referencing a query of cost allocations, so if I buy 3 $1 items and 2 goto Consumable Tools, and 1 goes to Small Hand Tools, How do I get it to display $2.00 Consumable Tools and $1.00 Small Hand Tools through a text box? There could be any number of cost allocations: Reg Mat, H&S Mat, H&S...

I actually need to keep it a list box, I have to display an indeterminate amount of columns in the header. I tried with a text box but can't get the textbox to display all of the values it will only display one of them.

I searched the forum and only found something kind of relating to what my issue is. I have a report which contains a list box there is a border around it, I have set the border style to transparent and it won't disappear. Is there any way I can just have the data displayed with no border...

I have a query that has an Item, ItemPrice, Allocation, and DatePurchased ordered by DatePurchased with only unique values. I'm using it for a PO Database, when entering items purchased, I have the Item field populated with a items previously purchased, when the item is selected the Unit...

I have some send keys F3 and F4 to move to next and previous record, what I'm trying to do is when on the first record I want to disable or not run the macro to goto previous record. The same goes for the last record, I want to disable goto the next record if I'm on the last. I tried making...

I have and Owner name and a tenant name in a report. Is there a way where if the tenant name is empty, I can rezise the owner field to encompass where the tenant field would have occupied, if it was not null? I can make a macro to make the tenant field invisible, but I do not know how to...

I have a DB that has a field homeowner name. The Owner name is <Last name>, <First Name>. Is there a way in my report to only display the last name, like an input (or output) mask? I tried to format it "*, " so it was wild card and then when it ran into the comma it would stop and only...

I have attached a database which is an example of our work in progress. What I am trying to accomplish is when I enter a job number in a text box, a corresponding Owner name and tenant name will be displayed in a text boxes. I have an example linked table in the database and will link it to...

Did you ever find a solution to this? I am having a similar issue where I want to check the number of specific audits done in a month over a quarterly report. Using D-Count I can conditionally count the total number of single unit audits (SFR - Single Family Rentals and OOC - Owner...

I just realized that my report is not duplicating the details table, it's displaying a details section for every record that is in the query. Therefore, if the query has 47 jobs in it then the details section of the report will be displayed 47 times. I'm going to have to modify the query. I...