Search results

Hi Paul, I am getting an error "Syntax Error" and the table just opens up in datasheet view Date : is a field used for dates (Calendar) City : is a text field (combobox name citycombo) Depots : is a text field (combobox name depotscombo) Vendor : is a text field (combobox name vendorcombo)

Hi Paul, I am still getting the error at the same lines "Syntax error"

Hi, I have a form Delete which contains four fields i.e. Date, City, Depots and Vendor, which has combobox. I am trying to delete a record from table "Sheet1" based on the combobox, for which i have written the following code, but getting an error at the lines highlighted in red : Private...

Thanks a ton for your help, this is the exactly what I wanted. I will sure looking to the points what you have mentioned, probably in my future posts, you will see the improvement Thanks

I am not too good or very familiar with VBA (know some Basics), but with your guidance I can do that too. I need to get the desired output, that its, whatever the user opts for needs to be the output in datasheet view (even if the user doesn't select all the 6 options). Thanks.

The SQL statement works out fine, thanks for the same. But is there any way around where there is no need to fill all the options in the form, and still we get the data for those which has been filled. I know i am asking too much :) Thanks

I will make things pretty simple, I have a form name "Find", in which there are 6 options for the user to select. Whatever the user selects out of these 6 options, I need the output (the filtered table) in the datasheet view (Whatever the user has selected in the "Find" form. I am now totally...

Sorry for confusing you. I want a simple search form where the user opts for a particular search string (the above code, helped me to filter out the data), now what I need is to show the filtered multiple records in the datasheet view, so the user can make the changes. Presently the code...

Please find attached database, the code is published on the command button of the "Find" form, however here goes the entire code Private Sub cmdGenerateReport_Click() On Error GoTo Err_cmdGenerateReport_Click Dim stDocName As String Dim stWhere As String Dim stDates As String...

I want to open a query output in edit mode, presently the code below is used for report, I want it for query i.e. to open table in edit mode stDocName = "Search" DoCmd.OpenReport stDocName, acViewReport, , stWhere I am unable to open the query using the below code, it gives me an error...

Hi Mihail, Thanks for your solution. I was wondering if you can help me on openning a query in edit mode, presently the code mentioned below is for report, i want it to make for query : DoCmd.OpenReport stDocName, acPreview, , stWhere I am getting an error for the query code mentioned...

Hi, I forgot to mention one more thing, I have one combo box named Vendorcombo, where the vendor combo list has a space between name for e.g. "ISS SDB", for these I am getting an error "Syntax error (missing operator) in query expression '[Vendor]=ISS SDB'." These errors are repeated...

Hi, I have modified the code as per my requirement, but once i click the command button after selecting one of the combo boxes, it is poping up a window asking to "Enter Parameter value" if I skip this blank records are thrown, whereas if I enter the parameter value the same text what is...

Hi, I am unable to get multiple search output using the below code in queries, the search text is based on form : Search form name : Find Query name : Search Table name : Sheet1 [forms]![find]![city] The above works fine if it is only used in one of the fields, but as soon as I have it...