Search results for query: *

Can you tell me which tables that I need and how to relate them to each other. Where to put the vba code you suggest: "CurrentDB.Execute "INSERT INTO tblAttendance (DateID, StudentID) SELECT DateID, StudentID FROM tblDates, tblStudents". Thanks

I have a mainform and subform. The mainform has only one field which is "Date". The subform is in tabular view and contains a list of students names. What I want to do is taking attendance for the students for every different date. I need to move from record (Date) to another and add new...

I'm trying to develop an application for tracking student attendance. I want to list the students names for a class at one side (left side) and a grid for inserting the student status (present, absent, late etc.) to the right. The grid cells contain combo boxes to assign the status for the...

I add an activex control to my form in design view, and i wanted to change some of the properties. I clicked the user-defined property, but get the following error: "OLE Server isn't registered. Reinstall!". I get this error when doing the same with many of the activex controls shipped with...

I add an activex control to my form in design view, and i wanted to change some of the properties. I clicked the user-defined property, but get the following error: "OLE Server isn't registered. Reinstall!". I get this error when doing the same with many of the activex controls shipped with...

Thanks tf1 I opened the file in excel 2000 and saved it as excel 95 and then reopened it in excel 2003. It works! Why this error and how this solution works will still be unanswered questions!

When trying to open an excel 2000 file from excel 2003 i get a message that the file can't open and get the choice to report the error to Microsoft. I continue trying opening the file and excel repair the file and opens it. But when the file is opened all the underlying fuctions and sheets get...

Hi, Thanks for helping me. It works as I wanted. I added the following sentence to the HandleButtonClick function: Case conCmdOpenFormBrowse Forms!Main Switchboard!subfrm.SourceObject = rs![Argument] and it works, but .... When displaying the " Main switchboard" the focus is set to the...

PLEASE HELP BEACUSE I'M FRUSTRATED! Hi, I made a switchboard for my reservation database by first using the Switchboard Manager from MSaccess 2000 and then copying the buttons produced by the manager to new form called "subfrmSwitchboard" . I made also another form called "Main Switchboard" and...

Hi, I'm making a database for reservation of items with these fields: Item name (combo box), date, from time, to time. I want to prevent the users to reserve an item that is already reserved at the same date,from time and to time as the user is going to choose. How to do that?. Thanks I'm using...