Search results

guys thank you for your times i resolve my problem by taking this steps i create a new form based on the serial number (that's work fine) and from this new form i run the queries and open the report so everything is okey thank you again for your time

am having the problem with or without the filter if i dont filter the form so i have all my records when am trying to open any record it will open the report with the data from the first record

am filtering my form using textbox (after update) Dim str1 As String str1 = "[Accept_Description_Zone_Number] LIKE " & Chr(34) & "*" & Me.txt_Search.Text & "*" & Chr(34) Form.Filter = str1 Form.FilterOn = True Me.txt_Search.Value = "" Me.txt_Search.SetFocus

i can t add images but i will give some info the report source is a query combination between two tables the update query is from table to table based on the the serial number from the continuous form that doesnt work

yes it's a number field but i have another problem i mentioned above that when i run an update query also it will update the first record not the one i want

i tried your solution same result if i have for example 10 records after the search and i want to open any record it will open the first record

Hello Guys, I Have a continuous form when i filter the records if i get just one record everything is okey but if i have many record and i want to run the code for the fourth line it doesnt work this is my code DoCmd.OpenReport "rpt_Allow_File", acViewPreview, , "[Serial_Number] = " &...

Any help guys? Please i really need the solution Sent from my SM-J510F using Tapatalk

Any help guys? I really need a solution I gues the problem in the concat function If so can i use another function and have the same result (combine textboxes each one on a new line) without losing first letters when i change the align to the right? Sent from my SM-J510F using Tapatalk

no sir nothing changed in the right report the same problem exist the first letters disappear

any help please ??????

the original textboxes show the text with no problems in the first letters just in the concat textbox so can we make something in the function Public Function fnConcat(ParamArray p() As Variant) As String Dim elem As Variant Dim ret As String For Each elem In p If Trim(elem...

hello am trying to use your module but am getting an error Invalid procedure call or argument on this line => CommandBars.Item(strMenuName).Delete any solution ?

hello sir i uploaded a sample of my database and i put two reports right and left the left one contains textbox that have left alignment no problems but the right one contains textbox that have right alignment the first letters of each textbox gone i already said that i have multiple textboxes...

Yes yes sorry for mistyping i tried the right padding Sent from my SM-J510F using Tapatalk

I tried the right margin nothing happened still have the same problem Sent from my SM-J510F using Tapatalk

Hello guys I have a report in arabic (reading order = right to left) In the detail section i have 7 textboxes and a big one that contains all the data of the 7 textboxes and i used a small function to concat textboxes My problem with the right margin the first letter doesn't appear I changed...

hello guys i have a split database i want to let the database of first load check the be file if it's not linked than a window appear to link the database with the be file any solution ?

i don't know if i an do it this way because the records will not be entered the same time maybe the second record will enter after one month maybe 6 maybe one year and not all records will have another record for the same case so if i made aquery i should make it another one as update right ?

thank you i'll try and if i can't reach my way i'll be back thanks again