Search results

Wow, this is exactly what I am trying to do. I have not done a Crosstab Query. Let me read up on Crosstab and play with it and then I'll get back with you. I'm feeling pretty stupid right now creating all the total queries. Boy 'o boy a half day waisted. I need to take a lunch break and...

tlkpEventType is the same as Activity (different wording in different table). No, I didn't know that. But I just tried it and it comes up blank. Meaning, I put Field = CompanyID.....EventTypeID.....EventTypeID..... EventTypeID Table =...

Total query. Total for each activity.

Thanks for responding The_Doc_Man, Actually, I copied this code from here--I thought I understood it, but apparently I don't. Yes, everything is coming from the Event table. Locking parameters--Optimistic locking? Where do I find this? EventType is integer. (I think that's what you're...

Error 3188 -- Couldn't update. Currently locked by another session on this machine

If I am understanding what you're saying, I was doing a query for each activity--e.g.: Field = CompanyID Table = Event Total = Group By Field = ActivityType Table = tlkpActivity Total = Count Field = ActivityID Table = Event Total = Group by Criteria = 23 But, I was wondering would that be...

I am using the below code to fill some information. I keep having write conflicts and Error 3188 with this form; therefore, I am wondering is there a better way of getting this information? Private Sub Form_Load() Me!txtAuthorizations = ActivityCount(1) Me!txtAttachments =...

So, you're saying if Interviewing, Meeting, and Training all have entries, it will work--but, if not, it will not work? Yep, subreport--because basically I want the totals and then a list below. My biggest issue is understanding the query on query joining. For reason I keep thinking daisy...

jzwp22, thanks for the suggestion of If Null...

Okay boblarson, Reading Access 2007 Inside Out, page 424, it joins different. Going by it's example I should join: 1. join CompanyID from Event table to CompanyID in qryTotalInterviews 2. join CompanyID from qryTotalInterviews to CompanyID in qryTotalTraining 3. join CompanyID from...

Well, I just had a thought. Maybe I can put the totals in a separate form and add them as a subform to the form with the Event detail info. Getting totals this way, is better than using DCount?

Okay, I see. So, you have to join CompanyID and EventType from the queries to Event.

They looked the same.

For some reason I can't download Bob's db to see his solution.

No, I couldn't download it. Meaning, I got Windows cannot open this file. ... use the Web service to find the correct program...

Thanks jzwp22, That's what I wanted but I also wanted the EventDate, EventTime, EventType, and EventStatus. So, do I add the Event query or table?

Hello boblarson, for some reason I can't open the db now. I saved as Access 2000.

qryTotals -- I am trying to display the total number of fields, so I built a query using other queries, but it is not totalling correctly. I want: 1. Total interviews per company 2. Total meetings per company 3. Total training per company along with other information. Do I join the...

Now that make sense. So, Is compare one object against another. Thanks lagbolt!

I am trying to check for Null, but I keep getting Error # 424 (Object Reqd.). Below is the code: If (Me.NewRecord = True) Then Me.lblImage.Caption = "Add Attachment (y/n)?" Me.cmdImage.Visible = False Me.txtYesNo.Visible = True Me.txtYesNo.Left = 2438...