Search results

i had a feeling i'd gone in a roundabout fashion - thanks for getting me straightened out!!! Sham

i have some code to empty a table before importing new data to it. DoCmd.OpenTable "Temp_Targets", acViewNormal, acEdit DoCmd.RunCommand acCmdSelectAllRecords DoCmd.RunCommand acCmdDeleteRecord DoCmd.Close acTable, "Temp_Targets" how do I conditionally delete, depending on whether the table is...

TIP: use the expression builder wizard.... Sham :eek:

are your combo values stored in a table? if so, you might try adding a number column, then have your query use the number column as the basis for the "between" - otherwise how does Access know what order the shifts come in... just a thought--hope it helps! :) Sham

thanks for the v swift reply kodo but that didn't work for me. however, i DID solve it - and using the Linked Table Manager too! selected all "problem" tables, check "always prompt for new location", when dialogue comes up enter the UNC path to mdb file and hit "OK". never thought it'd work...

i have a problem. i am using Access 2002 and a database in 2k format. the tables are linked to a database in 97 format. however, i have found that the paths are set with drive letters, and users accessing from other locations access different servers with the same drive letter, hence i need to...

silly me - should have read this: (not-so-nicely-presented) info from MS themselves found this from the Queries forum....

this might seem a really stupid Q but: I have one table of employees in an Access 2000 db. I have an (almost) identical table which is linked from a 97 ver db. For performance reasons I want my queries to use the non-linked table, but for compatibility (and other) reasons, i need the 97 table...

i don't geddit - but i tried it. no change. IIf(IsNull(Nz(Forms!FRM_Report_Chooser!ComboTeam)),True,Advisers!Team=Nz(Forms!FRM_Report_Chooser!ComboTeam)) HAVING (((IIf(IsNull(Nz(Forms!FRM_Report_Chooser!ComboTeam)),True,Advisers!Team=Nz(Forms!FRM_Report_Chooser!ComboTeam)))<>False)) after...

i've looked on previous postings about this problem and none of the proposed solutions seem to work for me. in particular I have tried those suggested here 59853 and here fontstuff.com can someone advise me on where i'm going wrong pls? :confused: PARAMETERS...

i feel really stupid now...and grateful! thanks a lot!!!! btw - I wonder why this has worked before WITHOUT me addressing the parameters..... Sham :o

i have done this before with simpler databases but i am working on a database with about 30 tables and as many simple/crosstab queries. i have a form with combo boxes, option boxes and listboxes. I have a query where I enter the criteria: [Forms]![Form_1]![ListMonth] where "Listmonth" is a...