Search results for query: *

We have an application in FoxPro. one of our remote office have access to this application through Ctrix MetaFrame. the application is working fine. But the problem is the client from repote office cant take print. the server is not getting the client's printer (Epson LQ2170). i'm new to Ctrix...

i have a cross tab query like below item 2001 2002 2003 2004 2005 2006 ----------------------------------------- item1 500 500 500 500 500 350 item2 300 400 400 400 400 item3 150 200 200 200 ----------------------------------------- if i give a date...

IN MY SUBFORM I PUT BELOW CODE: Private Sub Amount_AfterUpdate() If Me.C_Code = "c" And Me.Cost = 0 Then Me.Cost = Me.Amount Me.C_ACODE = [Forms].[CusMaster].[Customs_Code].Column(2) Else Me.Cost = Me.Cost End If End Sub on the subform "C_ACODE" field i wanted to call the value from...

i have a CrossTab Query. i want to have the Column Total for every record. how can i make a column total in access query. Ragu [pc]

My Multi selection is working fine, but my SQL is not working with the selection. mySQL SELECT Assets.AssetID, Assets.Model, Assets.Asset_Cat_Code FROM Assets WHERE (((Assets.Asset_Cat_Code) In ([forms].[Report].[Text28]))); ------------------------------------------------------ My Code to...

in my Continuous Forms i have below items Command1 Command2 CheckBox i need on Command1 Click CheckBox = Tick (Yes) Hide Command1 i need on Command2 Click CheckBox = Un-Tick (No) Hide Command2 i want this function to happen on for the selected record. ragu[pc]

PART_NO AMOUNT INV_NO S434343 100 6007 F534534 120 6007 H543455 225 J785677 0 k545345 0 on command click if INV_NO = null and AMOUNT = 0 then msgbox "No valid amount available for invoice" if INV_NO = not null and AMOUNT > 0 then msgbox "no data found" if...

when i open the Access query in Excel (through Office Link "Analyze it with Excel" option) the data getting saved/opened in Excel file i want a selected column's font color and back color to be in some color. (like yellow). how can i do it. currently every time i'm holighting the column un...

i created a simple database for keeping the track of Asset. in the main form i have below fields: "Date of Purchase" "Purchase Price" "Depreciable Life" on the subform have three fields "Month No" "date(dd/mm/yy)" "depreciation Value" i need the subform to be updated with date and...

i have a data in TXT file which seperated by ",". when i try to link the data with comma (,) seperation it worked fine but in every record i have the double quote (") like below "sumit" "15-jan-06" "" "" it seperated by (,) how can i make a seperation for (",")..?

In my form i have a unbound textbox which will show the latest contract number. same form i got a subform with all contract details for the customer (like below) date contract_No expiry ----------------------------------------- 01/02/2004 ABC1234 21/03/2004 12/03/2005...

in my form (Continuous Forms)i have below fields Doc_Submit_Date Inv_No Status (Check Box) before updating the Check Box i want to make sure the Doc_Submit_Date, Inv_No fields are updated. of not updated the system should not allow the user to check the check box i'm using below code but no...

in my main form i have a option called "Duty" after selecting this option i want to subform to be auto filled as below subform Field Criteria ----------------------------- masterID = [mainform].[id] charge_code = "C" Charge_Detail = "Customs Duty" Charge...

in my form i have a field called "Status" If the Status = "Open" user can edit the data on the form and subform and if the Status = "Closed" i want to Block any data Entry, Edit on the form and subform How can i do this Ragu [pc]

i'm using below code on my form for the Option (radio button): Private Sub Option61_GotFocus() Me.txtDuty.Visible = True End Sub Private Sub Option57_GotFocus() Me.txtDuty.Visible = False End Sub it's working well when i enter a new record. but when i tried to move between records it's not...

I wanted to calculate slab rates in excel through VBA coding. The slab is like this: Rightnow I’m using “if” function for every row. I like to have a function (VBA Code) on the backend of the worksheet. Ragu [pc]

In my table is having data as below: Box_No Move Date A12 In 10/02/2006 A12 Out 15/02/2006 A15 In 12/02/2006 A15 Out 25/02/2006 …. …. I need to calculate the No of Days between 2 moves, line below Box_No In_Date Out_Date...

i have a customer_master table with below fields # Customer_name # Tel_No # Contact_name and i have a Call_Record table/form which also got above 3 fields and some other fields what i want is on the Call_Record Form once i select the Customer Name (by ComboBox) i want the other (Tel_No and...

i have made a contact list in access. with two tables Table1 have the company name and Head_ID Table2 have contact details both Table linked with Head_ID and Details_ID on the form i want to display all the company name one side on a ListBox. otherside i have the subform with contact...

can anybody tell the how to add Date Picker to a Oracle 9i form Ragu [pc]