Search results

Hi I'm going to select case 1 to pass that value (in letter "M") to another form textbox: I'm trying with no avail the following: Private Sub radioUomo_GotFocus() ' radiobutton Dim strUomo As String Select Case radioUomo Case 1 strUomo = Forms!FRMnuovoPaziente.Sesso.M Case*2: strUomo =...

I try this way: I got FRM A: two textbox inside (1)Firstname 2) Lastname) I would like to copy the union of the both separated by space into another form B textbox (FirstnameLastname) example FORM A: firstname : SPRINGSTEEN lastname: BRUCE into FORM B...

Hi I have surname and name in the same column. I want them separate (splitted) For the surname I use : Firstname = Split(fullname," ")(0) and that return firstname. All is ok. But afetr there is a space and then the name. How to extract the name after the space?

Hi. I have one form (FRMPIP) which has a button to save data and requery 2 forms Forms![FRMMesePrecedentePIP].[FRMSottomaschera QueryPIPConcatRelatedsuMesePrecedente].Form.Requery Forms![FRMMeseCorrentePIP].[FRMSottomaschera QueryPIPMeseCorrenteConcatRelated].Form.Requery The two lines of code...

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

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

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

Hi I have a form based on query. Each record has a checkbox. I would like when activate checkbox to delete the specific record. from a button in the form. Have not find anything around

Hi I would like to know in general what I have to do splitting a database. In my scenario I want to deploy my database. Many suggests to split it. Well If I do that I got two files: one .accdb (front end) and one .BE (back end). Shoul I keep them in the same installation directory? What should I...

I have a Form (FRM_SEarchMulti) with a list box (SearchResults). This list box has an ID for patient. I have a form (FRMMeseCorrentePrestazioni) with a command button that open another form (FRMPrestazioni). I would like to be able to open FRMPrestazioni based on the specific record of listbox...

Hi. I'm using option group with value 1 and value 2 with a command button to open two different forms. This is the code: Private Sub Command9_Click() Dim strForm As String Select Case Me.Cornice0 Case Is = 1 strForm = "FRMMeseCorrentePrestazioni" ' Open...

Hi on a ribbon I set up a button which I would like to open a specific record. From a form I use happily: DoCmd.OpenForm "frmDetail", , , "recordID = " & Me!recordIDand it works. But when I do from the button on the ribbon it does not. Any help?

Customizing the form with the following code Public Declare Function LoadImage Lib "user32" _ Alias "LoadImageA" _ (ByVal hInst As Long, _ ByVal lpsz As String, _ ByVal un1 As Long, _ ByVal n1 As Long, _ ByVal n2 As Long, _ ByVal un2 As Long) _ As Long Public Declare Function SendMessage Lib...

Hi I would like to add a cross close command on the tab in tabbed documents mode. Is it possible to accomplish?

How to limit input data on the same month for each patient? The field is a data/text box on a subform I found this code on Form Current Event!: Private Sub Form_Current() Dim intMaxNumRecs as Integer intMaxNumRecs = 5 'Max Number of Records to Allow If Me.NewRecord Then...

Hi I got an image bitmap that I want to use to customize my button. I got following error pop up "Image Generator" - "search key not found in any record". I'm using access 2013

Is there any way to mix together on a db based on tabbed documents some overlapped forms? Thanks

Can someone take a look? SELECT DISTINCT tblAnagrafica.[Cognome Nome], TabellaPIP.DescrizionePIP, tblAnagrafica.[Tessera Sanitaria], ConcatRelated("TabellaJoinPIP.DataPIP","TabellaJoinPIP", "queryPIPRecenti", [IDAnagrafica] = " & tblAnagrafica.ID & " AND [IDPIP] = " & TabellaJoinPIP.IDPIP...