Search results for query: *

Hi, What I am trying to do is open a pre-formated Excel Pivot table in an ADP form but limiting the data depending on the user. The idea I have is to create an Excel spreadsheet with pivot table as a template and use a command button to open the spreadsheet, change the record source (using...

Oh and for more reference, I figured how to get my first set of code to work if you don't want to lose focus on another control when changing record. Like RoyVidar mentioned, ADO recordsets have a default local chase value of 200. Fortunately this is a property that you can change with the...

OK problem solved...sort of. I cheated and went a different direction. I used the docmd.gotorecord instead. Reason why I didn't try this before was because I didn't think it would go to the next record after I resorted the form but surprising it did. Selecting a field really doesn't do...

Yes I am using adp. With more playing around I think the problem is with the Sort function. After I sort the recordset to match the orderby value of the form, the bookmark for any records after 200 is invalid. I tried replacing: rst.Bookmark = frm.Bookmark with rst.find "ID = " &...

Actually I was wrong, it start going down hill at 200 records.

Hi all, I'm at my wit's end tring to figure this problem out and I'm hoping someone here can help me out. I created my own next, last, prev, and first button on a form that controls the recordset of a datasheet on a subform. Reason I did this is that I wanted the users to be able to move to...

Hi, Is it possible to create a link table to an external data source as a "table"? Reason is that I upsized a mdb db with many link tables and I want to build a relationship diagram in adp similar to it. Thanks in advance, t.t.

Simco & PBrown, Thanks for your suggestions, I for it working fine. Just for anyone else who might be doing this you have to have Multiselect OFF on the 1st combo box or it won't pull the value from it. Thanks again guys, Tri

Hi all, I'm trying to create 2 combo boxes that is used as a filter for a hotel inventory report. The first combo box is linked to a table with all our available destinations. I would like the 2nd combo box to show only hotels that are in the destination selected in the 1st combo box. I was...

Hi, I wrote a macro to read in all the txt files from a directory, format and convert them to and rtf format but when I run it it against a lot of files, it would randomly skip a couple. If I run the macro again the missing files would appear. Can someone please tell me how I can modify my...

CosmoKramer, I tried doing that but since the running sum is within the "Direction" group, doing a Over Group will reset the values before it is reference at the footer of the "Program" group. What I need to do is reset the running sum after the "Program" group.

Hi, I'm trying to make a report lists individual flights in "Detail" and sub totals only "outgoing" flights by month at the footer of every "program" group. The method I'm using to do this is to set a hidden text box for each month that does a running sum (over...