Search results

I am running Access 2003 and have created the following: Sub MSDeficient() Dim HoldMSComplID As Integer Dim HoldMNumber As Integer Dim HoldMName As String Dim HoldCourseID As Integer Dim HoldDeficient As Integer Dim dbObject As DAO.Database Dim...

I need some help and just can't seem to find the answers I am looking for. I am running Access 2003 and need to create a pie chart based on a count of data in a table. However, I just can't quite get what I want after hours of trial and error. I created the following 2 queries to count the...

I am using Excel 2003 and I am trying to optimize the performance of my workbook. The workbook has several pivot tables based on two separate source files. I am most concerned with 12 of my pivots and want to be able to reduce the number in half (6) to improve the speed of the refresh rate on...

FANTASTIC! That did it! Thank you soooo much!!!! :D

Paul, I hope you are still available to help me out here..... Its not working properly. I'm not getting several hundred thousand entries anymore but its not collecting the CheckItem or ResponseID data. Of course since the code does not tell it what that is I need to point to it, but I'm...

Paul, Thank you, I was thinking that might be it on my drive home. I will have to investigate it in the morning when I go back to work. I appreciate your patience with me this afternoon :)

D'oh....I'm sorry....I'm just not thinking clearly here.... Okay, I get it now...... But its still looping through 590,000 times (until I stopped it). How do I get it to stop at 10?

Is this what you mean by explicitly specify?: Do While Not MSAuditRS.EOF MSAuditRS.AddNew MSAuditRS.Fields("AuditDate").Value = HoldAuditDate MSAuditRS.Fields("SuprLink").Value = HoldSuprLink...

I get a compile error - Invalid or unqualified reference .MoveFirst is Highlighted when I comment out the With Block.

Paul, I really appreciate this and I am trying to grasp it all... but...:confused: So I get rid of these two lines: With MSAuditRS . . . End with But I'm not clear about the "explicitly specify each recordset" part...

Sorry, I'm really green with all of this..... :o So I add: Set MSAuditRS = dbObject.OpenRecordset(strQuery) Set MSHistoryRS = dbObject.OpenRecordset(strQuery2) With MSAuditRS .MoveFirst To open the record set.....(yes,this is the table with 10 records)...

So something like....? Sub MSAuditCheck() Dim HoldAuditDate As Date Dim HoldDateRange As String Dim HoldSuprLink As String Dim HoldAuditorName As String Dim HoldCheckItem As Integer Dim HoldResponseID As Integer Dim dbObject As DAO.Database Dim MSAuditRS As...

I am trying to pull together the following on my own and I got stuck. My usual support person is on vacation and I can't wait for him to return. Sub MSAuditCheck() Dim HoldAuditDate As Date Dim HoldDateRange As String Dim HoldSuprLink As String Dim HoldAuditorName As String...

I am using a continuous form bound to a table to record unsafe driving activites to a separate table. I have that module working. However, as the form is bound, it is more or less a place marker and I need to delete the data from one field in the table. I have tried to work out the module...

D'oh! I should have seen that!

Um, pardon my ignorance, but what do I want?

I am still pretty new to VBA and am having trouble compiling the following module. I get a "Compile Error: Invalid Qualifier" pointing to "HoldInputDate" and "HoldGLGroup" and "HoldGLGroup".....etc in the following section: .Fields("InputDate").Value = HoldInputDate.Value...

Thank you so much....it was the square brackets overall. Its working perfectly now.

I need some help in trying to create a balance forward field on a report. I am running Access 2003 and I want to be able to produce a report by employee number to show total "points" accumulated. I want the employee to be able to select a date range for the report (i.e. from the first of...

Thank you Bilbo...although I do not expect my company to move to Office 2007 anytime soon, if you could direct me to some information on cell references and editing the cells via VBA. I learn better if I can see by example.