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...

Tim, check this out Tim, here is a parallel post at accessvba.com with more information about the execute method: http://www.accessvba.com/showthread.php?s=&postid=8329#post8329 Cheers, ML

Fixed used CurrentDB.execute Thanks Tim. I also found another option that works too. As an alternative, I tried using: CurrentDB.Execute strSQLBreakdown and it worked without throwing any Access errors. Your advice will come in handy though. I didn't know about that method. Thanks again, ML

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...

Hi Rich, Thanks for the suggestion but the same thing happens. When the recalc method is run, the cursor jumps back to the 1st record on the 1st field. After I wrote that first paragraph, I thought hmmm...wonder what would happen if I used your save suggestion but excluded the recalc line...

Nope, I was wrong - requery does the same thing. It forces the total update but it also moves the query to the first record and the first field. What should I do?

Hi Fizzio I was using recalc to force the totals to update as soon as the field was changed. The control source is an expression. The problem is that the total didn't refresh on field updates. It didn't happen until the user left the current record. If they were only entering one, they...

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...