Search results for query: *

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...

Thanks for the suggestion, I got so frustrated I took them off and ran a query on the form_afterupdate event. I thought I could do it on the field after_update event for a newly inserted row. (the one that was part of the where clause) but no rows were updated cause the value wasn't on the table...

Hi All, I have a sub form with text boxes that I don't want the user to see or fill it, but I will from the information on the main form. In design mode I set visible = false and they still showed. I then did it code with the visible and enabled property = false and tab stop = no. The boxes...

Hi All, to make my form user friendly I placed two command buttons on my form so the user can "filter by form" easily. The first button is neccessary as not only does it set the form to be a "filter by form" but it allows users to enter info in normally locked controls. But when the first...

Thanks, what threw me off was I had some combo boxes and text masks and when I entered the fields "stuff" happened - however the value can't be changed and its better than gray on gray so I'll use it.

Hi All, ACCESS 2000 Forms. I need to set enabled on and off on a form but it ends up with a hard to read gray background with gray text. I would like some other color scheme. WhatToDo, Thanks