Search results for query: *

lol...I SWEAR I tried that earlier and it wouldn't do it! Thanks so much!~

Sorry...here it is... Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("Actual Sheet").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("Complete-Statistics").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("Cumulative...

Because today is Friday and technically my last day here, of course my macro needs to be re-written for an update from excel to access. I have it done, except I lost my close excel at the end, and I cannot figure out again how to make the application close after running the macro. Any help is...

Thanks!!! That was the problem....you'd think after staring at it for an hour....lol Thanks!~

I have looked at the previous posts and have this currently: Private Sub Command33_Click() Dim stAppName As String, stFile As String stAppName = "c:\Program Files\Microsoft Office\Office\excel.xls" stFile = "f:\Proposal Database\Statistics Complete Pages.xls" Call...

Well thanks to no help here...I figured out the problem... Thanks Again!~

TRANSFORM Sum([11- Awarded Proposal Value Sum Crosstab].January) AS [Total Of January] SELECT [11- Awarded Proposal Value Sum Crosstab].Expr1, [11- # of Proposals Per Month Crosstab].[Total Of Est Value], [11- Statistics Total Proposals Amount].[Total Of Est Value], [11- Pending Number of...

I have a query that works fine in Access 2000, it works fine in the form.... But when I try to save the query or form as a report AND when I try and just create a report from the query I get the Object Invalid or No Longer Set error....I have looked here...microsoft...and other places, I...

Can anyone tell me what this means? I am trying to add a query from Access to Excel... Thanks!~

I am trying to import a query into Excel from Access, When I select the Query it gives me this message: String Data, Right Truncated on Column Number 4 (Column_Name) Then after I go through all of the prompts it gives me this message: Object Invalid or No Longer Set I have shortened column...

Nevermind....I have come to my own conclusion here Oddly enough after much thought....all I did was add a column inbetween every month and add them....in my crosstab. So, I have resolved the problem...thanks

Can you clarify what you mean by a summary query? Thanks!~

Again Jonfer I have tried your methods, and they put things neatly in order by year and by month but how do I get a cumulative total: This is what I end up with in the sql, as there were some errors: SELECT a.EnterYear, a.EnterMonth, Sum(b.["EST VALUE"]) AS ESTVALUE FROM [11- Monthly Totals...

Here is what I have now: SELECT Months.thru, SUM([EST VALUE]) FROM (Months LEFT JOIN MonthlyTotals ON (text Monthly Totals Query.EnterMonth) BETWEEN '01' AND Months.thru GROUP BY Months.thru WHERE Monthly Totals Query.EnterYear = '2000' It gave me the Syntax error again until I added a...

SELECT Months.thru, SUM([EST VALUE]) FROM Months LEFT JOIN MonthlyTotals ON Monthly Totals Query.EnterMonth AND BETWEEN '01' AND Months.thru GROUP BY Months.thru WHERE Monthly Totals Query.EnterYear = '2000' It made me put the AND above in the expression, then it gives me the: Syntax...

Jurgen - I just finished a similar problem, but all of my data was unrelated. I created one Cross Tab for Awarded and one for Lost, then added the Lost Cross-Tab to the Awarded and linked the EnteredDate. Then saved and made a third Cross-Tab from that one. Here is the formula I used to do...

I have the following SQL, it is supposed to make Januarys total add to februarys and show in february, then add februarys field to marchs total and put that in marchs field. If it is putting them all in order but I am not getting a running total I don't know what I am getting. The numbers are...

Hi - I am looking at purchasing the Dreamweaver MX to create a personals website like www.match.com Because I don't know much about the software I thought I would post on here and see what your feedback would be on the software and creating a database backend for it. Thanks~!

Well, it was a pain but I kept the format and just changed the column headings in my form.

Hillary I'm sorry if I wasn't clear enough I did add the button on the Main Switchboard, I just called it main form above. When I do this and press the button on the Main Switchboard it is not opening or doing anything. I'm beginning to think my Access has a hiccup. Here is the table that it...