Recent content by floydman

Problem solved! The behavior was caused by an errant DoCmd.Echo False when I never changed back to True so when the Popup closed the Main Form never repainted and appeared frozen. RuralGuy- thanks for the suggestions.

Thanks I'll give that a shot tomorrow. I fixed some of my references to the main form and it now has the same behavior using either acDialog or acWindowNormal. When the PopUp closes the main form is in view but totally inactive and the screen did not repaint (i.e. there is a grey box over the...

hmm, its telling me the popup cant find controls on the main form now. This part was working OK when it was acWindowNormal.

I'm using DoCmd.OpenForm "frmCampaignConfirmation", acNormal, , , acFormEdit, acWindowNormal

I have a problem with a popup form closing. After clicking OK the form closes but the main form from which the pop was launched does not come back to focus, in fact Access toolbars aren't available either. The modal property of the popup is set to No and I've also tried Yes with the same effect...

Oh, forgot to add that the error is on Me.Parent!sub2.Form.RecordSource = strSQL

I have a mainform with 2 unbound subforms, when a new record is selected on subform1 I want to move focus and change the recordsource of subform2 and requery. In the Current Event of sub1 I have: Me.Parent!sub2.Form.RecordSource = strSQL Me.Parent!sub2.Form.SetFocus Me.Parent!sub2.Form.Requery...

Many thanks, went through it all and seems to well now, the User Steve now is in control. Cheers

Many thanks statsman and docman, still a little confused though ( I haven't made any changes yet as I want to understand this before I go ahead). The user 'Steve' is a member of the Admins group. The user 'Admin' is only a member of the User group. When I login as Steve and try to open a form...

I was previously using a single database password but had to move to user lever security when I made a Master and Replica database, here's my problem: I set up 2 users, Steve and Generic, Steve is for me to Admininster the database and Generic is for everyone else to login. I made Steve a...

Thankyou, it was.

What is the best way to handle a deleting a date value ? I have an unbound form where the user can delete a date value, whenever they do this the form then displays 31-Dec-1899 (which I understand is the zero number value for the date). How do I stop the Access form displaying the zero value and...

Hi Rich, The Filter property of the subform is blank. I have some other info also, when I choose Sort Ascending or Sort Descending by right clicking on the Subform (its in datasheet view) the data appears also, so maybe the Filter is a red herring here, I can't seem to find any sort properties...

Don't think the Main Form is overriding the SubForm because when I check the properties of the subform after it opens it has the correct RecordSource and has no Filter value (this is true when I check properties before I right click and select Remove Filter/Sort on the SubForm). What is the...

I have a main form with a subform, the subform RecordSource is set in VB. When the main form opens the subform shows no data. When I right click on the subform and choose Remove Filter/Sort, the correct data appears based on the RecordSource query I set in the code. The final few lines in Sub...