Search results

Hi Krunal thanks for the reply, I had tried your suggestion still same error message. The query works fine . I had to tried to send the results to a form and it is working ok But when i try to use this one select * from merge_query_true then it fails....is that code ok or I had to make...

Hi, yes, it is opened.

Hi all I had a query and the sql is SELECT Institutions.*, Institutions.merge, Institutions.Inst_type FROM Institutions WHERE (((Institutions.merge)=True) AND ((Institutions.Inst_type)=[forms]![merge_inst_type]![Inst_type])); and I had a command button which process MergeAllWord ("select...

Hi all, I had a form which I am using for logon to db. the form is working fine, But i had a small doubt in that. When I typed password and press enter key it is only chaning the selection to my command button. Again I had to press the command button to activate the code for command button. If...

MStef, Nice trick..thanks :D

MStef, sorry for the trouble..I had attached a sample db. In that you can see everytime when form open command button is selected......I like to get rid of that.... thanks

hi Mstef, thanks for the reply, It worked , One more question..can I clear the selection at all???? thanks

Hi all, anyone know how I can clear default selection mark from a command button.Why I am asking this becuase, in my form if I had clicked on a command button, when I open that form again , the button which I had pressed still selected...Is there any way I can clear this.. Thanks in advance...

Hi all, I had a form with a command button which invokes email sending option to send a report..I am using code sample which I got from this forum.I thank that guy for posting that code in this forum. The code which I am using is here:- 'This will create the e-mail DoCmd.SendObject...

Hi all, I got that.here it is Me.percent_amt = (Me.percentage / 100) * Me.amount thanks

Hi all, I had a form which is used for update an invoice.In that I had 3 fields. 1. amount 2.percentage 3.percentage amount. the field [percentage amount] will be the result of [amount]%[percentage]. I am attaching a sample db ..If someone can please help me... Thanks in advance Thanks

SJ, That worked.....thanks :)

Hi all, Is there any way to open a form in its normal size???...I had a form with command button which load another form. The main form is opening with docmd.maximized on in its load event.. but I want the next form to be opened in its normal size...Can it be possible????? thanks in adance...

Hi all, I don't know whether this is possible...I had a report based on a query. which is to print envelopes of the customers. Is there any way, can I select which ones needs to print I mean I need to select which ones should print . Thanks in advance Thanks

Hi all, I had a form which had a subform in it..The form is for searching..Is there any way to clear the results in the subform from a command button in mainform.Now I had to close the form and open it again if I want to search again.... Thanks in advance Thanks

Hi all, I had a database which is splitted to BE and FE. I had copied FE to all the user computers and it is working fine. My issue is that when two or more users access the DB same time, it is taking around a minute to load the forms..If only one user, then it flies...Anyone had any idea to...

Hi Dave, That worked....Thanks :D

Hi all, Is there any way to show a message if a query can't find any record with a criteria???? Thanks in advance Thanks

Hi Igor, Thanks for the reply. It worked with style...... Thanks

Hi all, I had a report which is based on a query . That query is based on a criteria.The query works fine. My question is that is there any method to avoid records in report if a specific field is blank. example: SELECT Institutions.*, Recipients.Rec_ID, Recipients.Spon_ID...