Search results

that's the design , the union query works fine. i put the union query and any criteria in the second or outer query, and I get the QiTC error message. . . I used to be able to do this, or I have done this before, but in A2000. In A2003, i am not having fun. . . is this phenomina just...

I am now getting the "Query is Too Complex" error with a query, which has a union query which is attached to other tables, AS SOON AS a criteria is added to any field. As far as I can recall, and over 50, its hard to recall yesterday, I don't remember getting QiTC error messages with criteria...

good question, that i don't know. . .. lets see if that works sportsguy

On this one, I need help. . . the issue is date comparisons my company has a database which when run on my machine give the correct answer. I am running win XP, latest service pack, and Office 2003. The database is an Office 2000 database I can save the database on the server, and another...

How many rows can access handle? With one index, duplicates allowed, i have had access page locking issues over 7 million rows, 500 Megs in database size. . . there are limits. . sportsguy

anyone have any suggestions for getting around the error on the attached picture? thanks sportsguy

I have a double column report, 3 down the left and three down the right, Customer Name, Sales and Ranking (running sum over group on the number 1)and the rankings are of sales in descending order (of course) I have 130 locations, each with their own 108 Top customers, so each location's page...

thanks that's exactly what i spent 3 hours last night doing with that code. turns out that we use a standard offset of EST or -5h so I just have to use dateadd function, and I am all set. However, it still would be a cool piece of code to write thanks sportsguy

Nice coding challenge. What I would like is to take Zulu date/time, GMT, UCT date/time, and convert it to local date/time. then examine local time and adjust for daylight savings time. . . that way, I can get my fiscal close date and time correct. unfortunately, I don't know how to interpret...

I am not quite that good. . . Access hack. . . though I can key a table correctly. . If I can figure out whether a random date is within daylight savings time or not, then I can take GMT, which is provided, and back into the correct local time. . . I just can't figure out how this evaluates...

I know that it exists in our system somewhere, but its not in VBA. Anybody have that code anywhere? or know where i can get it? thanks sportsguy

Here is the code, the FOR loop is not recognizing the .EOF, it used to work correctly, now it doesn't. . what might have changed? Private Sub MassUpdate_DblClick(Cancel As Integer) upSQL = "UPDATE DATA INNER JOIN FORECAST ON (DATA.YYYYMM = FORECAST.YYYYMM) AND (DATA.Year = FORECAST.Year)...

That's what I was hoping to avoid, was having a string source in the code for each report, and swapping out the string source each time,because there is only one query, with different Top_values property for the recordsource query. I would the have to parse up the string query by report to...

Added Sample Record yes, I do it all the time. The way that I have all my tables set up is by Fiscal Year Fiscal month, since my fiscal year ends in September. So all my tables have a field YYYYMM, since the dates are not the same year over year, nor do they equate to any particular calendar...

yes, I do it all the time. The way that I have all my tables set up is by Fiscal Year Fiscal month, since my fiscal year ends in September. So all my tables have a field YYYYMM, since the dates are not the same year over year, nor do they equate to any particular calendar dates. So in your...

SQL string saved in the report That makes it a bit more complikated, i realize thanks sportsguy

I have a good one for the MS Access masters of the web site: I want to open a report from a button, and if the report is opened from Form A, the report query must have the Top Values parameter set to 25%, and when i open the report from another form, the report query must have the Top Values...

Hmmmm ah, I am using the ORACLE ODBC driver. . . no, the records are there, as I have had the DBAs check. . . which MS ODBC driver are you using? thanks sportsguy

Overflow! (nevermind!) thanks sportsguy

Its the Check Boxes ! its very simple to copy and paste, I have the yes no fields correct in the database its the check boxes that I want to show up on the excel spreadsheet, not TRUE / FALSE. . . sportsguy