Search results

Thanks Galaxiom, my bad. It is not in the form, I should write, "it is encoded in a datasheet form". Ok, I'll try your suggestion and check out the link. Thanks again. Cheers!

I need your help. How do you group or summarized result of Query1 to appear like in Query 2. The source of data of field3 is from a datasheet form where multiple data is stored. I tried using assignedto and value but apparently it is only for combo/list box source data. Query 1 Field1 . . . ...

My apologies for late reply. Noted all your comments. Thank you

I develop my database on my laptop. When I installed it on a desktop, the whole form was a mess. Only half can be viewed, the fonts are large, etc. How do you fix this? Thanks

Great!... it's working. Thanks a lot pbaldy!!!!

This is what I got, after replacing the age with date ' Check for before date If Me.txtbeforedate > "" Then varWhere = varWhere & "policy_date > #" & Me.txtbeforedate & "#"" And " End If ' Check for after date ' If Me.txtafterdate > "" Then ' varWhere =...

In my first post, the code was for the age, following your sample code for dates, I replace the age with date and this is what I made ' Check for before date If Me.txtbeforedate > "" Then varWhere = varWhere & "policy_date > #" & Me.txtbeforedate & "#"" And " End If '...

The error message was "Run time error 3075': syntax error in string query expression [fieldName] < # date# This was highlighted in yellow, when I debug the code. ' Update the record source Me.frmsubqrypolicydata.Form.RecordSource = "SELECT * FROM qrypolicydata " & BuildFilter

Thank you pbaldy for the quick response. I followed the baldyweb sample and I got this highlighted error. I check record source and my query, it seems everything is in order. What gives? thanks ' Update the record source Me.frmsubqrypolicydata.Form.RecordSource = "SELECT * FROM...

I came across a sample code for multiple field search form (please see below). One of the variables is the age. I wanted to replace it with date so that I can do search for particular date range. How can I modify the codes below. Thanks a lot Private Sub btnClear_Click() Dim intIndex As...

Thanks DJKarl. But that's my problem, the controls are all 2010. will runtime install solve the problem?

My database was developed in Ms Access 2010. How can I make it run in MS access 2007.

My database was developed in 2010. How can I make it run in MS access 2007.

It is working!!! Thanks a lot John Big Booty. Hope I can count on you next time around. thanks

Thank you John Big Booty. Though I haven't tried the code due to tremendous work load lately, I'll try this and get back to you as soon as I can. Thanks again.

I have a form with search field which when filled up returns a particular record based on a query. Now, I wanted to open that particular record on a form where it was encoded. please help. thanks

Yes pr2-eugin. I did and so far it's working, I'll be putting more data and let's see how far will it go.

I tried it and it's working for the meantime having only 49 records. I'll be damned! just a minor placement of "*" made a lot of difference and big result. I know this will be problematic once the database becomes big. If you can give me the correct code for the memo, much appreciate. Thanks again.

Hi pr2-eugin, Thanks for the reply. Actually, I'm not so familiar with vba codes. I downloaded a free code for dynamic search box. I know the codes are for text field data type, that's why I emphasize in my question that this field is a memo type. Could you please give me a code appropriate for...

Hi! I'm developing a program to search several fields. One of which is a memo field with large characters. Using wildcard in the search form I made, it only returns the record if the first word of the field is typed in the search box. I want to type any word in any part of the field to return...