Search results

Sorry for late reply! It works ! thanks

I have done it but its not working.. any help?

HI all, I have a query designed on "Search Button" Click event as under, Private Sub btnsearch_Click() Dim SQL As String SQL = "SELECT DataBase.ID, DataBase.[Regi No], DataBase.[Farmer Name], Database.[MIS System], Database.[Area (Ha)]" _ & " FROM [DataBase] " _ & " WHERE...

Done !

Well Well ! I am always learning something new from you. This works like a charm Thank you very much !!!!

Exactly what I need... :)

I need data of current financial year only. I mean after a year the value will be from April-21 to March-22 . is this working here? I am asking as you have entered fixed date #2020-04-01# and #2021-03-31#. Or I have to change year every time? Thanks for the prompt reply.

Hi all, I need to get report of material sent by current week with a query. I am able to get report of current month by following funtion, Format([Material Sent Date], "yyyymm") - by this function I am able to get current month data and, Format([Material Sent Date], date()) - by this function...

I have two columns in list box "Registration Number" and "Client Name". And yes it serve my purpose very well. Works like a charm!!! Thanks for the prompt reply

Hi all, I've a material supplied entry form (and a table with same name also) which has two text boxes i.e Registration number and client name. Another table is "Data Table" where some other details about the client is saved (like address, pin code etc.). - Now I have created a search query...

Thanks for the reply.

Can you send me the sample data base with just name and date columns with the working query for my reference pls..

I am aware of this. Already get it working in current month format. But anyhow it does not work for current week..

the field is already a date/time format. And I am putting the format function in query filed. Is it alright or I m doing something wrong?

It both gives "Date type mismatch error"

Tried it and not working for me.

Hi all, I need to get report of material sent by current week with a query. I am able to get report of current month by following funtion, Format([Material Sent Date], "yyyymm") - by this function I am able to get current month data and, Format([Material Sent Date], date()) - by this function...

thanks will try definitely

Thanks for the prompt reply. Can you guide me how can I add a query to a special table which saves all my combo box data ? Thanks

Hi all, I've created my company data base on Access. Where there are two fields under customer table. 1. Village 2. Taluka I've put two combobox in my data entry form. 1. Villagecombo and 2. Talukacombo and put property settings to "Limit to list" and "Allow list edit on" but after some...