Search results

thank you so much pbaldy everytime i ask something you are the first one to help me i really appreciate ur hard work and thanks again

hello guys i'am using dcount in the control source of a form this is what i wrote =DCount("*";"[tbl_Sanctions]";"[Register_Date] <=Now()-28 AND [First_Procedure_Number]<=15 AND [Procedures_Type] = Hard") i want to know the number of the records in the table tbl_Sanctions with this criteria...

Thank you so much pbaldy

hello guys well i'm from lebanon so my language is arabic i made a database to my office but it's in arabic language is there any solution to switch the language to arabic when i open the database i mean to let the user type in arabic without alt+shift i don't want to make the arabic the...

so guys no one can help me ???? i really need a solution

hello i'm making updates for the front end then i send it to 10 pc's in the office then i should change the backend location via linked table manager for every pc so is there any way to let the user choose the backend location when he open the database nad then it will automatically update the...

btw i run the query manually and i leave the parameter blank she show all the records this is the code that i put it in the onclick event If DCount("*", "qry_Building_Violation_Accepted") > 0 Then DoCmd.OpenReport "rpt_Buildings_Violation_Accepted", acViewPreview Else DoCmd.OpenReport...

first of all thank you for your reply this is what i do when i put forms!myform!mytextbox or forms!myform!mytextbox Is Null the query take this part (forms!myform!mytextbox) and put it in a new column and Is Null in the (or) field ok i think it will work i open my form i type a city name...

Brianwarnock not working my question is for example i type in a textbox cityname 'Berlin' so i will get in my report all the records that have cityname 'Berlin' so if i want to show all the records in my report what should i type in this textbox???? thanks in advance

hello i create a query to bring data from a table and then print a report that display this data i put a criteria on the cities field to filter this query it will take the name of the city from a txtbox in a specific form everything is ok but when i want to print all records with any city...

ok thanks so much finally it works

6-4-0 i typed wrong it's 7-4-1 and 1-1-0 disappear 4-2-0 and 5-3-0 dont that's what i want to do because the client (pid) 1 have more than one records so i can delete the record 1-1-0 but the client(pid) 2 just have one record so i dont want to delete 4-2-0 when the client(pid) 2 get...

maybe i didnt explain my problem well when i save a new client automaticly it will save a record in the above table with tid=0 then this table will be used in another form and the tid will be 1 then 2 then 3 so i want to delete the records where tid=0 if there is more than one record if there...

hello i have table named tbl_edbarat_1 contains 3 columns (id - pid - tid) i want to delete the records where the tid=0 and DCount("*", "tbl_Edbarat_1") > 1 i try this If DCount("*", "tbl_Edbarat_1") > 1 Then DoCmd.SetWarnings False DoCmd.OpenQuery "qry_Delete_Empty_Edbarat_01_Records"...

hello i have a continuous form with 4 text boxes txt1,txt2,txt3,txt4 if txt1 has more than one line how to let it grow and in the same time the other txt boxes will grow to the same size all the textboxes should have the biggest size i did this but in report i put this code in the event...

well actually from these forms i should print many reports so in reality i have more than 50 form and more than 100 report to make sure all the reports is printed a the specified date i want to make this N.B: i could write this in VBA but unfortunately the date of reports may change so the...

hello guys i have an idea i hope there is a solution for i have 10 forms named FormA - FormB ------ FormJ i want to choose the formA and from a combo i want to choose a day so when this day come the chosen form will open automaticlly in the specified date when i open the database for...

Pr2 eugin yes they are And thanks for correcting my codes I'm proud of my self coz i'm a newbie ans no one learn me just this forum so thank you guys for everything Smig i want this id coz it will be a unique id for a specific person So i want to writr down this id on papers coming from the...

Minty thank you so much it works

smig is this what i should write Dim lastID As Long lastID = DMax("P_ID", "tbl_Personal_Information") MSG2 = MsgBox("the information is saved under the ID lastID, do you want to add a new record?", vbYesNo + vbQuestion + vbMsgBoxRtlReading, "customer database")