Search results

Tried both solution but it does not works. It does not update. Tried also to refresh after requery but nothing happen. I can only close and reopen the form. My code Forms.Mainformname.Subformname.Requery PIPForm is the form with button that should be Requery and update the Subform

I cannot Use Docmd.Requery because the button is on a third form (PipForm). I dont think it is the right way

Update. I cannot run Forms![Mainformname]![Subformname].Form.Requery Beacuse it does not find the form mainformname

I tried the follow: Forms![Mainformname]![Subformname].Form.Requery But having the form which contain the form open nothing happen. If I close the form containing the subform and Reopen it is there. I would like to update the subform in realtime when saving PipForm button

Hi I have one subform (subformname) that I would like to requery when updating with data another form (PipForm). When I press a button which save data on (PipForm) i have setted this code: Me.Parent.Subformname.Form.Requery But get error that object is missing. I have no idea how to update...

Hi. I got it solved. Author replied to me and the solution is the follow: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="onRibbonLoad"> <ribbon startFromScratch="true"> <tabs> <tab id="tabHome" label="Home"> <group id="grpData" label="Navigation"...

Hi I set up a Ribbon with Idbe Ribbon Creator. All is fine and working very well. But When I open a form in datasheet view, the ribbon open another tab "Datasheet" on focus and this confuse users.. How can I deactivate this "Datasheet" Tab?

I got it working using for previous month the contidion: WHERE (((Year([DataPIP])*12+DatePart("m",[DataPIP]))=Year(Date())*12+DatePart("m",Date())-1)) For current month instead I used: WHERE Year([DataPip]) = Year(Now()) And Month([DataPiP]) = Month(Now()) Hope this help. Thanks to all

Hi I get it working. Thanks

I have to set two different criteria: 1) to display all records in the query on the current month 2) to display all records in the query on previous month. I don't know what to write For previous month I found microsoft advice to use: Year([DataPip])* 12 + DatePart("m", [DataPip]) =...

Hi I have a query Union based on two simple queries. I have to set a command button on a form which print previous month entries of all records based on ID. My question is: 1) should I have to set previous month criteria on each query for to have union query to work? 2) I have set on one query...

VbaInet. It works! So I suppose it is solved.

Hi VbaInet. i get it solved: If Not CurrentProject.AllForms("MascheraPrincipale").IsLoaded Then MsgBox "Necessario scegliere un paziente prima di accedere a quest'area", vbOKOnly, "Errore" DoCmd.OpenForm "FRM_SearchMulti" Else DoCmd.OpenForm...

Hi. i would like to have a message box if the user take to run a command box before to choose a patient. Here is what I get: If Not CurrentProject.AllForms("MascheraPrincipale").IsLoaded Then MsgBox "Necessario scegliere un paziente prima di accedere a quest'area", vbOKOnly, "Errore"...

Hi VbaInet. and all who follow. I found it: Parent![FRMSottMascQueryPIPPerUnire].Form.Requeryor translate: Parent![Subformname].Form.RequeryThanks to all

Great VbaInet. It works. I can delete the record . But now I'm stuck on running Requery. In Bold is what I have found on the net. But it does not works. Private Sub cmdeliminaPrestazioni_Click() DoCmd.RunCommand acCmdSaveRecord CurrentDb.Execute "QueryeliminaPrestazioni"...

VbaInet. Out of curiosity... Is it not possible to place a single delete button for both the delete queries? It would be less confusing for the user than to have two delete button. Is there some arrangments that can be accomplished?

NeverMind. I got my head out of world... Mistaken to add the proper table ID. Linking Master/child in Form/Subforms works very well. Thanks for support :banghead:

Yes they are linked

Hi I have a form (nameform) with two subform (subform A)(subform B) based on two different queries. All is fine when run it. I'm tryng to open "nameform" from another form (FormPrincipale). To do that I'm using macro command on a button click event with WHERE Condition is ="[ID]=" & [ID]. The...