Recent content by rust

Hi PHV It didn't work. My situation was slightly more complicated than originally shown. I keep getting ACCESS doesn't recognize [tblA].[gYear] in query one when running from query 2 Even though query1 works fine as a stand alone. That's why I ended up storing to a temporary table. There is a...

Thanks

I can't thank you guys enough - middle of the night and poof an answer pops out. I'll try your idea, though I may be ovelooking something, it looks like I loose the aValue in the row. The result has to look like: ItemID 1999 2000 2001 sum(W1*aValue) sum(W2*aValue) 1 30 20 10...

False Alarm sort of I had a Query which did two things - filtered on the useit flag and also joined table A with table B which got the appropriate W1 and W2 so the query results looked like: ItemID Year aValue W1av W2av 1 1999 30 3 6 1 2000 20...

This should be a lot easier than the way I'm doing it. my begining tables look like ------------------------ Table A Arowid ItemID Year aValue useit 1 1 1999 30 true 2 1 2000 20 true 3 1 2001 10 true...

out of phase ment that I replied to my only problem - that I found a fix and by the time I sent it - wonderful people were responding. just a note when I used &[Page] what I saw in excel was Page] the &[ in the beginning wasn't there. So I figured to be clever I would double up on the &...

Hi Skip, we are out of phase with each other - thanks for the help - I really appreciate that there are people out there ready to respond right a way.

sorry was too hasty if I use just the "&D" it works accept it takes along time for the excel sheet to load from excel? but when I directly to print without seeing the sheet on the screen everything is there? So I tried using &[DATE] and that didn't work at all

I'm formatting an excel sheet from Access - works OK accept the footer needs the &[PAGE] and &[DATE] command When I send it just shows the words but doesn't fill in the PAGE or DATE Dim objXL As Excel.Application Set objXL = New Excel.Application With objXL.ActiveSheet.PageSetup .CenterFooter...

Thanks - just for the others that might have stumbled on this - though it may be interesting how to get access to put controls on excel. For the time being I figured I will tell the client a drop down validation box is just as good and simple to do - see PHV's link - at a less rushed time maybe...

Hi PH Thanks for being there. You were close but your solution was actually funny - it put both choices into the cell!!!! Being I was now awake I used the record macro which ended up working: With Selection.Validation .Delete .Add Type:=xlValidateList...

I am exporting an Access table to Excel which will be emailed to the users. It will have a true false column. For the ease of the users I would like to include a validation list will the export so rather than typing in true they can click the little combo box that excel creates with the...

Well thanks for the thought, but the deal is the ACCESS Application is outputting an EXCEL file which will be emailed to users. They will change specific Falses (or No's) to True (or Yes) and then email it back. At this point I do not want to restrict my situation to a check box - I will accept...

I need to export the results of an ACCESS query to an EXCEL spreadsheet. Right Now I'm saving the results of the query to a temporary table and using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tTempTest", "C:\Test.xls", True Works OK accept there is an ACCESS YES/NO Field...

I tried that I get you can't assign a value to this object (for this test in the first button click event) DoCmd.DoMenuItem acFormBar, acRecordsMenu, 0, 3,acMenuVer70 cmdClose.Enabled = True Maybe I'm not quite doing the make form query the right way as strongbad might say Me HEAD ES PLODE...