Search results for query: *

Thanks alot PHV, I took a look at that method and got it working ^_^

Hey, I've tried searching for an answer to this but the words I have to use in the query are too generic, "query" "variable" etc. As the title says, I can't manage to assign the result of a query (query result is a numerical value from using COUNT). Ideally what I'm trying to do is perform...

Ok, I found a solution in case anyone else runs into this problem. It's not the best solution, and kinda weird, but it works. I found that opening the query in access, AND THEN outputting it to excel stop the random error. DoCmd.OpenQuery ("ReasonANDYearQuery") DoCmd.OutputTo acOutputQuery...

The immediate window with ?CurrentDb.QueryDefs("ManOrVolQuery").SQL brought up this: SELECT tblCLIENTS.* FROM tblCLIENTS WHERE tblCLIENTS.ManOrVol=Forms![Monthly Report]!cmbManOrVol; Instead of .* it showed all the fields being retrived, but I thought I'd save post space. I'm going to look...

Aw man. Thanks anyway though, Hopefully someone has encountered this and knows how to deal with it.

It isn't used anywhere outside of the button click event. And no I'm not using macros.

I'm not sure what programatically is. I assume you're asking if its built during runtime. SELECT tblCLIENTS.* FROM tblCLIENTS WHERE tblCLIENTS.ManOrVol=Forms![Monthly Report]!cmbManOrVol; The "Forms![Monthly Report]!cmbManOrVol" is a drop down box with 2 values, MAN and VOL, which gets...

This one's a bit weird and hard to describe. On my forms (any form) when I select the criteria and click the button to perform this line: DoCmd.OutputTo acQuery, "ManOrVolQuery", "MicrosoftExcel(*.xls)", "\\fsss253001-w\ow\users\dsilva_k\KD LEAP Database\Test\SelectAllExcel.xls", True, "" Once...

Thanks for the help you two. I haven't tried that last post but it sounds correct. I would need to make an entry form for them as opposed to entering it straight to the table, but that's fine. I had hoped the AssessmentDate field had a After Update property, oh well.

Yes AssessmentDate is a date/time field with short date format. When I enter DateAdd("m",3,AssessmentDate) into the defaultvalue property, access autochanges it to DateAdd("m",3,"AssessmentDate") Not sure if that's an issue, but i'm just saying in case. It still presents the error when trying...

DateAdd («interval», «number», «date») I'm not sure what values it wants in the first two parameters. <<date>> I replaced with AssessmentDate. DateAdd («interval», «number», "AssessmentDate") I've put random numbers into interval and number but it wouldn't allow me to save the table design...

Hi, I want to base the value of one field (PAReviewDate) from another field (AssessmentDate). Where PAReviewDate would be AssessmentDate + 3 months. AssessmentDate already has values in Date/Time Short Date format. I've tried tinkering with DefaultValue property for the PAReviewDate field but...