dcsimg

Search:

Type: Posts; User: samer22

Page 1 of 13 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    10
    Views
    204

    Re: copy a record

    I understand
    thank you
    solved
  2. Replies
    10
    Views
    204

    Re: copy a record

    Thank you all of you

    jpbro:
    Thanks a lot for the code. It isworking perfect.

    a small question out of curiousity if you don't mind:
    I noticed that 'Desc' and 'Asc' in the code have no effect...
  3. Replies
    10
    Views
    204

    Re: copy a record

    Olaf thanks a lot
    but I'm having a syntax error

    ' StrSql = "INSERT INTO Vac_tbl ([SID], [Vac_ID],[Date_Vac],[Date_last_vac])" & _
    ' "SELECT Top 1 PID, Vac_ID, Date_Vacc, Date_due FROM...
  4. Replies
    10
    Views
    204

    Re: copy a record

    thank you sir for your interest
    Text1.Text contains the PID value
    yes I have more than one PID in the ENCHEANT_tbl table and my code is copying the last 'PID'
  5. Replies
    10
    Views
    204

    [RESOLVED] copy a record

    Hello vbforums

    This is my code to copy a record from a table to another


    StrSql = "INSERT INTO Vac_tbl ([SID], [Vac_ID],[Date_Vac],[Date_last_vac])" & _
    "SELECT PID, Vac_ID,...
  6. Re: CommonControls (Replacement of the MS common controls)

    sorry again sir
    I was using select case mistakengly


    Select Case KeyCode
    Case vbKeyF1

    FormChild.Show

    End Select
  7. Re: CommonControls (Replacement of the MS common controls)

    Hello sir
    I noticed that when I call the function SetHook I will be unable to use keyboard keys.
    Hence, Impossible to write in textboxes
    thanks
  8. Re: CommonControls (Replacement of the MS common controls)

    Hello sir
    I noticed that when I call the function SetHook I will be unable to use keyboard keys.
    Hence, Impossible to write in textboxes
    thanks
  9. Re: CommonControls (Replacement of the MS common controls)

    Thank you sir
    now it works as I was expecting
  10. Re: CommonControls (Replacement of the MS common controls)

    Sorry sir I'm a beginner
    I downloaded the demo and tested it
    I was expecting I could do something like that

    If KeyCode = vbKeyF1 Then FormChild.Show
    The same thing I do in a form Form_KeyDown...
  11. Re: CommonControls (Replacement of the MS common controls)

    Hi Krool
    I downloaded the MDI_ToolBar Demo but I can't figure outhow to make the ToolBar control accessible per shortcut key on a MDIForm
    For example what code I need to show Form2 and where shall...
  12. Replies
    6
    Views
    463

    Re: SQlite Close connection

    Schmidt
    Thanks a million for these valuable info.
    Solved
  13. Replies
    6
    Views
    463

    Re: SQlite Close connection

    I was following the same steps but still Permission denied error


    Set RS = Nothing
    Set cnn = Nothing
    cd.ShowOpen
    PicFile = cd.fileName
    TxtData.Text = cd.Filetitle
    FileCopy (PicFile),...
  14. Replies
    6
    Views
    463

    Re: SQlite Close connection

    Oh my bad!!!
    I know there is no Close method.
    in fact I was setting the Cconnection and the recordset to nothing.
  15. Replies
    6
    Views
    463

    [RESOLVED] SQlite Close connection

    Hello
    I've developed a small application in which I am using SQlite3 as backend and VB Rich Client framework.
    I have a problem of restoring the database.
    I'm using FileCopy to restore db.
    I can...
  16. Replies
    4
    Views
    378

    Re: Stuck in Retrieving an array

    DataMiser
    So grateful to you
    it worked perfect
  17. Replies
    4
    Views
    378

    Re: Stuck in Retrieving an array

    techgnome
    thank you for your interest
    So you think there is no way to retrieve them appropriately?
    This is the way I thougt I could read them back

    If Not RS.EOF Then
    For i = 1 To...
  18. Replies
    4
    Views
    378

    [RESOLVED] Stuck in Retrieving an array

    Hello again experts
    I was able to save ceckboxes' indexes by means of tis code

    StrSql = "Select * from Transac_tbl where ID =" _
    & Text3.Text & ""
    RS.Open StrSql, DB,...
  19. Replies
    17
    Views
    819

    Re: Please I can't update an array

    I think I got it

    For i = 1 To Check3.Count - 1
    If Check3(i).Value = 1 Then
    If RS.EOF Or RS.BOF Then RS.AddNew
    RS!ID = Text3.Text
    RS!Date_due = DTPicker3(i).Value
    RS!Vac_ID =...
  20. Replies
    17
    Views
    819

    Re: Please I can't update an array

    Some experts are advising me to use OptionButtons.
    Though I can use them, I can't see the difference as I am saving indexes.
  21. Replies
    17
    Views
    819

    Re: Please I can't update an array

    Thank you experts
    I'm so glad for you interst and I appreciate your comments.
    I think techgnome and DataMiser have understood my worry


    That's exactly what I'm trying to do but I can't figure...
  22. Replies
    17
    Views
    819

    Re: Please I can't update an array

    Thank you ChrisE but I need to save the index
  23. Replies
    17
    Views
    819

    [RESOLVED] Please I can't update an array

    Hello experts
    I have an array of checkboxes. I can add data but I can't update.
    This is what I have been doing.

    StrSql = "Select * from Transac_tbl where ID =" _
    & Text3.Text & ""...
  24. Re: How do I add a foreign key to an existing SQLite table?

    thank you Olaf
    I added the piece of code you suggested.
    Unfortunately, I can't get rid if this error
    163373
  25. Re: How do I add a foreign key to an existing SQLite table?

    I tested all codes there
    unfortunately, I get syntax error
  26. Re: How do I add a foreign key to an existing SQLite table?

    thank you techgnome for your interest
    I tried so many queries but I did not succeed.

    cnn.Execute "ALTER TABLE Pat_tbl ADD CONSTRAINT Foreign Key Pat_tbl(Pat_ID) REFERENCES MainTable(ID);"
  27. How do I add a foreign key to an existing SQLite table?

    Hello VbForums
    I have this table:
    Pat_tbl:
    id INTEGER PRIMARY KEY,
    pat_id INTEGER,
    description TEXT);
    How do I add a foreign key constraint on patient_id?

    I aleady know how to adda...
  28. Re: Is iit possible to prevent new line?

    I'm sorry
    I didn't see your sample project
    Thank you very much
    It worked
  29. Re: Is iit possible to prevent new line?

    Eduardo
    thank you for the link

    I followed the instructions but I could not get what it was expected.
  30. Re: Is iit possible to prevent new line?

    Eduardo
    thank you for the link

    I followed the instructions but I could not get what it was expected.
  31. Re: Is iit possible to prevent new line?

    Thanks Eduardo
    but I do not want to add scrollbars.
    I want if possible to disable carriage return but not Enter.
  32. [RESOLVED] Is iit possible to prevent new line?

    Hello Vbforums community.
    I want to ask if it is possible to prevent adding a new line in a multiline textbox unless you press Enter of the keyboard?
    thank you all
  33. Re: How to keep the format of a multiline textbox the same in DataReport?

    Please I need an expert to show me how to make two loops that grab the specified lines for each RPTlabel
  34. Re: How to keep the format of a multiline textbox the same in DataReport?

    dilettante
    thanks again
    I did as you told me
    I created two RptLabels and I used the split function.

    Dim strText() As String
    strText = Split(Text3.Text, vbCrLf)...
  35. Re: How to keep the format of a multiline textbox the same in DataReport?

    dilettante

    Thank you for this proposal
    But How Am I going to copy the content of the textbox to the two RptLabels?
    Is the Split function going to do the job?
    thanks sir
  36. Re: How to keep the format of a multiline textbox the same in DataReport?

    This what I did


    DataReport1.Sections("Section1").Controls("Label1").Caption = Text3.Text
    but didn' t work
    Then I used a RptTextbox with a temporary table but the same problem.
    Any help please?
  37. Re: How to keep the format of a multiline textbox the same in DataReport?

    Thanks techgnome

    I checked the font and the alignemen but still the problem.
    I think because I'm filling the textbox from a listview.

    Text3.Text = Item.Text & vbNewLine & vbTab & vbTab & _
    ...
  38. Re: How to keep the format of a multiline textbox the same in DataReport?

    Arnoutdv
    Thanks for answering me but I did not understand.

    I created a form and added a multiline text with the same formatting as above
    And I adde a label with the same font as the textbox0...
  39. How to keep the format of a multiline textbox the same in DataReport?

    Hello everyone
    I'm using a datareport for printing a multiline textbox but I can't keep the same layout of the textbox.
    My textbox looks like this:
    161801
    But the printing output is this:...
  40. Replies
    8
    Views
    754

    Re: Opening many recordsets

    I could overcome the issue by using IntelliSense in KeyUp event instead of change event
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width