Search results

  1. C

    populating a list

    hi, I'm using an append query to copy some values into another table, the problem I have now is setting/updating a field to a given value in the same table I'm copying to which is blank after the append action. Could someone please point me in the right direction in how to set the values of 1 or...
  2. C

    delete query on a form

    thanks :O) just sticking the basic delete in there worked, i think because I was trying to use the wizard, the wizard may have been putting superfluous code in there somewhere. thanks again Chris
  3. C

    Deleting Records PopUp Form

    you can disble the MS Access warning with the following 'Turns off the Access warning messages DoCmd.SetWarnings False 'message box code msgbox " this is a popup" ...whatver code you want goes here, if you want any 'Turn the Access warning messages back on DoCmd.SetWarnings True
  4. C

    Append query to skip blank fileds???

    Use the query wizard, select the fields you need to copy over, go into design view and set the query type as append, and select the table you want to add the data to. This works for me. Chris
  5. C

    delete query on a form

    I've already tried that (replacing the query name), I get an error message stating that Access can't find the query. There must be a way around this. Chris
  6. C

    delete query on a form

    HI there, can anyone tell me hy I can't access/view a delete query when using the the wizard while putting a command button on a form? The delete query is working fine i application mode. thaks in advnace Chris
View older results
Back
Top Bottom