Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Spydermine

    Assign query result to a variable

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

    Assign query result to a variable

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

    SQL Queries Dissapearing

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

    SQL Queries Dissapearing

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

    SQL Queries Dissapearing

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

    SQL Queries Dissapearing

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

    SQL Queries Dissapearing

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

    SQL Queries Dissapearing

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

    Setting a field's default value based on another field

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

    Setting a field's default value based on another field

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

    Setting a field's default value based on another field

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

    Setting a field's default value based on another field

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

Part and Inventory Search

Back
Top