Search results

Smig thank you it works I named a submacro with +{F4} Then i named the macro AutoKeys

Smig you mean i'll name it for example Shift+F4 And in any form i just press shift + f4???

hello guys any help with using F-Keys and shift and control for example if i press ctrl + F4 a specific form will open N.B: i'm using access 2013

thank you so much vbaInet it woks and yes i'm running this code in the change event

uncle Gizmo Sorry the error was from filtering not from saving i edited my question sorry again any help??

hello guys i want to filter data this is my code Dim str1 As String str1 = "[Movie_Name] LIKE '*" & Me.Movie_Name.Text & "*'" Me![tbl_Movies_Names].Form.Filter = str1 Me![tbl_Movies_Names].Form.FilterOn = True everything is ok but if movie_name contains ' for examples (Ender's...

jdraw thanks but i didn't understand what should i do my question was if there is a simple method than putting the info manually in the third table

hello Guys i need your help with my movies library it's for my own use i have 2 tables 1. Actors Table 2. Movies Table i create a third table so i put manually the id of an actor than the id of the movie belong to this actor so in the third table we could see the movie more than one time...

hello it's me again i have a query SELECT qry_Ma7adir_karar_7abes_9.IDD, qry_Ma7adir_karar_7abes_9.Register_Date, qry_Ma7adir_karar_7abes_9.P_ID, qry_Ma7adir_karar_7abes_9.Name_Ma7dar, qry_Ma7adir_karar_7abes_9.Full_Name, qry_Ma7adir_karar_7abes_9.Mother, qry_Ma7adir_karar_7abes_9.Birthdate...

sorry coz i should ask my question with more details anyway it works sorry again and thank you so much

i write this and it works Printing_Date_001: IIf(Weekday([Printing_Date_01])=1;[Printing_Date_01]+1;[Printing_Date_01])

i want to do this in a query expression not in vba

i have a table contains 1. full name 2. email 3. date i want to make a query that will contain 1. full name 2. email 3. date1 4. date2 the date2 will be date1 + 90 days so if the result is a sunday i want to add one day or substract one day automaticly any help???

Thank you so much

hello guys this is my expression to format crosstab query by month Expr1: Format([Recharge_Date];Month([Recharge_Date])) but i can't make it with month and year any help???

Table1 contain Two fields (3Months) and (6Months) Table2 contain Two fields (3Months) and (6Months) the table 2 is the source of a form that will let the user change the numbers table 1 should change Date1 and Date2 Fields based on the two fields (3months) and (6months) could someone help me...

ok Sir thank you so much it works fine

hello guys i want to get a msgbox to let the user enter the data in specific textboxes so they can't let it empty if not empty then do ....... this is my code If Me.Client_Name.Value = "" Then MSG = MsgBox("You Should Enter The Client Name") ElseIf Me.Username.Value = "" Then MSG = MsgBox("You...

many thanks guys I appreciate your help

thanks guys i found the solution from this post http://www.access-programmers.co.uk/forums/showthread.php?t=263826 iif(is null([confirmedfield],"N/A",[confirmedfield])