Search results

I'm having a duplication issue that I just can't figure out. Basically my report & subreport are pulling a previous contributor list. What I need is for each instance of paid history to be grouped by the phone number and then the whole shebang sorted by date of the last sale. This is mostly...

Cancel=True worked perfectly! Thanks!

Hello. I've got a macro that opens 10 reports each day and prints them. This works great when all 10 reports contain records. Sometimes though there aren't records in a couple of the reports. Is there a way to filter this so it just skips them instead of giving me a popup error? Thanks!

I swear access is so bizarre sometimes. I've changed nothing and now it suddenly works again. I had about 250 pages print out yesterday with about half of them missing Custom10. I really don't get it. Anyhow, I seem to be all set, thank you very much!

Uh oh, I noticed a strange side effect... completely confused as to what is happening. I have another field Custom10 that simply pulls and prints on the report. The info is in the table, and it shows up in report view, but when I print or look in print preview, this particular field sometimes...

That works! Well, it doesn't work in report view but in print preview it does. Many many thanks!

I use barcodes in mine and just use a code 39 font. 39-notext. It outputs as a scannable code, I never see it as readable numbers.

I think I managed to strip out enough. I'll send a PM with a link.

Not really. Its a pretty large database.

This is what I'm using but it simply isn't working. In print preview mode, it is pulling the image on every record, regardless if Custom4 is null or not. In Report view, it doesn't show at all. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Nz([Custom4], 0) = 0 Then...

I'm not sure what you mean by image control. I assumed that was the name of my image, but that doesn't work. In Report view, it doesn't show. In Print Preview view, it shows on every record.

An image for each record meeting the criteria. I essentially want to print a CREDIT CARD PAID type of image instead of having to go through and stamp a bunch every day.

Hello. I'm trying to do what should be easy, I just don't know how to do it. I've got a report that works great, I just need to add in an image that displays under the condition that a field has info in it. To be specific: if FIELD1 = "PAID" then my image IMAGE1 will display if FIELD1 is...

Close, but not quite. I'm focused on the collected date. I need single time donations only within the timeframe, and nothing else. Begins and ends before range - we don't want RIGHT Begins before, ends during - we want this one RIGHT Begins and ends during - we want this one too RIGHT Begins...

Hello, I'm hoping you guys can help me out with what seems to be something easy in theory, I just don't know how to do it. Let me start by saying I'm pretty new with access, I know how to edit some things and do some basics, but I don't know all the syntax and the ins and outs. Example of what...

When I use: Me.PledgeAmountRecd.Requery Me.DateRecd.Requery I get: Compile error: Method or data member not found EDIT: I got it! What was happening was when I went and viewed the property sheet, the Name was actually different than the Source Object. The person who created this database...

What I'm wanting refreshed is both tblPledgesLead!PledgeAmountRecd and tblPledgesLead!DateRecd. So if I'm understanding correctly, I should have Me.tblPledgesLead!PledgeAmountRecd.Requery Me.tblPledgesLead!DateRecd.Requery This gives a runtime error 438: Object doesn't support this property...

Hm. This doesn't seem to work. This gives me an invalid arguments error.

Bump. Any idea on how I could get this to show up right away?

Alright. I've got it to do what I want. It copies the amount, adds in the date, checks the box, and puts the cursor where I want it. However there's a strange side effect! The info is being put into the correct boxes and everything, except it doesn't display until after a refresh! i.e. I have...