Just wanted to Thank you for this. I know its been several years since posting but this was the most comprehensive and detailed guide I've found and it was extremely helpful!
Thank you so much for this tutorial! I just want to add a little tidbit, in case anyone else has the same error I did due to the field being set in Date/Time Format. In the code, of the search button add the DateValue command. So instead it'll read: strCriteria = "(DateValue([Order Date] >= #" & Me.OrderDateFrom & "# And DateValue([Order date])
HI Sir Great Video Please May you advise how to total a field after the search i.e. if i search between a date range to have a box indicating the sum of the field totals
This was a big help. Calling myself a VB novice would be an understatement. If I had an addtional range of values to search, so that there were 2 serperate and independant ranges of criteria to look at, how would I add it? Example for above: Date and Total. A date range and a range of total value/cost? Thank you in advance.
Hi there, thank you so much for the tutorial! I worked for me, however, for some reason the date search only works if it is typed in as the American Format (i.e. MM/DD/YYYY), even though the data in my table is DD/MM/YYYY. Would you have any idea on why this is? THANK YOU!
austin, hi, good tutorial, thank-you...i have a table with date in date/time format, however i find running your script does not return correct records when searched on 1/7/2016 - 9/7/2016, but it is correct when searched on dates higher than single digit days e.g. 10/7/2016 - 16/7/2016. No records are returned for any single day searches. If i search 1/7/2016 - 15/7/2016 it returned correct records. Is there something I could be doing wrong or does the table date format have to be text formatted? Hope you can assist with suggestions for frustrated learning programmer :-)
Tewan, hi. thanks for your reply. On your answer basis, i dug around and found this worked for me. Because I am in Australia, we use dd/mmm/yyyy as the format. So my strCriteria was.... strCriteria = "([ActivityDate] >= #" & Format(Me.srchstrtdate, "dd/mmm/yyyy") & "# And [ActivityDate]
hello I tried your code, but it applies it only once, if I repeat it the first one remains stored even by pressing the cancel filter keys or show the records. what am I doing wrong?
Excellent tutorial. Thank you very much. Can you please guide if it is possible to enter just one date instead of date range and view the records for that one date only?
Hi Nana, Thank You so much for your tutorial. it works great. Now i have another issue that my date search doesnt display any records with null date values for my report. can you please help me out with this???????????????????
Thank you. I've learned a lot from your video. I have a question how about if i dont want to include the year on the date. Just only the month and day only. How can i do that? Pls help, I used it in our church data base at its working well. I applied it on how to know the person that will celebrate their bday and wedding anniv one week before sunday. Thank u for your favorable response
HI, I've been able to use the info and got everything working except for the Count. No matter how much I try and tweak, it's just not happening. Any ideas?
can u please show me how to make a search form with all tables at once not selective. i mean combining all tables to one search from, if i have 5 tables so i should be able to search data in all 5 tables at once please help from scratch...
in your video, you manually entered a date instead of through date picker, any reason? in my case, I have range error if through date picker and ok if manually entered but in reverse date and month. Please enlighten me on this. thanks very much...
task = "select * from tblemp prod table where (" & strcriteria & ") order by [date]" DoCmd.ApplyFilter task whats wrong here i ran the code 20 times but still coming back with syntax error. plz any help would be appreciated.
Dear Austin I can use vba code same as in your video tutorial. But search button option is not working the other buttons like clear and all records options is work perfect. So, you please give suggestions for solve the problem.
hello Mr. Tewan😊 im following your ms access programming as of now I am doing an office project that will benefit my department..I just followed this video I created a search form. My questions is How about the combination of the DATE (Start date to End date) and combo box all together? can you help me give an example specially the codes that is needed to create this form..thank you in advance😊 hoping that you could help me
I have the sample file my website. However, it needs a little donation for my hard work. Thank you. link here: www.iaccessworld.com/downloads/search-multiple-fields/
Search button is not filtering the date range specified. I tried not to use the square brackets around Order Date because mine is "InvDate", but it failed to filter. Please help
I cannot do that like you. When I press on search button I got error message Run time error 3000 (-3201). When I click on debug I see that in code "DoCmd.ApplyFilter task" is higllighted :/ Any ideas?
i have try these code but when i have type 01/08/2016 and 10/08/2016 it also showing 08/01/2016 and 08/10/2016 please help me (:)))))):(((((((((:((((())))))))
Hi Austin, I have used your exact codes with just the name change but still I got an error message for the below code "Me.RecordSource = task" Run time error 2580 The record source "Select *From From ProjectedLabourCostbyCategory1 order by [DATE]" secified on this form or report does not exist. I have the below code written. Please advice how to correct. Private Sub Command18_Click() Dim task As String Me.DateFrom = Null Me.DateTo = "" task = "select * From ProjectedLabourCostbyCategory1 order by [DATE]" Me.RecordSource = task
HI Austin . Please, help me to display a calculated Field in a form to be displayed in a report. Notice that this calculated value shows number of Family members(in sub form) which means The Father(in main form ) + the rest of family (All in one form). Moreover the calculated value is not reflected in any table. Access 2010 Thanks in advance
I use MS 2016 but when I clicked Property sheet>> Event>> On Click>>> Event Procedure>> 3 dots system give me error @ Access failed to create the Visual Basic module What happens please help mee((
How can you create a date range for a subform from a form? I saw your video for how to create a combo box for a subform but I need to know how to use a date range. Can you help? Thank you in advance.
you will use the search function with date range criteria on main form then assign as a recordsource on subform. like: strSearch = "SELECT * FROM TableName where " & Criteria & "" Me.Subformname.RecordSource = strSearch If you are using a split form then you can use a filter like: Me.FilterOn = True DoCmd.ApplyFilter strSearch
Firstable amazing video but doesn't work :( Can you help please? I apply as you mention with the "Me" Declaration in the code but Excel vba don't recognize Dim StrCriteria, task As String Me.Refresh If IsNull(StartDate) Or IsNull(FinalDate) Then MsgBox "ESCRIBIR FECHA", vbInformation, "FECHA REQUERIDA" StartDate.SetFocus Else StrCriteria = " ([Fecha]>= #" & StartDate & "# And [Fecha]
Could you please help me with this... . I am getting a runtime error in which "DoCmd.ApplyFilter" is highlighted. How to rectify this error. I am using the query, so I don't know if I have to include different expression because the screen show me Syntax error (missing operator0 in query expression .
I just copy exactly as this video. On Click (Event Procedure) it will open the VBA window. Then right click on the left panel (Project Database). Then click Insert>Module. All you have to do now is copy exactly like he type in this vids : Function FindRecordCount(strSQL As String) As Long Dim db As Database Dim rstRecord As Recordset 'On Error GoTo ErrorHandler Set db = CurrentDb Set rstRecords = db.OpenRecordset(strSQL) If rstRecords.EOF Then FindRecordCount = 0 Else rstRecords.MoveLast FindRecordCount = rstRecords.RecordCount End If rstRecords.Close db.Close Set rstRecords = Nothing Set db = Nothing End Function Save it and everything should be ok.
There is actually another way which is more simple than this. Just use Count function. First create a label or text box on your form. Then open the Property Sheet. Under the Data tab, u will see Control Source on the 1st row. Just type =Count(*) This function will do the same job which is counting the number of the record in your recordset below. Good luck!
Same here. It works fine in the split form itself, but when I try to place it in navigation form, all the controls work but it's only showing the top part of the form, not the bottom datasheet view with the results of the filter
Private Sub ShowAll_Click() Dim task As String Me.IssuedDateFrom=Null Me.IssuedDateTo= "" task = "Select * from SearchbyDateRange order by [Issue Date]" Me.RecordSource = task
Hi Austin, I have tried to modify your example in this video but I receive nothing as a result of the search. Please help. Private Sub CmdSearchDate_Click() Dim strCriteria, task As String If IsNull(Me.StartDate) Or IsNull(Me.EndDate) Then MsgBox "Tanggal keduanya harus diisi", vbInformation, "Date Range Required" Me.StartDate.SetFocus Else strCriteria = "([dBKK] >= #" & Me.StartDate & "# And [dBKK]
Hello Austin, great video. I learned a lot from it and I like the way you present it step by step. I'm having an issue when i try add the findrecordcount function in there. Run-time error '3078': The Microsoft Access database engine cannot find the input table or query "tbl_StudentInfo". Make sure it exists and that its name is spelled correctly.
How do I get this to work in dd/mm/yyyy rather than mm/dd/yyyy. strCriteria = "([Date 1st Contact]>= #" & Me.txtContactfrom & " # and [Date 1st Contact]
hi. thank you for the tutorial that you are uploading... i like this video.... how ever how can I search the upcoming birthday for the week regardless of the year using this date range ? pls help me.... kindly upload how can i do that....
you can set a birthday to the date of current year then perform a search function for next week. I don't have details at this time. but it is the logic above.
hi thanks for the reply.. but the problem is, it does not show anything when the i search the birthday for next week.. because it search only the current year...
hi thanks for the reply.. but the problem is, it does not show anything when the i search the birthday for next week.. because it search only the current year...
Thanks @austin72406 , it helped me in my task. However, After searching data between two dates, I need to generate sum of a particular field in the data and also, generate a report of that data searched. Could you please help me with that ? Thanks again!
+austin72406 😯 I hope you can create a tutorial for it, I'm your fan and subsciber, and I almost created a database because I watch your video tutorials, that help me a lot,
You can use same criteria from Search function on report. Or you can create a temp query or table for a result of search function then set that table as a datasource of report to print
Hi Thanks for your videos, they are really helpful. However am getting a runtime error 3075. and the debug screen looks like this, but i cant seem to figure it out. Please help. Thanks
please create a video tutorial, for fiscal year, when you search an item/product/materials or etc., the total amount for fiscal year(April 2015-March 2016 = year 2015), (April 2016-March 2017 = year 2016) per item/product/materials will show, thank you so much! please....
Super Excellent............Bundle of Thanks Sir...........It solved my issue regarding selection of data in date range........
Just wanted to Thank you for this. I know its been several years since posting but this was the most comprehensive and detailed guide I've found and it was extremely helpful!
Thank you so much for this tutorial! I just want to add a little tidbit, in case anyone else has the same error I did due to the field being set in Date/Time Format. In the code, of the search button add the DateValue command. So instead it'll read:
strCriteria = "(DateValue([Order Date] >= #" & Me.OrderDateFrom & "# And DateValue([Order date])
Excellent video to understand search by date. Thank you so much.I find it very useful...
Can you help me with the codes you used? You did a great presentation honestly this is one of the best presentation on this topic.
Great video.. Can I filter data in 3 different forms with single date crietria
Merci pour cette video. Très explicite. Très utile. J'en ai beaucooup appris.
MS ACCESS IS IMPRESSIVE SOFTWARE.. THANKS FOR TEACHING
you're welcome
DoCmd.Applyfilter task is not working please help?
HI Sir Great Video Please May you advise how to total a field after the search i.e. if i search between a date range to have a box indicating the sum of the field totals
Excellent tutorial. Just what I was looking for. Thank you!!
This was a big help. Calling myself a VB novice would be an understatement.
If I had an addtional range of values to search, so that there were 2 serperate and independant ranges of criteria to look at, how would I add it?
Example for above: Date and Total. A date range and a range of total value/cost?
Thank you in advance.
you just add two criteria by using And operator.
you are great teacher and specialist!!
DoCmd.ApplyFilter task - in these what is task while i try to do this an error seen on that cmd why
Hello I am getting syntax error too were you able to solve the problem?
Hi there, thank you so much for the tutorial! I worked for me, however, for some reason the date search only works if it is typed in as the American Format (i.e. MM/DD/YYYY), even though the data in my table is DD/MM/YYYY. Would you have any idea on why this is? THANK YOU!
same problem here ,have you foundany clue how to resolve the issue please
austin, hi, good tutorial, thank-you...i have a table with date in date/time format, however i find running your script does not return correct records when searched on 1/7/2016 - 9/7/2016, but it is correct when searched on dates higher than single digit days e.g. 10/7/2016 - 16/7/2016. No records are returned for any single day searches.
If i search 1/7/2016 - 15/7/2016 it returned correct records.
Is there something I could be doing wrong or does the table date format have to be text formatted? Hope you can assist with suggestions for frustrated learning programmer :-)
it's possible of date format in Europe and USA
Tewan, hi. thanks for your reply.
On your answer basis, i dug around and found this worked for me.
Because I am in Australia, we use dd/mmm/yyyy as the format.
So my strCriteria was....
strCriteria = "([ActivityDate] >= #" & Format(Me.srchstrtdate, "dd/mmm/yyyy") & "# And [ActivityDate]
genius!!! - well done mate works a treat
OMG! u just solved my problem! thank you!
@@williamkolln8099 great bro, it works for me. 😊
The exact thing I was looking for
Nice tutorial.. Thanks
hello I tried your code, but it applies it only once, if I repeat it the first one remains stored even by pressing the cancel filter keys or show the records. what am I doing wrong?
Excellent tutorial. Thank you very much. Can you please guide if it is possible to enter just one date instead of date range and view the records for that one date only?
Hello. Enter the same date in both text boxes.
@@sebastiansalazar3553 when I enter same date, its not working. I had enter next date in [to]. Any ideas?
Hi Nana,
Thank You so much for your tutorial. it works great.
Now i have another issue that my date search doesnt display any records with null date values for my report.
can you please help me out with this???????????????????
Thank you. I've learned a lot from your video. I have a question how about if i dont want to include the year on the date. Just only the month and day only. How can i do that? Pls help, I used it in our church data base at its working well. I applied it on how to know the person that will celebrate their bday and wedding anniv one week before sunday. Thank u for your favorable response
I really hope the author will answer this question
Hi Austin. I couldn't find this tutorial in Download Section of your website. Please let me know.
HI, I've been able to use the info and got everything working except for the Count. No matter how much I try and tweak, it's just not happening. Any ideas?
can u please show me how to make a search form with all tables at once not selective.
i mean combining all tables to one search from, if i have 5 tables so i should be able to search data in all 5 tables at once
please help from scratch...
you may need to combine tables into one query then use it as a record source of search form.
+austin72406 OK. but can u make a simple video for it?_plz
in your video, you manually entered a date instead of through date picker, any reason? in my case, I have range error if through date picker and ok if manually entered but in reverse date and month. Please enlighten me on this. thanks very much...
task = "select * from tblemp prod table where (" & strcriteria & ") order by [date]"
DoCmd.ApplyFilter task
whats wrong here i ran the code 20 times but still coming back with syntax error.
plz any help would be appreciated.
hi austin
i used same date range but it wont show end date data. Ex. if we put end date 28/03/2017, it will show up to 27/03/2017 only. Please help
Dear Austin
I can use vba code same as in your video tutorial. But search button option is not working the other buttons like clear and all records options is work perfect. So, you please give suggestions for solve the problem.
is it possible to download it?
hello Mr. Tewan😊 im following your ms access programming as of now I am doing an office project that will benefit my department..I just followed this video I created a search form. My questions is How about the combination of the DATE (Start date to End date) and combo box all together? can you help me give an example specially the codes that is needed to create this form..thank you in advance😊 hoping that you could help me
I have the sample file my website. However, it needs a little donation for my hard work. Thank you.
link here: www.iaccessworld.com/downloads/search-multiple-fields/
Search button is not filtering the date range specified. I tried not to use the square brackets around Order Date because mine is "InvDate", but it failed to filter.
Please help
I cannot do that like you. When I press on search button I got error message Run time error 3000 (-3201).
When I click on debug I see that in code "DoCmd.ApplyFilter task" is higllighted :/ Any ideas?
It was great. thank you
i have try these code but when i have type 01/08/2016 and 10/08/2016
it also showing 08/01/2016 and 08/10/2016
please help me
(:)))))):(((((((((:((((())))))))
you have to make a right format of date for your region.
@@austin72406 thank u man it work big loke to u
DoCmd.ApplyFilter task - in these what is task while i try to do this an error seen on that cmd why?
i have the same problem
i have two date area in my table. How can i set this form with two date area. Thank you.
Hi Austin,
I have used your exact codes with just the name change but still I got an error message for the below code "Me.RecordSource = task"
Run time error 2580 The record source "Select *From From ProjectedLabourCostbyCategory1 order by [DATE]" secified on this form or report does not exist.
I have the below code written. Please advice how to correct.
Private Sub Command18_Click()
Dim task As String
Me.DateFrom = Null
Me.DateTo = ""
task = "select * From ProjectedLabourCostbyCategory1 order by [DATE]"
Me.RecordSource = task
check your SQL statement again. Please make sure you have correct table name or field name in table.
The names are correct as all buttons are working except "Show All where I am getting an error message for the code "Me.RecordSource = task"
I am getting a runtime error in which "DoCmd.ApplyFilter" is highlighted. How to rectify this error.
Pls help me
The msgbox is work properly. But I cant search the date, after I clicked "Search", the "Enter Parameter Value" msgbox appear. Pls help
Thank you so much, Sr.
Welcome!
Hello,
Please help how to select all record after search wit VBA
Thank you
Month wise?
please help me! i do all the process but at the end it can not display the search result
HI Austin .
Please, help me to display a calculated Field in a form to be displayed in a report. Notice that this calculated value shows number of Family members(in sub form) which means The Father(in main form ) + the rest of family (All in one form). Moreover the calculated value is not reflected in any table. Access 2010
Thanks in advance
what if the list i want to search is from a query??
I use MS 2016 but when I clicked Property sheet>> Event>> On Click>>> Event Procedure>> 3 dots system give me error @ Access failed to create the Visual Basic module What happens please help mee((
How can you create a date range for a subform from a form? I saw your video for how to create a combo box for a subform but I need to know how to use a date range. Can you help? Thank you in advance.
you will use the search function with date range criteria on main form then assign as a recordsource on subform.
like:
strSearch = "SELECT * FROM TableName where " & Criteria & ""
Me.Subformname.RecordSource = strSearch
If you are using a split form then you can use a filter like:
Me.FilterOn = True
DoCmd.ApplyFilter strSearch
Firstable amazing video but doesn't work :(
Can you help please?
I apply as you mention with the "Me" Declaration in the code but Excel vba don't recognize
Dim StrCriteria, task As String
Me.Refresh
If IsNull(StartDate) Or IsNull(FinalDate) Then
MsgBox "ESCRIBIR FECHA", vbInformation, "FECHA REQUERIDA"
StartDate.SetFocus
Else
StrCriteria = " ([Fecha]>= #" & StartDate & "# And [Fecha]
Could you please help me with this... .
I am getting a runtime error in which "DoCmd.ApplyFilter" is highlighted. How to rectify this error.
I am using the query, so I don't know if I have to include different expression because the screen show me
Syntax error (missing operator0 in query expression .
Hello getting the same problem. Were you able to solve that problem?
Hai Austin,
Can you show me how to add the count function like yours. Everything else is just perfect bos. Really appreciate your help. Thanks!
I figure it out. I just screenshot and copy exactly like your code. And it works!! Thanks Austin. U have save me a lot of time.
Hi Syukri, I've not been able to make it work. How did you do it? I copied exact same function but I get error saying it's not defined.
I just copy exactly as this video. On Click (Event Procedure) it will open the VBA window. Then right click on the left panel (Project Database). Then click Insert>Module. All you have to do now is copy exactly like he type in this vids :
Function FindRecordCount(strSQL As String) As Long
Dim db As Database
Dim rstRecord As Recordset
'On Error GoTo ErrorHandler
Set db = CurrentDb
Set rstRecords = db.OpenRecordset(strSQL)
If rstRecords.EOF Then
FindRecordCount = 0
Else
rstRecords.MoveLast
FindRecordCount = rstRecords.RecordCount
End If
rstRecords.Close
db.Close
Set rstRecords = Nothing
Set db = Nothing
End Function
Save it and everything should be ok.
There is actually another way which is more simple than this. Just use Count function.
First create a label or text box on your form. Then open the Property Sheet. Under the Data tab, u will see Control Source on the 1st row. Just type =Count(*)
This function will do the same job which is counting the number of the record in your recordset below.
Good luck!
I figured it out. I created the Function module separately THEN copied the FindRecordCount and it worked. But thanks!
How would you make this work in a Navigation form? I keep getting a runtime error. But it works fine in the regular form.
Same here. It works fine in the split form itself, but when I try to place it in navigation form, all the controls work but it's only showing the top part of the form, not the bottom datasheet view with the results of the filter
hi,
below error runtime error 3075
Else
strcriteria = "([Order Date]>= $" & Me.OrderDateFrom & "$ And [Order Date]
Thank you it works, and It is very useful....
But i have a problem!
When I want to use Hijri calendar, it doesn't work!
it might be a problem with date format on your region. you may create database with data from your program then use similar method on this video.
Thanks
hi austin! if I click show all after t search data, my Id num doest display from 1 to 1000 anf so on..all are in a mess.
can you show your code for Show All
Private Sub ShowAll_Click()
Dim task As String
Me.IssuedDateFrom=Null
Me.IssuedDateTo= ""
task = "Select * from SearchbyDateRange order by [Issue Date]"
Me.RecordSource = task
you may need Me.Requery after Me.RecordSource = task
great! thank you so much for that tutorial sir... can u add a cmdbutton to print the searched record.. thanks.. i cant wait to see it.
yes, on your search function or code, you can use the same criteria to use with report.
ROWELL LAZARO do u have the code for this? i also need to print the searched data
you are rocking man !!!!
Hi Austin, I have tried to modify your example in this video but I receive nothing as a result of the search. Please help.
Private Sub CmdSearchDate_Click()
Dim strCriteria, task As String
If IsNull(Me.StartDate) Or IsNull(Me.EndDate) Then
MsgBox "Tanggal keduanya harus diisi", vbInformation, "Date Range Required"
Me.StartDate.SetFocus
Else
strCriteria = "([dBKK] >= #" & Me.StartDate & "# And [dBKK]
Hi Austin, Great tutorial. However I am getting a runtime error in which "DoCmd.ApplyFilter" is highlighted. How to rectify this error.
Hi I am getting the same problem were you able to solve the problem?
I have a table that has employee's scores for each day and I need to make a form that lookup the agent name and his performance in specific date.
you can use the = sign like
strcriteria = "([EffectiveDate] = #" & Format(Me.SearchDate, "mm/dd/yyyy") & ")#"
how can i make a report after selecting date range?
THANKS! HELPED ME A LOT!
Hello Austin, great video. I learned a lot from it and I like the way you present it step by step. I'm having an issue when i try add the findrecordcount function in there. Run-time error '3078': The Microsoft Access database engine cannot find the input table or query "tbl_StudentInfo". Make sure it exists and that its name is spelled correctly.
not just a table name correct, also make sure all code correct including the SQL statement too and other code under that sub procedure.
is it possible without spilt form ? how it works if the recordsource is supform?
yes, you just use the Select statement with the criteria from search function to be a record source of subfom
Hi..can I use a query table instead of table only?
you will need to create a query first then use it as a data source of your form
Thank Helped full video , but sir, i have create report selected record but not done plz. help
How do I get this to work in dd/mm/yyyy rather than mm/dd/yyyy. strCriteria = "([Date 1st Contact]>= #" & Me.txtContactfrom & " # and [Date 1st Contact]
hi. thank you for the tutorial that you are uploading... i like this video.... how ever how can I search the upcoming birthday for the week regardless of the year using this date range ? pls help me.... kindly upload how can i do that....
you can set a birthday to the date of current year then perform a search function for next week. I don't have details at this time. but it is the logic above.
hi thanks for the reply.. but the problem is, it does not show anything when the i search the birthday for next week.. because it search only the current year...
hi thanks for the reply.. but the problem is, it does not show anything when the i search the birthday for next week.. because it search only the current year...
how can i search the birthday of the person born ten years ago or more?
how can i search the birthday of the person born ten years ago or more?
THIS IS AWESOME THANK YOU!!!
I'm willing to pay for the sample if you have one?!?!?!
can u help me , it is very useful for me but i cant complete
me, getting error msg
so kindly explain from the beginning?
how to print report date range ?
is there a macro equivalent to this? i have no idea what im doing
never mind, i figured it out..thanks
Thanks @austin72406 , it helped me in my task.
However, After searching data between two dates,
I need to generate sum of a particular field in the data
and also, generate a report of that data searched.
Could you please help me with that ?
Thanks again!
How to Create Search and print by Date Range: MS Access
hi austin, how about generate chart base on search result?, do you have a tutorial for that?, highly appreciate your kindness and help😊
sorry I don't have video for that, but you can create a query or temp table from the search result then create a chart from there.
+austin72406 😯 I hope you can create a tutorial for it, I'm your fan and subsciber, and I almost created a database because I watch your video tutorials, that help me a lot,
Total taka show korano jabe ki???
THANK YOU FOR YOUR VIDEO , BUT I WANT TO KNOW HOW TO CREATE REPORT BASE ON DATE RANGE MS ACCESS
check this out. It may be the one you want. I have a How To at my website:
www.iaccessworld.com/macro-how-to-transfer-data-from-form-to-report/
Thank you sir. I will try it.
Problem with applyfilter please
austin how to print the searched data?
You can use same criteria from Search function on report. Or you can create a temp query or table for a result of search function then set that table as a datasource of report to print
Hi Austin i still cannot get it correctly..Can u type the code pls.
Hi Thanks for your videos, they are really helpful. However am getting a runtime error 3075. and the debug screen looks like this, but i cant seem to figure it out. Please help. Thanks
any thing can cause it. Please check a related code that was highlighted by program.
Thanks in advance about your video,
i really appreciate that,
@austin72406 : how I can print the result after I search it?
i want to know also
Need help with this.
how can I download the tutorial ?
download the example file at my website: www.iaccessworld.com/download-sample-access-file/
thanks for video
the buttons don't work on the table
thanks
not working as per your procedure don't know why
ADMIN ADD REPORT ?
thanke for Answer But it's came like image not like logo
Thanks
Thanks, shared file please...
please create a video tutorial, for fiscal year, when you search an item/product/materials or etc., the total amount for fiscal year(April 2015-March 2016 = year 2015), (April 2016-March 2017 = year 2016) per item/product/materials will show, thank you so much! please....
I will try to do it when I have time.
+austin72406 Hi Austin,, Thank you so much! I higly appreciate it, God Bless you more.....
thank you I get it
please I want Know How to insert this logo searsh
just use the insert image from menu bar
I have an issue when I click on "Search" I get nothing :/
Solved it! But now cant get the proper result. Any idea?
Everything working fine! I used "yyyy-m-d" for the date format :)
@@yannickogoubiyi141 how did you solve it? I have the same problem
rs.recordcount is returning -1
Pls sir this access file send me
Pls sir sen me i need it argently
this is not a tutorial just avert to buy the sample, NOT good
Thanks