Recent content by babu

Hi All, I am having a peculier problem. I have declared a variable as say Dim strRunDate As Date and assigning it as : strRunDate = Format(Me.txtDate.Value, "dd/mm/yy") when i am running this, the initail value for strRunDate is showing as : 12:00:00 am. and after executing the...

Thanks a lot Bob. It's working fine now.

It's a copy paste error, sorry about that. the code is : WHERE LEFT(Reason,10) = "Range Tail" . It working fine in the production i.e. in tehuser PC. But when trying to run the same thing ibn my PC it's giving thsi error. Please can you help.

Hi khawar, Thanks for your reply. I didn't get your answer. Please can you tell me in more detail.

Text 1 is a text say "abc".

Hi All, I need your help on this. In my Access 97 m/c, when i am running a query as select * from tbl_xxx where LEFT(field1,10) = "text 1" and right(field2,10)="text 2". While running i am getting the Error as : 3075 function is not availabale in expressions in query expression...

Hi All, As a part of my requirement, i have set of steps to be completed. I am calling one function for one step. What i wanted to do is, i wanted to disable the second button on the switch board unless teh first step is completed sucessfully. Please can anyone advice me on how can i achieve...

Hi, Thanks a lot for the information. It's working fine for me now. Actually as per my requirement user wants to do some manipulation on teh table after it gets created. Thanks, Babu

I am using the Access 97 version.

Hi All, I am creating a table using VBA code as create table. The code is working fine. the problem is, the table tab is not getting refreshed automatically. I mean, if i am in the table tab, and run the function which create the table and looking into the table tab, i am not getting the newly...

Thanks a lot. it helps me in understanding the problem. Thanks.

Hi All, When i am trying to send email(sending a report) using SendObject functionality i am getting the mesage as "A program is trying to send email on your behalf. Do you want to allow this ? " please can you advice me how to stop this message. I am using Access 97 and outlook 2003. It...