Search results

The user needs to see RCC information displayed. The error is generated when I try to add a new record in SubfrmRCC and it can appear on any field that I try to use first. It works fine when I only update one of the existing records, but the problem only occurs when adding a new record. I have...

I tried using a query instead of subform, but my query was not updatable. More information is needed about how you want to accomplish here... I have a construction database with tblSite, tblPhase...and tblRCC. First a site is created in the tblSite which is the one side, then a number of...

Hi, I am getting this error 'You tried to assign the Null value to a variable that is not a Variant data type. (Error 3162)' I know why I am getting the error, I found out that Form and Subform should be implemented only with one-to-many relationships where the Subform is the many end...

I am still stuck with this problem and would appreciate if any body can help. Cheers, B

Here is the situation: tblRCC is the parent table of tblPhase; however, tblPhase records won't stand in a vacuum if they are orphaned because tblPhase is the parent of an other table. So cascade delete won't work here. The idea was to delete parent record from tblRCC and all its correspending FK...

Hi, I want to Delete only FK on the many side first and the record on the one side by one click of a button. I wrote some code which sometimes works and sometimes it does not!! I wonder if any one have a better idea or doing this please? Private Sub Delete_Click() Dim db As DAO.Database...

I have instead set the focus to the subform just before I requeried it and it seems to work now.

It works, but it seems like it's always one step behind. When I update the combo the first time, the subform does not requery. When I update the combo the second time, then the subform requeries and shows the previous update. So it feels like it is always one step behind. Any idea why it's...

Hi, I want to requery a SubForm using the on Click event of a combobox that is located on the main form. I used this code below, but it does not work. Forms![frmSite]![subRoadsConstructionConsent].Requery Any suggestions please, B

I don't need to do it on the first page, so the onChange will do.

That's good boblarson, it worked - thank you. So, to be able to specify a certain tab, I just need to use an if statement. right? Will give it a go. Cheers, B

What do you mean? A button... or something like that? I would prefer to trigger the event automatically like on gotFocus, on click...etc on one of the tab buttons. I tried other events that are available, but none of them worked. I also tried something I've seen in the list of references...

Hi, I am trying to make a combobox visible when the user clicks on one of a tab control buttons. I wrote this code below, but I does not seem to work. Both the tab control and the combo are on the same form. Private Sub L_B_Consent_Click() Me.cmbLBConsent.Visible = True End Sub Any help...

I appreciate this, it's good to know. Thank you, B

No I meant the fields that make up the core information such as names, address..etc are the once that can make the DB full. If they are not needed after a certain time, why should keep them. For example, the company may not need info that is more than 1 year old anymore. Hence, deleting old...

I want to do the cascade delete to delete Customer information and House info that's not needed any more. Sometimes, the user will only need to get rid of the customer, but not the house. Using flags is good as you said; however, won't that make the DB large over time? Cheers, B

I have a similar problem, but this time I need to keep the subform. It's frmHouse. The reason I need to keep the subform is because I need to enter a new house in specific site and phase that's why I need that visual effect of Site name and Phase number appear to the user. Do you have any...

Hi, I want to use Cascade Delete on a main table that has relationships with a few tables. The type of these relationships are weak and the delete will work perfectly I think. But, I am concerned about how I can only delete the FK from one of the tables because it contains a non-prime FK...

Thank you - B

It's the same one I PM you a few weeks ago. Have you still got it? If not I will need to strip it and send it again. (Too large)