Search results

no sir it's not my object names and it doesn't work coz am getting an error the microsoft access database engine does not recognize '[Forms]!frm_inspections_search]![StartDate]' as a valid field name or expression

guys another question plz how could i filter this data between two dates i put on the criteria of the date field >=[forms]![form1]![date1] And <=[forms]![form1]![date2] but i get this erroryou cant specify criteria on the same field which you entered value in the crosstab any help?

i don't know if i can describe my problem but i will try i have a table Name | Date | Type Roy | 1-1-2016 | ANV Tony | 5-1-2016 | ANV Grey | 12-1-2016 | XEV Roy | 14-1-2016 | XEV Tony | 18-1-2016 | XEV Grey | 22-1-2016 | XAV Roy | 24-1-2016 | XAV Tony | 25-1-2016 |...

thank you everything is ok i changed , to ;

i have two columns (CodePrefix) and (CodeNumber) in a table i changed (CodeNumber) format to 00 so i get the right result (01-02-03-04-...) now i created a query and i added this two fields and i created a calculated field [CodePrefix] & "-" & [CodeNumber] CodePrefix = W-MUG CodeNumber = 01...

i uploaded a simple of my database could you please help me to do what you tell me

what am doing is enter the purchases invoices so if i buy white mugs today and i add it if the white mugs is already in the stock it will take the white mugs code but if it's a new item it will take a new id this is why i want to store the codes

i have a table contains three fields (id - category - description - code) 1- Mugs - white - MUG01 2- Plate - 3D 8" - PLA01 3- Mugs - colored - MUG02 4- Mobile Cover - iphone 6 - MOB01 5- Mobile Cover - note 5 - MOB02 so i want to enter the category and the description then the code will be...

sneuberg you are genius thank you so much for everyone in this post ans specially you

ok sir this is my database link http://www.filefactory.com/file/6y77y6k93sqb/RyBaKoV%20Database.accdb the form name is frm_videos_list and the text box is text41 thanks in advance remember eveything is ok but i can't use the space i just can make search for one word that's my problem

thanks for your try but i don't have a sub form it's on the same form where my records will show in the details section of the form

thank you guys for your helo my problem was that i didn't set limit to list to yes

the problem is i don't get the first msgbox

Hello Guys every video i enter to my database will get a unique ID for example 1 Rain Man 99 Cyborg what i want to do is when i save the record to get a message box contains the id with prefix the prefix should be V000000 so when the id is 1 the message box should give me V000001 if the id...

Hello Guys i want to add the text that in not in the combobox list here is my code Private Sub video_series_NotInList(NewData As String, Response As Integer) On Error GoTo video_series_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The Serie " &...

hello Guys when i save my record everything is okay but if the name of the movie contain ' i can't save it how to let the vba accept " in my movies name this is my code strsql101 = "insert into tbl_videos (video_name, video_genre, video_duration, video_size, video_date, video_language...

Hello Guys i want to filter my continuous form on change event not after update i use this code Dim strFilter As String Me.Refresh strFilter = "video_name like '*" & Me.Text41 & "*'" Me.Filter = strFilter Me.FilterOn = True but i can't type more than one letter so i add this line...

thank you all it works fine i used the solution of BlueIshDan thank you a lot

Private Sub ConcatLabel() Dim i As Integer Dim strString As String For i = 1 To howManyCheckBoxYouHave strString = IIf(Me.Controls("chkBox" & i), Me.Controls("lblLabel" & i).Caption & " - ", "") Next If Len(strString) > 0 Then strString = Left(strString, Len(strString) - 3) Me.video_genre.Value...

hello Guys I made a form to choose movies genres everything is ok but is there any way to reduce the code N.B: am new to access Private Sub cmd_send_data_Click() Dim vg As String If Me.Toggle0.Value = False Then ElseIf Me.Toggle0.Value = True Then If vg = "" Then vg =...