Search:

Type: Posts; User: nubie

Page 1 of 3 1 2 3

Search: Search took 0.04 seconds.

  1. Replies
    4
    Views
    977

    Re: Help Constructing INSERT

    Dim New_UPC As String
    :
    :
    sql = "SELECT U_size FROM SIZERUNS WHERE U_run = " & TextBox2.Text
    insertsql = "INSERT INTO RUNSIZEUPCS (Code,Name,U_item,U_size,U_upc)
    VALUES(Code_manip, New_Name, "...
  2. Replies
    3
    Views
    1,438

    Re: Excel 2007 import into Access 2007

    your code should work perfectly. Try to comment the line DoCmd.OpenQuery... probably your query is updating some rows...and that's where you get your msg "You are about...."

    ...
  3. Thread: Unit Converter

    by nubie
    Replies
    7
    Views
    858

    VS 2010 Re: Unit Converter

    "...way the user enters data, but I'd prefer to use multiple textboxes, instead, such as a box for feet and one for inches..."

    BUT if you insist in using the x'y" format here's how you get rid of...
  4. Replies
    11
    Views
    850

    Re: Help with Textbox!!!!

    YES you can


    If TextBox1.Text.Contains("+") Then
    Dim txtNum() As String = Split(TextBox1.Text, "+")
    MsgBox(Val(txtNum(0)) + Val(txtNum(1)))
    ElseIf...
  5. Thread: Unit Converter

    by nubie
    Replies
    7
    Views
    858

    VS 2010 Re: Unit Converter

    i would input the values in this manner 3'2 for 3 feet and 2 inches, separated by apostrophe (single quote). then split the values. first part represent feet, second part represent inches or...
  6. Replies
    11
    Views
    850

    Re: Help with Textbox!!!!

    use :
    MsgBox(TextBox1.SelectedText)
  7. Replies
    11
    Views
    850

    Re: Help with Textbox!!!!

    use the below code instead of the msgbox, the code ALWAYS replaces the whole words in the textbox with the LAST word.... as i said in my post it depends in how you want your program works
    ...
  8. Replies
    11
    Views
    850

    Re: Help with Textbox!!!!

    it depends how your program works.. but for the basics i'll based my reply on your example:


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
  9. Replies
    11
    Views
    850

    Re: Help with Textbox!!!!

    Can I do this ? :-s

    YES you can....
  10. Replies
    4
    Views
    1,184

    Re: Duplicate table in mssql server

    or you can run a query similar to this:


    SELECT *
    INTO Persons_Backup
    FROM Persons
  11. Replies
    1
    Views
    695

    MsOf03 Re: outlook restrict with instr condition....

    how about this:


    Set myRestrictItems = myItems.Restrict("[SenderName]='gssitaly@iol.it' AND [Subject]= 'test'")
    i'm not sure what the Isntr() is doing in your code.
  12. Replies
    6
    Views
    916

    Re: No progress in using ProgressBar

    Thank you!

    I went with the reference to instance of Form1, progressbar and statusbar were updated, HOWEVER, the "visible" updates were done at the END of the process not DURING. i.e I didn't see...
  13. Replies
    6
    Views
    916

    Re: No progress in using ProgressBar

    I saw no difference setting i=0;


    static class Program
    {
    /// <summary>
    /// The main entry point for the application.
    /// </summary>
    [STAThread]
    ...
  14. Replies
    6
    Views
    916

    Re: No progress in using ProgressBar

    yes, I mean this
    xForm.DProgressBar(++i,iFiles); thanks. so, any more suggestions? ideas?
  15. Replies
    6
    Views
    916

    [RESOLVED] No progress in using ProgressBar

    I have 1 form (Form1) a button and a progress bar. I created delegate to Form1, and want to call DProgressBar(int i, int iTotal) method in another class but the progress bar in the form isn't...
  16. Re: Excel.exe process remains open after closing Excel after mail merge.

    where did you close/ Set to nothing this? MyMailMergeRange is still opem from your code


    Dim MyMailMergeRange As Range
    Set MyMailMergeRange = Sheets("AS-ST-OrdersData").AutoFilter.Range...
  17. Thread: VBA with Outlook

    by nubie
    Replies
    4
    Views
    1,179

    Re: VBA with Outlook

    Dim OutMail As Object
    :
    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    in your declaration you could specify what outlook item (mail, task, etc.)you are...
  18. Re: Easiest way of merging two Access databases together

    check this out, this works in my sample vb.net app


    Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\FileMain.accdb")
    Dim AccessCommand...
  19. Re: Easiest way of merging two Access databases together

    Easiest way of merging Access database together?

    I presume you want to merge two similar tables from 2 .accds? if this is the case you can create an append query from within MS ACCESS db.

    Open...
  20. Thread: Loop problem

    by nubie
    Replies
    1
    Views
    336

    MsOf07 Re: Loop problem

    1. This code will repeat until the date of receipt (FechaCobro) equals the end date (fechaFin control located in the parent form).




    FechaFin.Value = FechaInicio.Value + DiasPrestamo.Value ...
  21. Replies
    2
    Views
    1,242

    Re: issue in excel vb-export to csv file

    i can see single quotes ' in your code, try to get rid of them


    ActiveWorkbook.SaveAs Filename:= _
    '"D:\activity volume.csv", FileFormat:=xlCSV _
    ', CreateBackup:=False

    Try this:
  22. Replies
    13
    Views
    5,251

    Re: excel vba eliminate combo list duplicate.

    hope this helps, using your code and incorporate it with code on post #4 to format the date


    If IsDate(dic.items) Then
    cb_history.List = Format(CDate(dic.items), "dd/mm/yyyy")
    End If
  23. Replies
    2
    Views
    513

    Re: merging data from vb to doc template

    i see most mail merge are done with tables/queries, like this

    http://support.microsoft.com/?id=209976

    here's one you can modify to suit your needs using forms

    ...
  24. Replies
    4
    Views
    473

    Re: update query not inserting correct values

    ...the boolean keyword AND to separate fields, when you should be using a comma...

    as SI mentioned shouldn't your query look like this;


    UPDATE environments SET env_name='QAP',...
  25. Replies
    7
    Views
    711

    Re: i need a proper/right query

    since you're using access, try this query


    Transform count(Status) as StatusCount
    SELECT Shipment
    FROM Item
    group by Shipment
    pivot status
  26. Re: How to generate a fillable PDF from an Access form?

    this works for me using Access 2007 and Adobe Acrobat 9 Pro

    1. Save the forms as Pdf.
    How? on MS Access click Office button, -->Save As --> Pdf of Xps (Save as type pdf) click Publish button....
  27. Replies
    12
    Views
    1,010

    Re: datatype mismatch in criterion expression error

    is the field bbratios of type string? if not remove " ' " single quote arround the txtBuyerRatioS.Text
  28. Replies
    12
    Views
    1,010

    Re: datatype mismatch in criterion expression error

    i suspect buyerbookdate field is a date/datetime type and on your update query you're setting a string type, also the same case with buyerbooktime , what are the types of these fields (buyerbookdate ...
  29. Replies
    6
    Views
    508

    Re: Where clause matching

    try this code:


    SELECT * FROM items LEFT JOIN stock ON items.StockId = stock.StockId
  30. MsOf07 Re: How do I set a text box equal to an Excel cell (new to VB & using Visual Studio 2

    Basic example:


    Textbox1.Text = Sheets(1).Range("A1")
  31. Re: Automatically Run code in Outlook when new message received

    here's an idea I haven't tested this code,


    Dim objNS As NameSpace
    Dim objPF As MAPIFolder
    Dim objitem As Object

    'Set objNS = Application.GetNamespace("MAPI")
    'Set objPF =...
  32. Re: Automatically Run code in Outlook when new message received

    Hit Alt-F11 keys or on outlook menu Tool -> Macro -> Visual Basic Editor

    on the right panel there are two dropdown boxes, Select Application on the first dropdown. Select NewMail <Event> on the...
  33. Replies
    13
    Views
    5,251

    Re: excel vba eliminate combo list duplicate.

    below is a modified version of your code, see if it helps


    Private Sub cb_case_Change()
    Dim strValue As String
    Dim intCounter As Integer
    Set dic =...
  34. Replies
    3
    Views
    404

    Re: Inserting Added Records

    "I have 2 tables with the same columns ..."

    hmmm.. maybe your application requires it, BUT its a little bit strange to have 2 tables with the same columns.

    anyway GaryM provided you the code to...
  35. Replies
    4
    Views
    462

    MsOf10 Re: Excel, possible with formula?

    "That could work with colons instead of commas (i.e. "a6:d6" instead of "a6,d6")"

    right "a6:d6" sums from a6 THRU d6 while "a6,d6" sums a6 AND d6, anyway getting rid of the if() statements i came...
  36. Replies
    4
    Views
    462

    MsOf10 Re: Excel, possible with formula?

    try this formula:


    =if(d2=1,a6,if(d2=2,sum(a6,b6),if(d2=3,sum(a6,c6),if(d2=4,sum(a6,d6),if(d2=5,sum(a6,e6),sum(a6,f6))))))
  37. Replies
    23
    Views
    5,284

    Re: Outlook - count emails

    basically the code iterates for a number of times depending on the number of Items in the SentFolder. inside the For...Next loop it grabs each Item and test whether its a MailItem object, if it is,...
  38. Replies
    23
    Views
    5,284

    Re: Outlook - count emails

    "I was thinking of getting todays date and subtracting one."....Is that possible?

    yes, that is possible. Now() - 1 and get the date portion, Now() returns DateTime, then compare it to .SentOn...
  39. Replies
    10
    Views
    3,980

    Re: Subscript out of range error

    Dim x As Integer
    x = InputBox("Enter number of rows of data.")
    Dim intParts() As Integer
    For i = 0 To x
    ReDim Preserve intParts(0 To UBound(intParts) + 1) As Integer
    ...
  40. Replies
    10
    Views
    22,390

    Re: macro to save excel sheet as PDF

    "I tried to record macro in word and it is simple "

    have you tried recording a Macro in Excel? if you had and didn't work, i have nothing else to add.

    Also as this An error will occur if the...
Results 1 to 40 of 103
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width