Recent content by magister011

I did try that, but I want to use the surrogate keys in my intermediate table. That property would not reference that table. It would only refer to the two project tables. If there is another way to make this relationship, I am open to suggestions. Thanks Dave

I am using Access 2003 to try to make a small database example to play with for a later bigger project. Here is how the database is set up: tblProject -fldProjPK -fldProjNum -fldProjNam -fldProjContNum tblIntermediate -fldIntPK -fldIntProjFK1 -fldIntProjFK2 tblProject_1 This is a virtual...

I was able to get it working. I had a line of code in the ON LOAD event that was sorting the records. I removed it and the requery worked perfect. Thank you so much. I appreciate it. magister011 :D

I will have to check that out tomorrow at work. I only have Access 2000 at home. I will let you know what I find out. Thanks magister011

Is this a major problem that can be fixed or do I just have to live with it? Your help is surely appreciated! :D magister011

OK, I have the Tab Control Event working, but I still cannot get the records to sort decsending. I think may be the problem. On the continuous form I have an edit button for each record that works off the On Click Event. This will take the user back to the other form and is able to make any...

I have a problem that I have searched but I have not quite found an answer yet. I have Access 2003. In the database I have a form with a tab control of two tabbed forms. One form is a justified form that I am using to just enter data and it's record source is linked to a table. The other...

Thank you, It worked and all is good. :) Magister011

Thanks, I will try that.

The error message that I get is: Run-time error '2115': The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Office Access from saving the data in the field.

Ok, I spoke too soon! I tried the a message box with the 'before update' event. Here is the code I used: 'code start Dim intResponse As Integer Dim strMsg As String strMsg = "Data on the form has changed. Do you want to save changes?" intResponse = MsgBox(strMsg, vbQuestion + vbYesNo, "Confirm...

Yes, I am aware of that. I am trying to get the user to make sure the user has to save the data before they leave the form. I tried a message box with a 'before update' event. Here is the code I used: 'code start Dim intResponse As Integer Dim strMsg As String strMsg = "Data on the form has...

I am trying to make a save command button only appear on my form if the data on the form has been changed. I also want to be able to force the user to have to use that command button before he/she continues. I have tried the "On Dirty" event with no luck. Would anyone be able to assist me...

Thanks everyone, I was able to get it taken care of with Rob's "before update event" code. Magister011

pbaldy, I searched for "unbound" but since I am unfamiliar with this command I am not sure of what I am looking for. Any hints?