Search results

Okay, this is working just fine. Dim strNewSql As String Dim qdf As QueryDef strSql = "SELECT * FROM qryEvents " & strWhere & ";" 'Delete the query if it already exists DoCmd.DeleteObject acQuery, "qryEvents_Search" strNewSql = "SELECT * FROM qryEvents " & strWhere Set qdf =...

okay, I think I want to create a a query def based on the Where statement I earlier created. Something like this: If Len(strWhere) > 0 Then If Nz(DCount("*", "qryEvents", Left(strWhere, Len(strWhere) - 0)), 0) > 0 Then strWhere = "WHERE " & Left(strWhere, Len(strWhere) - 0)...

I could do that but actually I dont want to ever open a report, I only want to export that report to a rich-text file: DoCmd.OutputTo acReport, "rptEvents", "RichTextFormat(*.rtf)", "C:\SARPCCO accdb\SARPCCO_Report.rtf" But first I need to create a query from the Where condition to base the...

Hi, I would like to know how to pass a WHERE condition behind my search button on a form to a query so that I can open reports based only on the search results from the Where condition. This is my code: If Len(strWhere) > 0 Then If Nz(DCount("*", "qryEvents", Left(strWhere...

Okay ridders, that's it! And YES i will comply with the field naming rule. I will be back if i need more help. Thanks alot

My original query used to be simple with just a crosstab query. But things become complicated because I needed a method to generated a graph by year interactively. I wish some here could just modify the file i attached. Its just driving me crazy now:banghead:

I hear you, I can try that too. Thanks.

Weird as it may seem, believe me - this is what works in the context of what was required of the database: generating quarterly graphs per year. It took me quite a while to get where it now is. What I am thinking now is probably to revisit the data range in the chart it self. Thanks anyways.

Hi, I am using a union query to generate a bar-chart based on data for year 2018 thus far. However, the query returns a wrong bar-chart when I enter a year that does not have data. For instance, open the form named "F_VENTS_STATISTICS" and enter 2017 in the prompt window; the data generated for...

Hi bastanu, I appreciate that. Thanks

Okay, I will check it out. Thanx

Hi, I have WHERE condition declared under a Search button for programmatically searching a table through multiple input controls on a form. I would like to know how i can open a filtered report based on the same strWhere condition. Under a CmdPrint button I tried DoCmd.OpenReport...

Thanx but the filter is not being applied after update. Private Sub txtEndDate_AfterUpdate() Me.Filter = "[Call_Date] =#" & txtEndDate & "#" Me.FilterOn = True End Sub

Hi, I have a continuous form bound to a query. I want to filter this form with any date inputted into a text box through a pop-up calendar control. The default date in the text box should be Date(). In the query, I set the criteria on Call_Date filled as follows but the form does not requery...

Actually, the extra criteria line in query design were not my doing; it seems to be generated automatically and I was also wondering why. I just wanted a simple way of filtering through the MS Access query and send the query to printer afterwards. Thank you for helping out. Joseph

Hi, I am creating a query that should filter records of events based on multiple fields. The filters should work with any combination of field criteria, but only two of the four field are working properly, as follows: 1. a text box for searching with event name (free text) - this is working...

Yes, that worked. Thanx alot.

Hi, I was looking for an ordinary calender I could re-use in my Access project, then I found just the kind I want done by Allen at http://allenbrowne.com/ser-51.html# I am using this calendar pop-up merely to check dates (not to populate any control). But my issue is that I want to change the...

I have a form that has a listbox and a subform. The listbox lists names of events, start date and end date. The subform bellow reveals names of participants to the event that is clicked in the listbox. Against each participant's name is a button to delete the participant. How can I hide or...

Ah! I now get it working. I guess it's easy to add a textbox for free text searching, too. Thank you spike