Search results

I am having a problem with a pivot table in Access. When the table changes. The pivot table continues to show old data. Is there any way to Refresh the pivot table without going into excel to do that? Thanks!

I am currently am using the 'QueryDefs' command to create a query and gather the desired results. It is working fine. What I do want to do is every time I establish the 'QueryDefs' not only populate the query to be created (which it is) but insert the criteria into a table so I can later keep...

Hi All, I have a table of about 13,000 records. These 13,000 records will change on a weekly basis. What I am looking to do is create an export module that will export these 13,000 into groups of 2000 records. In this case, I would have 7 files. Is there any way to do this in Access. Thanks for...

I have an Auto Dial button on a form and when pushed the Auto dialer pops up and a person can enter the number. Behind the scenes I am keeping track of the number of Phone calls a person makes. The draw back is regardless if they hit OK or Cancel on the Auto Dialer, It is adding another count to...

I am having trouble selecting Date() from a field that also has time in it. Is there anyway to use the date function (or similar) to accomplish this select? Thanks!

I have an unbound combo box, which queries student names from a table. After the student is selected, It Finds that student record in the Database. The weird thing is that it works fine on my computer. (Development) But when the database is moved over to some of the end users, it is very...

I have a main form. On the main form I have a command button that luanches the auto dialer. What I am trying to do is when that button is pressed. Update a Activities table with USERID, date, and Personid. Not sure how to do this. It is a way for me to tell who has made calls and when. Thanks...

I have a main form 'TS PM Filter' and a Subform 'getcurrentusers' On the subform, I have a number of fields including 'Personid'. What I am trying to do is when the 'find record button' is pressed(on subform) the main form opens and finds the 'personid' from the subform. Below is the code I am...

I am trying to create a match code for my Company field. What I am trying to do is make a match code of all characters in the company field except for Vowels. Any help would be greatly appreciated. Example. Company Name=’ABC INC’ Result would be ‘BCCNC’ Thanks

Hello, I am having trouble adding notes to a subform. Basically, I want a command botton on the main form and when pressed takes the cursor focus to a subform (Subform is called 'Notes') and the Field is called 'Notepad' Any suggestions would be a huge help!