Search results

I have reports which all rely on one query. The query looks something like this: ID VolumeA VolumeB VolumeC VolumeD Now, I have four separate reports. ReportA is filtered to bring back all lines that VolumeA <> 0. ReportB is filtered to bring back all lines...

Thanks. I guess that's one work-around. :)

Problem: I have a table with records that I would like my form to navigate through by date. My table looks like this: 1. 7/2006 2. 4/2006 3. 11/2006 4. 1/2006 When I open my form, it starts at 7/2006 and if I click "Next Record", it goes to 4/2006, and then 11/2006, and then 1/2006. I would...

:( That sounds much easier and sensible. Thanks!

Sorry to be such a newbie, but how do I get them to merge multiple reports into a single PDF? I feel like the information is there but I'm just reading right over it. :(

I have Acrobat PDFMaker. In Access' file menu, there is a menu called Adobe PDF and under it, it allows you to merge multiple reports into a single PDF file. How can I create a button that can do this? Thanks in advance.

Thanks so much! That worked like a charm. The first line, I don't need because I already have it in the form's properties... I wonder if there's a similar field for FilterOn? But, really, thanks again! You have no idea how much this helps me. :)

At this point, I don't think it's a matter of if the filter's working or not.. The filter apparently works. It's just that the filter is not being applied automatically. Is there a code that I can put in the Form_Load to apply the filter?

Okay, another update. When I go to the menu at the top and click Records->Apply Filter/Sort, it attempts to apply the filter. How can I get it to apply the filter automatically when I open the datasheet form?

When I look at 'Allow Filters', it says Yes. This is really frustrating. :(

I tried running the datasheet form without having frmWhatever open and it does not give me any errors whatsoever. This tells me that the datasheet is not even attempting to filter anything. Hoping for help, thanks.

Okay, I have a datasheet form. The source is TableData. I want it to be filtered by date. The date is found on a separate form in txtDate. So here is what the "Filter" property looks like: ((TableData.Quarter=([Forms]![frmWhatever]![txtDate]))) Now here's the odd part. When I initially...

So my database is nearing completion, and things are looking great. Tables, queries, forms.. But I've got a weird problem for my reports. To make my reports easier to read, I drew lines to create a grid. The lines are hairline and are gray. When I print my reports to the color printer at my...

Okay, I'm thinking I may just have it check on Form_UnLoad to see if the value in the field is also present in the lookup table. Can anyone help me with this? For example, the data entry form uses the table TableSales. TABLESALES Product Sales A 2000 B 4000 C 3000 Df 2000 E 7000 I want...

Okay, I'm thinking I may just have it check on Form_UnLoad to see if the value in the field is also present in the lookup table. Can anyone help me with this?

Okay, I've got a related problem. While limiting it to the list works if the person tries to type in something, if someone paste appends records (i.e. from an Excel file), it still allows items that are not valid values in the listbox. How can I remedy this situation? This is important as the...

..oh gees. Thank so much!

How to force someone to use a value in listbox in datasheet view? [NEW Problem] This question seems so simple, I feel like the answer is right in front of me. However, I have no idea how to solve this problem. Essentially, I have a field in a table (or data entry form in datasheet view) that...

Thanks for the tip. However, as far as I know, you can't put controls onto a form that opens up in datasheet view. :( I was wondering if there's a way to hijack Ctrl-V and make it paste append?

As for temporary solution: Instruct user to either: 1) Drag it into Access from Excel. 2) Pick Paste Append from the Edit menu. Just looking for ways to make it more user friendly is all.