Recent content by sharpnote

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.