Search results

This is the query UPDATE ((tblARank INNER JOIN APPLP2_V_CAS ON tblARank.VIN = APPLP2_V_CAS.VIN_NO) INNER JOIN APPLP2_V_CAS_CLM ON (APPLP2_V_CAS_CLM.CAS_ID = APPLP2_V_CAS.CAS_ID) AND (tblARank.WARRANTY_CLAIM_NUMBER = APPLP2_V_CAS_CLM.CLM_NO)) INNER JOIN MasterListCollection ON...

Yes, I did. No luck. My next step was to save the results as a table, then query from that using the criteria. That works, I was just curious why the first was giving the error message.

I have a query that pulls data from a number of tables. My manager has asked that I add a field, using data from a function he created (copied?) years ago, which calculates the number of work days between two dates and returns this as a LONG number. I should add that this function is used...

Okay, not ideal as I'd still like to understand how to format labels on the fly, but I was able to get it working by adding an extra field, using DateSerial, and displaying that instead of the old. Thanks to all for helping.

None as far as I'm aware, that's just how the data arrives. We only use the monthly totals so, at some point, someone requested that the data comes in that form.

The report and the graph are created fresh each time the code is run. If it was a permanent report it would be different.

Thanks Thanks for the response. Yes, the source query is as follows strSQL = "SELECT Format(Left(MonthName([SalesMth]),3) & ' ' & Right([SalesYr],2),'Mmm YY') AS Mth, Shipped FROM " & strTable & " " & _ "ORDER BY [SalesYr] & [SalesMth] Desc;"...

Thanks for the response. Do you mean format the TickLabels themselves? If this sets the font size .Axes(1).TickLabels.Font.Size = 6 What would be the syntax to format them as dates or strings?

Sorry, I read 'Yes' and I saw the band logo in my mind. It's not as if I never hear the word in any other context, but that's the first place my mind went.

I have a report that's generated using VBA. The underlying data source is correct and if I open the report in Design view then look at the datasource for the chart on it, the records all appear as expected e.g. Jan 20 Feb 20 Mar 20 These are text values, created by taking the first three...

Which prog rock band didn't get a UK number one album with Tales from Topographic Oceans?

Thanks. I'll suggest this to the team responsible.

Firstly, I'm not sure that 'Modules and VBA' is the correct place for this question, but it feels the most appropriate. Our company recently upgraded to Office 365. However, we still use Access 2010 because of this ongoing issue...

D'oh, that makes perfect sense. Thanks a lot.

I'm trying to make sense of some old databases. Each has a large number of tables and forms I'm sure aren't needed any more and I want to get rid of them. The Object Dependencies tool is useful but, given the hundreds of items I'm checking, slower than I'd like. I found some code to search for...

Thanks for the replies As is often the case, writing it out clarified some ideas for me and it's now working. The problem was caused by using LIKE to do the matches on the sorter part numbers. In those cases, I should have been comparing each to the section of the entered value using '='. For...

I have a table of criteria, one field of which contains part numbers, these can be any length from 1 character up. The lower the number of characters, the broader the range of items the part applies to. For example: 12345 might be a specific part from a machine Parts starting with 1234 might...

Thanks all, finally got something working. As Doc_Man said, the hardest part was proving to those in a position to fix it that there was a problem (and whose responsibility it should be). After sending the IT team a lot of sample data, where I'd run comparison tests, they finally agreed there...

Thanks all. I've managed to get a dedicated resource from the technical team to look at this, this week. I did some benchmark tests using various combinations of C, P and Q drive and was able to convince them that a problem exists. Will post whatever we find.

Sorry, I explained that poorly. The two options are: Front end back end both on new server Front end local, back end on new server Yes, I figure now someone has built it he has his name attached to it, so he'll want it to work even for selfish reasons.