Search results for query: *

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

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

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.

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.

Has anyone used Payflow Pro and integrated with Java Servelet? I would like to see an example. Thanks in advance for any helps.

In the following code, I am not getting the value for scustid inside submit_onClick. How can I get the value for scustid inside submit_onClick? Any helps would be greatly appreciated. Thanks in advance. <% Option Explicit Dim session, db, doc, scustid...

I have a field called pubdate which is a text field but I have date in the followin format: December 1994 14 May 1997 1 December 1999 I want to change December into 12, May into 5 etc. So the above date should look like as follows: 12 1994 14 5 1997 1 12 1999 Thanks in advance for any helps.

I already have a function calling from onClick='ctotal()' and now I want to add chkrw(this). How can I call two functions from onClick? Thanks in advance for any helps.

I want to prompt an invalid number onBlur of my Amount field if the user types in 500.438 (valid number is 500.43). I don't want to chop myself but prompt the user that it is invalid to type more than two decimal places. Any help would be greatly appreciated. Thanks.

How can I check for #Error in my expression of query? Thanks.

I have a text in the following format: #Vol.1#Pg.132#December 2002#Source:ABC ##Pg.140#January 2001# How can I parse it through query or VBA whichever is easy and store values as follows: First one after # sign should go in a field called Volume (for instance Vol.1). The second one after #...

I have a text in the following format: #Vol.1#Pg.132#December 2002#Source:ABC ##Pg.140#January 2001# How can I parse it through query and store values as follows through update query: First one after # sign should go in a field called Volume (for instance Vol.1). The second one after # should...

I have the following code which works fine but it's giving me the result either without decimal places or if it is with a decimal place then it is showing up only character. For instance, 1250.5 instead of 1250.50. Code is as follows. Any help would be greatly appreciated. var...

I have the following display on the screen: checkbox Item Name Condition Qty Computer Usable 5 Monitor Unusable 3 Hard Drive Usable 6 Item Names and check boxes are displayed. User selects condtion from the drop down list which can be either Usable or...

Some say that no one book is enough. Some say none of the practice test is close to the real exam. Some say just focus on concepts. Some say either CISSP Prep Guide or CISSP All in one Guide would be enough. Some say the wording of question is straightforward and some says that it is vague and...