Recent content by Tarbuza

Hi Skip, I went through the URL that you listed but it essentially shows the numeric value. My question is quite different than what this URL is trying to illustrate. Take care, Tar

Hi All, I have a date in one field as follows: mm/dd/yy = 03/12/07 I have a blank field that I want to update from this above field as follows: MNTH. dd, yy = March 12, 2007 I want to come up with an update query to updat the field as mentioned above. Any help would be greatly...

Thanks for your reply. I understand that part. How can I store value inside a name called txt2004? I tried to do the following: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Not IsNull(Me. START_DT) Then Select Case Year(Me. START_DT) Case 2002...

I have following field in my report Action Start Data End Date Qty 2003 : Formula is Qty*5, if start date falls in 2003 then Qty*6 2004 : Formula is Qty*12, if start date falls in 2004 then Qty*13 2005 : Formulat is Qty*12, if start date falls in 2005 then Qty*13 I started something like this...

I have following field in my report Action Start Data End Date Qty 2003 : Formula is Qty*5, if start date falls in 2003 then Qty*6 2004 : Formula is Qty*12, if start date falls in 2004 then Qty*13 2005 : Formulat is Qty*12, if start date falls in 2005 then Qty*13 I started something like this...

How can I convert SQL View into Access Query? Please help.

I have an Access Report which I print by using PDFWriter. I also want to attach an introduction page in front of the report and few annexes at the end of Access report. These introduction pages and annexes are in word document. How can I merge into Access Report which is in a PDF format? Thank...

I am getting the following error message when I use Count(IIf([type]="Hardware",[type])) . Aggregate functions are only allowed on output fields of the record source. Thanks for your help.

Employee Id Name Div_Code Dept_Code Inventory Employee_Id Inventory_Id Type Lease_No Inventory type can be Hardware, Software or Miscellaneous. Lease Lease_No Start_date End_date Report format Division Code: xxxxxxxxxx Departement Code:xxxxxxxx Lease_No Start_dt End_dt #of...

Is there a Application trigger where I can store a code which will run upon start of an application other than AutoExec? Thanks in advance.

Bill, Sorry your code works. I made a typo mistake in Declare statement. It's working now. thanks a million.

Thanks Bill and Robert. I tried Bill's code but it is not closing instance. I checked line by line. Everything seems to be working except Call SendMessage(hWnd, WM_CLOSE, 0&, 0&). This has no effect. I tried Robert's DoCmd.Quit but it is closing everything including y.mdb. Any other ideas?

It is mdb file. Let me clarify further. I have two mdb files x.mdb and y.mdb. From x.mdb, I go to y.mdb. While I am in y.mdb, I am trying to kill x.mdb but x.mdb is open. Is there a way to close x.mdb from y.mdb through code? Thanks in advance for any help.

I want to kill a local but open file from VBA so that I can copy an updated file in user's local hard drive from server. Thanks in advance for any help.

How can I check while executing Insert that if it is a primary key violation then it should do Update? What error code Access generates if it encounters inserting the same primary key? Thanks in advance for any help.