Search results

I am going into the forms tab and using the 'Pivot table wizard'

The Pivot table (which I created under the forms tab) runs off a table. So there really isn't any way to rerun the query. I even changed the data source to a query instead, but it gives me old data. The only way I can refresh it is to open excel and refresh data manually.

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!

Sub SelectionCriteria (ListName As Variant, FieldName As String, MyCriteria As String, ArgCount As Integer, frm As Form) Dim strIn As String, i As Integer, strJoinType As String strJoinType = "" ''ArgCount = 0 If ListName.ItemsSelected.Count > 0 Then For i = 0 To ListName.ListCount -...

To answer your first question, that is correct, I am using a dialog box with options. I like your idea of the two level approach. This is how I am setting my querydefs. Dim ArgCount As Integer Dim MyDB As Database, qdf As QueryDef Dim strSQL As String, MyCriteria As String, flgAll As...

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...

Thank You!!! By Converting the Date/Time, I was able to select by date()

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...

Thanks Doc Man I seem to bet getting an error of 'Type Mismatch' and I cannot figure it out. Below is the code. Thank you! Private Sub Command65_Click() Dim rsLog As Recordset On Error GoTo Err_Command65_Click Dim intstart As Integer Dim stDialStr As String Dim PrevCtl As...

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...

Thanks Fornatian!!! That worked

Thanks Fornatian. Just two things: It prompts me for the personid? Not sure how to get rid of it. Also, it actually filters the record on the main form. Is there anyway to autamically turn the filter off Thanks again for your help!

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...

Thanks Fornatian!!! Worked like a charm. you are the best!

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

Hi Tim, I altered the code a little to get the date/time stamp. The only thing left is that the whole field is highlighted. Any suggestions? Thanks Again Private Sub Command50_Click() Dim intstart As Integer Dim strNotePad As String Me.Notes.Form.NOTEPAD.SetFocus If Not...

Hi Tim, I altered the code a little to get the date/time stamp. The only thing left is that the whole field is highlighted. Any suggestions? Thanks Again Private Sub Command50_Click() Dim intstart As Integer Dim strNotePad As String Me.Notes.Form.NOTEPAD.SetFocus If Not...