Search results

Does anyone know of a simple (preferably free or shareware) that I can use to design and print a relationship diagram. I don't need a full ERD schema designer that connects to an existing db - in fact, I want to use it in the design stage. I thought visio would have the appropriate stencil but...

Would someone review my schema below and see if it makes sense? I am developing a movie review db and the relationship I am concernced about is the many to many relationship between the actors and movies and one to many relationship betweent the producers and directors and their movies. The db...

I don't have access to an XP machine. Does it use a different version of the Jet engine? I have written a program in VB6 which stores and retrieves data from an access backend. XP users are having trouble with database formats. Are there any easy solutions?

I have a form with an embedded subform set to continuous forms. When a text box on the main form is empty, edits in the subform are allowed. However when the text box (txtApproval) has a value edits in the subform are not allowed. The problem is, I need a way to advise users that because the...

I have form with the correct id and password, approves the data in a form and a subform. I am trying to ensure that once approved data in both are unalterable. I tried using the dirty property of the subform and referencing it from frmApproval but at runtime, I get the MS Access error...

Native Access error on DELETE statement For some crazy reason, I thought it would be easier to design this app using Access instead of from scratch usinng VB. I am using the following code to delete records from a subform: DoCmd.RunSQL strSQLBreakDown . The variable is an SQL delete...

Setfocus on continuous subform (also posted on accessvba.com) I have a time card app with a subform set to continuous forms (see image). I want the tab key to navigate easily through the subform but it doesn't. I use the recalc function in the change and after_update events on the text boxes...