Search results

This is the Click event code for a delete button on a form. I'm trying to check if the record that is being deleted is active in another table. There should be only one active instance of the record so dcount isn't required, but I don't know any better. When I run this code in a stand alone...

This is the Click event code for a delete button on a form. I'm trying to check if the record that is being deleted is active in another table. There should be only one active instance of the record so dcount isn't required, but I don't know any better. When I run this code in a stand alone...

write sql statement to row source I'm trying to use an on click event in one list box to change the contents of another list box. The code I'm using re-writes the sql code to the row source property if I enclose the table names in square brackets, but doesn't generate known results. Similar SQL...

I am trying to use the title selected in one text box to limit the query that populates another text box. This is my simplistic attempt at it: SELECT COPY.CopyKey, COPY.CopyId, TITLE.Title, TITLE.Edition FROM COPY INNER JOIN TITLE ON COPY,FK_ISBN=TITLE.PK_ISBN WHERE(((COIP.CopyKey)Not In...

I have a form with a combo box that notifies the user when they are changing a pre-existing record. I would like when the user click on the negitive/no button on the message box that the change is reversed. However I get a runtime error telling me that Undo is not available now. Thanks This...

I'm using Access xp and working on a .mdb database. I have a form that is bound to a junction table between student and books. It records the copy number, student number and data in/out. I need to advise the user when they have changed an old records copy number or student number with a Yes/No...

I'm using a Access Xp 2002 and Keep getting this error when I delete a record. The error is Run Time Error 3021 "No Current record". The error started after I exported all my forms, queries and reports to a split off of the database. The delete still occurrs it just produces this error. Any...

I'm using Access 2002 and after exporting all my working forms, queries, macros and spitting off the database to get rid of one errant vba class object, I now get Error 3021: No current record when I use a delete button on a a form that existed before the above transformation. It also errors...

I'm using Access 2002 and I created a switchboard and deleted it without using Switchboard manager. Now the left over module alarms every time I try to add code to the project or even click on the switchboard module. The alarm states that the form name maybe mis-spelled or missing. Please make...

When I right click on the module in project Remove is low lighted. Can I correct this? Thanks for your support R Vote early and often.