Search results

So, why does the code in the error handler run only if there is a problem but the error exit code always runs? How does the compiler distinguish between the two? So, in this case, if I put the code to delete the querydef in the Error section before "resume exit" it would work and not give me a...

Hello all, I have a question about adding in code in the error handling. How does the error handling execute the code. For example, in the following code, I want to delete the querydef if there was a problem executing it. I understand that there are a million ways to handle this and this...

Me too! Thanks for all your time and effort!!! I really appreciate it! -Stoss

I did it!!!! Here was the trick to the whole thing. My problems had to do with how (and when) the where clause was executing. I put the where clause directly into the join statement and it works (as far as I can tell). Here is the new crosstab code (for those interested). TRANSFORM...

This is a sample spreadsheet of what I would like. I am hoping the visual representation will help. I have the Categories setup just fine but the rows ("Cars") are not. I would like (as seen below) for all the cars to show up all of the time. In this example, notice the last row where "Ford"...

As I was sitting here thinking about this issue. It seems to me what I really need is a union query. In other words, pull all the Categories from CarData.Category no matter what, and then pull the Categories from [Maint Trouble Calls]. Just not sure if this is even possible with a crosstab...

I was able to use the "IN" statement to get all the columns but..... Wish there was an IN statement for Rows as well!!!! -Stoss

At this point, I am so confused. I really am not sure what is going on anymore. I think I am just in a rut with my thought process. What I want to see happen is more of a problem with how I am pulling the data and what I expect to see, I think. Thanks for tying to help but I think this is a...

I did a lot of research looking for solutions to this and it appears that what I am trying to do is not even possible. I have all the categories in place by using the IN clause but for the rows, I think that is am out of luck. If you have any ideas I would greatly appreciate it but at this...

In the [Maint Trouble Calls].Category, there are a lot more categories than I want to be viewed. So, I want all CarData.Category to show up and only the [Maint Trouble Calls].Category that equal it. On one of the cars, it was showing up with <> in the column header (I called it category before...

That didn't seem to work. I mean, it works but it still does not pull all Cars and all Categories. On one of the Cars it has a category of <> I noticed that in the Where statement you have [Maint Trouble Calls].ID is Null. This field is never going to be Null because it is an auto generated...

Yes, same issue with Category. No, just Car -Stoss

There is a main "ID" (auto generated) field in [Maint Trouble Calls] but [Maint Trouble Calls].Car is a text field. Also, there is no main ID field in CarData and CarData.Car is also a text field. These 2 .Car fields equal each other (text that is). Thanks, Stoss

Sorry, it is the name of the car

Unfortunately, I inherited this DB :( so there are no relationships set up in this whole DB... [Maint Trouble Calls].Car has the same data as CarData.Car so I used an inner join to link those fields in the query. I think this may clear it up. I want all of the Cars listed down as the rows and...

I apologize, I think I may have misled you with the Null thing...forget that part for now and I will try and explain again. I have re-written this 10 times (err, 11 now) because I don't know how to explain....sorry. Try again, What I really am trying to do is have the Select statement select...

After looking at the select statement, I can see why I am not getting the correct data. I can see that I am only selecting the "Cars" from within the trouble calls. How do I get all the Cars listed and still maintain this query (query works great besides this detail). -Stoss

I have a crosstab query and I noticed that 1 "Car" item was not being pulled in. I know that this item does not have any of the required items (i.e. the categories are null) but I still want it in the list. I put a left join in thinking that it would select all Cars from the table. I must be...

Got it! Just made the controls transparent...duh! Thanks! -Stoss

Sorry, it is Access 2003. I did run into a problem though that I didn't even think about when putting the code in. Each row consists of 12 textboxes :( Trying to figure out a way around this but at this point, probably not even worth worrying about. Thanks for the help though! -Stoss