Search results

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

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

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

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

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

Hi, I have one particular form in my app that opens on top of the access window so appears outside of access. When I hit maximize it maximises to my entire screen wheras other forms in the app maximise within the access application window. I've been comparing the format properties but can't see...