Search results

You could run a delete query like the following. Assuming the name of your sub form is 'subMain', the name of your table is 'myTable', and you have a unique identifier in your sub form ('myID' in this case. Does not have to be visible, just in underlying recordset), this code should delete...

Hi, I have "Access 2000 Development Unleashed" and found it quite useful, although I haven't got anything to compare it to. The book has shown me a lot of things I didn't know, but when i'm stuck with a problem, it never seems to have an answer.:confused: Now I tend to use the Internet to...

Hmm, I would have thought you could do this by using the templatefile argument of docmd.sendobject, but when I tried it, it didn't work.:mad: Although I was using stationary, not sure if this is the same as a template???:confused: Otherwise, u might be able to use automation.

Survey

Hi, You can use a query in DLookup. Does your query return more then one record? If so this may be your problem. The following is an excerpt from MS Access Help. Remarks The DLookup function returns a single field value based on the information specified in criteria. Although criteria is an...

Hi Ericnord, How about if u use something like this (see attachment, if it works). An option group with 9 toggle buttons in it. To get the text underneath, add 3 (or 9 if u like) extra fields to your questions table. For each question, enter the text for the buttons. E.g. tblQuestions...