Search results

guys thank you for your help i changed the anchor settings for the command it was set right i change it to left and now everything is okay thanks for your time

i didn't create the form using the wizard

that's all the code i have for this form Private Sub cmd_Close_Click() DoCmd.Close End Sub Private Sub cmdPrint_Click() DoCmd.OpenForm "frm_Print_Santions" Forms!frm_print_santions!CID = Me.CID End Sub Private Sub Sanctions_Number_DblClick(Cancel As Integer)...

the command button with green background

hello i have a form, in design view everything is okay but when i run the form the command button go to the right design view https://ibb.co/ZSgkGvB form view https://ibb.co/nCMmcJs any help

hello i have a continuous form with lot of data, some data is bigger than the textbox and dont fit so the user can read it all any idea how can i grow the textbox when the text is bigger than x characters or resize the font i tried to check the cangrow by lebans.com...

maybe the message break something when ask access to go to new record

thank you so much

i attached a small copy of my database i hope could some one help me

i cant open the database using my office 2016

okey i will switch to dlookup

am filtering the form using PID coz every client have his own files to save

and it's bound to a table not query

am opening the form from another form using this command DoCmd.OpenForm "frm_Personal_Sanctions_Entry", acNormal, , "[PID] = " & [PID] Data Entry set to no Allow Additions set to yes

hello guys, i have a form that is bound to a table am let the form go to the last record then showing a message to let the client now the number of the last file saved then push the form to go to a new record so the client continue saving new files Private Sub Form_Load()...

hello, any idea how can i shrink textbox in form when the text is long? in report the can shrink and can grow work perfect but not in form

command on click from the opened form

hello i have 2 forms and on update query based on user id so i want to run the same query if form1 is open or form2 i put on criteria [forms]![form1]![uid] or [forms]![form2]![uid] but when run query form1 a dialog appear ask me for [forms]![form2]![uid] and when run query form2 a...

thank you guys i find the solution Dim strFilter As String If Len(Trim(Me.Search.Value & vbNullString)) > 0 Then strFilter = "Sanction_Number Like '*" & _ Replace(Me.Search.Value, "'", "''") & _ "*'" Debug.Print strFilter Me.Filter =...

hello guys am filtering my continuous form usin this code Dim str1 As String str1 = "[Sanction_Number] LIKE " & Chr(34) & "*" & Me.Search.Text & "*" & Chr(34) Form.Filter = str1 Form.FilterOn = True Me.Search.Value = "" Me.Search.SetFocus but if the result is empty and try to search...