DaniWeb IT Discussion Community

connection with machine

abu taher — Sat, 14 Nov 2009 06:49:26 GMT

I want to do work with a machine(any). like: Id card punch(machine) or other. the software collect data form the machine. Here I want to how the software work with the machine? how a software give a command to the machine? I want to know details. plz help need.

code need

abu taher — Tue, 03 Nov 2009 09:47:24 GMT

have any code for all form. I mean, here I write

Help with Code...

run time error 3705

abu taher — Mon, 26 Oct 2009 06:03:13 GMT

I select a month from a combobox and type the year in maskeditbox then press a button to show the report. 1st the report show. when I select another month to show again the report then show a error msg:

run-time error 3705

operation is not allowed when the object is open

and then highlight the connection string.

error with package and development

abu taher — Thu, 22 Oct 2009 06:22:12 GMT

after complete all process when I press finish then show a msg: "unexpected error number 70 has occured: permission dinied."
what I need to do.

label caption

abu taher — Tue, 20 Oct 2009 11:09:07 GMT

if I write 500 in a textbox then a label.caption show "Profit". If I write -500 the the label.caption show Loss. I write code

If Format(Text1, "0000000") Then Label1.Caption = "Profit"

but for -500 what I need to write?

how to show calculate data in textbox

abu taher — Tue, 20 Oct 2009 06:32:26 GMT

I have two dtpicker. here I want I select two date from dtpicker and the total sum of amount will show in two diffrent textbox. like: I have two field, expense and income. the total amount of expenses will show in a textbox by selected date and other textbox show income. how I do it?

calculate field

abu taher — Sat, 17 Oct 2009 06:54:03 GMT

in my data report I have two rptfunction. both of them show the total sum. here I want 1 extra rptfuncion show the calculate amount. I mean it show (1st rptfunction - 2nd rptfunction). like: 1st rpt...2000 and 2nd rpt....1500. so the 3rd rpt... show 500. and one more thing if it show 500 the a label. caption show profit. if it show -500 then it show loss.

stand by option not work

abu taher — Wed, 14 Oct 2009 07:53:59 GMT

my stand by option not work. I mean it enable flase. how I repair it. I install a new windows xp, service pack 2.

what problem in this.........

abu taher — Mon, 05 Oct 2009 07:02:15 GMT

Sub QryReport()

    On Error Resume Next

    

    Dim QryDef As QueryDef

    Dim str As String

    

    Set QryDef = dbase.QueryDefs("balancesheet")

    dbase.QueryDefs.Refresh

    

    If Err.Number = 3265 Then

        Set QryDef = dbase.CreateQueryDef("balancesheet")

        dbase.QueryDefs.Refresh

    End If

    



        str = "select *  from [balancesheet]" & _

              " where Date ='" & Dtpicker.Value & "'"



    QryDef.SQL = str

    datareport1.Show

    End Sub

here show the all data. but the sql command not work. I mean when I select a date the report didn't show that date's data. it show all data. what problem ?

problem with data report

abu taher — Tue, 29 Sep 2009 06:47:41 GMT

in data environment I write code

SELECT AccountInfo.incategory, Sum(AccountInfo.InAmount) AS SumOfInAmount

FROM AccountInfo

where Date and Date between DTFr.value and DTTo.vlaue

GROUP BY AccountInfo.incategory;

in form I write code in a command button like:

Private Sub Command2_Click()

     Load DataEnvironment1

    With DataEnvironment1

   If .Command3.State <> 0 Then .Command3.Clos

     .Command3 Format(DTFr.Value, "dd/mm/yyyy"), Format(DTTo.Value, "dd/mm/yyyy")

     End With

datareport1.Show

End Sub

in this form I have two dtpicker. when I run the project , I select two date from this two dtpicker and press the button then a msg show:

compile error:

argument not optional

then highlight this

 If .Command3.State <> 0 Then .Command3.Close

please help me anybody