Search results

  1. B

    Problem with date variable

    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...
  2. B

    3075 error in query expression with LEFT and RIGHT function

    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...
  3. B

    table refresh

    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...
  4. B

    getting message to say YES while sending mail

    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...
Back
Top Bottom