Search results

I get Runtime Error 13, Type mismatch. I'm think I'm going to have to post up my db. I've got a buddy who works with code, so I'll see if he might be able to look at it this weekend. All 3 of you have gotten me way beyond where I was and I appreciate it very much! I'll check back after the...

Bob, I get an error on strWhere = Left(strWhere, Len(strWhere)-2 & ")" above. It says expecting operator in the code builder. If I put a parenthesis on it the error when running the command says mismatch. I'll work on creating a copy of the db with sensitive info removed to post next week.

That's a great idea. I may do that if I can't get this nailed down pretty quickly. I will try this in a few moments along with Bob's suggestion next.

I suspect you're exactly right on it being somewhere in the sorting and grouping; I didn't even look there. My reports work without the form, but when I run the form I get no data. Would youlook at my code and see if I'm forgetting something: Private Sub cmdReport_Click() Dim strWhere As...

Spectacular! That got me past the parameter popup. Now I just need to figure out why my report shows #Error instead of results.

I would be embarrased for anyone to look at this awful excuse for a databse :D Apart from that though, it does have some company information and I haven't set any security settings since I'm the only one currently using it. I'm pretty sure it's due to this Cost Center field though. I can't...

This may be something I did. I had a field called Cost Center instead of it being CostCenter, and when I changed it this started popping up when I run the report. I must be missing the field being updated to the new heading somewhere.

Yeah, that was the first thing I checked. Debug returns the error on the last line of code: DoCmd.OpenReport "rptSummary", acPreview, , "CostCenter IN(" & strWhere & ")"

Almost there now! Thanks to Paul, Craig, and Bob. I am getting an error when running the report though. My query is based on a date criteria. When I click my run report button, the date criteria pops up as usual (2 popups, one for start and one for end), and then a criteria box pops up for the...

I did, but here's where I get lost on due to lack of coding knowledge: If Me.lstEmployees.ItemsSelected.Count = 0 Then What is the 'Me'in that line. I see '1stEmployees' is the list name on the form. Then it looks like I only need to switch the report name to open and the field of the query...

Craig. In the above code, would I need to fill in the 'selectedvalue1' in the SQL manually with my choices in the list, or is this where the looped code would fill it in automatically? My goal is to create reports from a query, filtered by what's in the multi select list.

I'm sorry, let me clarify that 1st question a little. I tested this with two queries. If I select just one entry from the multi select list, and use that as a criteria for a query that pulls from one table, it works. I know it won't work once I select multiple values without coding. But still...

Hello, I need major help with multi select list boxes. I've researched for hours, but am stuck on two things. #1 - One of my queries (that leads to a report) is a combination of fields from two related tables. For some reason, the multi select box on the form I created always returns null...

I thought I may have better luck posting this in here. I've got a report that lists monthly charges, based on a query with a date parameter, and is sorted by department. I am not very familiar with coding at all and am trying to figure out how to send each department's charges only to a...

I finally got the union query working last night! I figured I would post this question here though instead of creating a new post somewhere else. My goal is to create separate reports that I can send to the managers of about 15 departments. I'd rather not create 15 reports, so I figured using a...

I've been messing around with a Union Query for the last 30 minutes or so. The problem is my two queries don't contain all of the same columns. And I still seem to be running into Access either matching the date or the credit amounts incorrectly. *To clarify, my queries pull the following...

There has to be an easy answer staring me right in the face, but I can't see it. I've got two tables: one for charges, one for credits. Both tables are updated on the 15th of the month with new charges or credits with a listed mobile number. I need to run a report each month that includes the...

Glad to hear I'm on the right train of thought now :) This is all starting to seep in.

Okay, another question related to this. To recap, I created 1 linked table with active user information, and 1 linked table with monthly invoice charges. The wireless number field in the active users table and monthly invoice table is joined. Some of the wireless numbers on the invoice though...

Great, thanks again. You have been tremendously helpful.