Search results

I had a similar problem with the write conflict error. I was able to stop the error by using the AfterUpdate event in the subforms and BeforeUpdate in the main form.

Does anyone know if you can link a query rather than a table to a SharePoint Services list? I would like to preserve my one to many relationships in SharePoint, but even when I select a query to link Access creates a new table. A less desirable choice is to use a multi-select control in...

Alexei, I followed your instructions, but got an error message after pressing the selection on the switchboard. Unfortunately, the message simply said "There was an error executing the command": not much help. Here's the module I created (named OpenDSView): ----------------------- Function...

Hmmm...I got the idea to place the datasheet view in a subform from this list, as the switchboard won't open a main form in that view. Thanks anyway for your help in answering my question. Perhaps someone will have an alternative suggestion. Cheers, Nancy

Thanks, Alexei. That got me part-way there. The form opened and allowed me to select my filters, but when I selected the "Apply Filter" button nothing happened, and the "Remove Filter" button was grayed out. How do I take this the next step, then, to get the user from selecting criteria to...

Newbie question: I have a datasheet view subform (called "UpdateProjectsSubform") in an "empty" form. I set it up this way because I was unable to get the Switchboard to open the subform in datasheet view. I would like to have a command button to set filters in the subform. As I cannot have...

I'm a beginner at VB and programming. I have created a button on my form that runs a report whose underlying query prompts the user to enter a case number to print a single record. On button click, I would like the query to use the current record's case number without requiring the user to...