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 SkipVought 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: *

  • Users: POKY
  • Order by date
  1. POKY

    Query Count True and False from multiple values

    hi Geekmomz I’m not sure if I understood your Q. so see and decide :: Add a Yes/No field to your table (in my ex. “ysnSelected”) Check it for “repaired” Then make a query like this: SQL = “SELECT YourTbl.YourField, YourTbl.ysnSelected FROM YourTbl WHERE (((YourTbl.ysnSelected)=True));” This...
  2. POKY

    Validation error

    Hi vasah20! i m not sure but try to divide the statement like this: SQL = "UPDATE engagement SET [Client ID] = 'tor400', [Job Date] = #2002-06-02 17:15:00 #, " SQL = SQL & "[Start Time] = #2002-06-02 17:15:00 #, [Contact Date] = #2000-12-05 00:00:00 #, [Confirmed Date] =...
  3. POKY

    Dynamically Change RowSource of Chart Object

    Hi Rob in "Detail" section (of report) choose "on format" event. i think its must work. good luck
  4. POKY

    Dynamically Change RowSource of Chart Object

    Hi is the event in "Format Section"? there it must be! poky
  5. POKY

    ..Expression too complex to be evaluated error in SQL

    hi1 divide the query like this: ssql = " SELECT M_HASIFDB.Relevant_Leader, M_HASIFDB.Date_Reported, M_HASIFDB.Originator, M_HASIFDB.Description, M_HASIFDB.Originator_Action, M_HASIFDB.Date_Entered, M_HASIFDB.Category, M_HASIFDB.Leader_Urgency, M_HASIFDB.Leader_Action...
  6. POKY

    Altering Crosstab Query Data

    hi check here: http://support.microsoft.com/support/kb/articles/Q209/1/43.asp and here: http://support.microsoft.com/support/kb/articles/Q209/1/41.asp and here: http://support.microsoft.com/support/kb/articles/Q210/0/04.asp good luck
  7. POKY

    ms query: report in form

    hi R U using ACCESS 2000 or higher? if yes you have the option "Conditional Formating" in the toolBar under "Format" menu. also you can use "circle" in reports - see more details on help/ good luck poky
  8. POKY

    Enter Parameter Value IIf problem

    hi not sure but try this: IIf(City=" & "'" & Naples& "'" & ", OrderAmt+DeliveryCharge+2, OrderAmt+DeliveryCharge)
  9. POKY

    Combo Box ?

    try to use the code behind the combobox in "OnExit" event. i did not understood "...down a REPORT//" DO YOU MEAN "Form"? any way good luck. poky
  10. POKY

    Returning a portion of a field

    try this in "BeforeUpdate" or "OnExit" event: If Right(DrugUnits, 3) = "/kg" Then [DrugUnits] = "kg" poky
  11. POKY

    Send e-mail from access databases

    hi tpower and all, i think this will help you. from: http://www.fmsinc.com/go.asp?298 =================================================== Tip #10: Late Bind Subforms on Tab Controls Provided by: Steve Clark, Senior Project Manager Now that Tab Controls are common in Access, it's common to...
  12. POKY

    Export Table into Excel

    HI TRY THIS I GOT IT FROM nathan1967 (form forums) DoCmd.SendObject acSendTable, "Coagulation", acFormatXLS, "drmotin@cuok.co.il", "eliahu@cuok.co.il", , _ "Current Spreadsheet of Employees", , False check the "SendObject" in help. poky
  13. POKY

    Send e-mail from access databases

    Hi nathan1967 u r realy GREAT!!! 1. can i send the form fields to execl the same way u did here???? 2. what about sending record after record to other row each time i move in form ?? thanks poky

Part and Inventory Search

Back
Top