Search results

hello guys i have a table that contain 3 fields 1- serial number 2- sub serial number 3- number 4- description Serial Number | Sub Serial Number | Number | Description 1 | 1 | 1200 | Empty 2 | 1...

hello guys i have multiple textboxes in Report Detail and every textbox contain different data am having a problem when turn cangrow on so i decide to put all the textbox in one textbox but am not getting any data this is my code please can someone help me to fix it If Me.txt3 = "" Then...

hello Guys any idea about taking a screenshot for a form then save this picture as attachment in a table or in a specified folder

that's what i did but am asking maybe i can find a solution here

i can't make txt1,txt2,txt3 (cangrow=no) the data will differ but the txt4 i want to show the date so i want to put it in the bottom far from the texts but in fix position

i have a report in the details section i have for text boxes 3 text boxes one above the others txt1(can grow) txt2(can grow) txt3(can grow) and in the bottom of the details i put the last textbox it's date txt4 my problem is when the txt1, txt2, txt3 grow to fit the text the txt4 go down i...

in the first check nothing second check mobile third check phone fourth check phone and mobile

sir am getting this error the expression you entered has an invalid .(dot) or ! operator or invalid parentheses You may have entered an invalid identifier or typed parentheses following the Null constant this is my code IIf(IsNull([Phone]+[Mobile]);;IIf(not IsNull([Phone]) and...

hello guys i want to combine (isnull) and (not isnull) in query iif(isnull[txt1] and not isnull[txt2];true;false) but it's not right any help?

thank you sir

hello guys i have a form that contains 10 textboxes each file entered in the database will have a unique number that will be writed on the file after this records will be printed i want to enter the id in the textboxes sometimes one textbox somtimes 5 and maybe the 10 an when i click on...

sir i downloaded the database but am getting this error Compile Error: The Code in this project must be updated for use on 64-bit systems. Please review and update declare statements and then mark them with PtrSafe attribute am using office 2016 64bit on windows 10 Pro 64bit any solution please?

hello guys I hope that I can solve my problem for example my form is 20 cm width and 15 cm height with none border style when opening the form I want the whole screen to be filled with a color and in the middle my form appear and when I open any form also the colored background will fill the...

if I turn it into auto number I cant have the numbers in sequence the user could delete the last record and when he delete it in the autonumber can't be sequence anymore

hello guys I want to create serial number for each record this is my code Dim strsql01 As String Dim LastSerialNumber As Long Dim NewSerialNumber As Long If DCount("*", "tbl_violation_accepted_telegram") = 0 Then NewSerialNumber = 1 Else LastSerialNumber = DMax("Serial_Number"...

sorry it's my fault I wrote Full_Name instead of FullName thank you so much

I changed the code to yours am getting this error now the expression you entered as a query parameter produced this error: '[FullName]' and big thanks for your help

hello guys I want to search a table with 3 criterias this is my code If DCount("*", "tbl_violation_accepted_telegram", "[Accept_Description_Zone_Number] Like '*" & txt_Accept_Description_Zone_Number & "*' And "[Accept_Description_Zone_Name] Like '*" & txt_Accept_Description_Zone_Name & "*'"...

ok sir thank you so much you helped me a lot

sir here i forget to put the bracket but in access all the brackets is writed so any idea?