Search:

Type: Posts; User: Giftx

Page 1 of 9 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: VB6 - InputBox: How to accept multiple string values.

    Gentlemen,
    I am gradually inching closer to my goals, thanks to all your expertise.

    In my Form_Load module, both my controls(listbox and combo) loaded okay with the data from my tables.
    ...
  2. Re: VB6 - InputBox: How to accept multiple string values.

    Si,
    my program ran okay and populated both the listbox and combobox.

    However, regarding the formating of the string values that will be selected from the controls, how does this code that Hack...
  3. Re: VB6 - InputBox: How to accept multiple string values.

    Yes, Si.
    I modelled after reading thru the article you recommended.

    Below is the code I wrote based on the example from the article. However, when I ran it, I got error: Too few parameters....
  4. Re: VB6 - InputBox: How to accept multiple string values.

    Good morning gentlemen.

    Hack, in response to your question, NO. My objective is for the user to select either a single value '00' (unioncode) or multiple values '00','01','32' (unioncode).
    ...
  5. Re: VB6 - InputBox: How to accept multiple string values.

    LaVolpe,
    for the sake of user-friendliness as you pointed out,
    can you give me a taste of how to accomplish this if I have to load values from the database into the listbox or combobox, then how I...
  6. Re: VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Si,
    please take a look at my inputBox syntax. Maybe my problem is here. Something looks funky within the codes.



    Unioncode = InputBox("Please Enter Union Codes for this report. Enter each...
  7. Re: VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Si,
    I made the changes to both variables as you said how I have: Syntax error in String in query expression.

    Note that I am supplying the values thru an inputbox, but the Debug.Print is not...
  8. Re: VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Si,
    So, how do I fix it? I changed this to add quotes to Checkstatus as you specified and I had the same error. This time it is not even picking up the variable name, rather Checkstatus has empty...
  9. Re: VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Si,
    I noticed something when I did
    Debug.Print strSQL

    The Debug.Print output picked up user-supplied input: for Begindate and enddate but did not pick up user-supplied input for Unioncode and...
  10. Re: VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Si,
    so how do I properly enclose "CheckStatus" is quotes within the sql?
    Thanks.
    Giftx.
  11. Re: VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Hi Si,
    Below is my complete module. If you look at my variable definitions, Unioncode, Begindate, enddate, the sql is picking up all other variables except "Checkstatus".



    bPath =...
  12. Re: VB6 - InputBox: How to accept multiple string values.

    Please can someone show me a more efficient way of coding inputbox to accept multiple string values:

    in my example below, the user may enter only a single string value, or may enter multiple...
  13. VB6 - InputBox: How to accept multiple string values.

    Please can someone show me a more efficient way of coding inputbox to accept multiple string values:

    in my example below, the user may enter only a single string value, or may enter multiple...
  14. Replies
    6
    Views
    3,913

    Re: Error 3061 - Too Few parameters. Expected 2.

    Good morning Si_the_geek,
    in your comment about the variable "CheckStatus".
    I am using this variable to accept user input instead of hard-coding it.

    for example: I defined it as:


    Dim...
  15. Replies
    6
    Views
    3,913

    Error 3061 - Too Few parameters. Expected 2.

    Could someone help to show me what I'm doing wrong in this sql. I get the error when it hits the last line to execute the sql.


    strSQL = "SELECT DISTINCT tblUnclaimed.PassNumber,...
  16. Re: VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Mr. RBull,
    To be more specific, it is not picking up the new variable I added to the query
    CheckStatus

    It is saying Missing operator in query expression:
    tblUnclaimed.status In ()
  17. Re: VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Hello Rhino,
    thanks for your input. Your query executed okay, but when I added a new variable (CheckStatus) to the query, I got the same error. I must confess, I am not really good with placing...
  18. [RESOLVED] VB6 - RunTime error 3075: Syntax error - Missing operator in query expression

    Gentlemen,
    they say more eyes are better than two :D . Can anyone see if they can see where my syntax error is in the code below:


    Set rsin = Dbs.OpenRecordset("SELECT DISTINCT...
  19. Re: MS Access 2000 - Query problem(Agregate function)

    Thanks Si.
    It worked.

    Giftx.
  20. [RESOLVED] MS Access 2000 - Query problem(Agregate function)

    Need some help and clarification.
    I created an access query in design view. Now, I am trying to run the query using values from two linked tables.

    I have selected the fields I need from both...
  21. Re: VB6 - Runtime error 13: Type Mismatch

    LaVolpe,
    thank you for your geniune observation and input. Yes, I was using both DAO and ADO and it didn't like it. I removed the ADO and it worked.

    Thanks again.

    Giftx.
  22. [RESOLVED] VB6 - Runtime error 13: Type Mismatch

    Gentlemen,
    I have one annoying error and I have looked and looked and can't find the mismatch.

    The code below gave the above error:



    Set rsin = Dbs.OpenRecordset("SELECT...
  23. Replies
    1
    Views
    3,032

    C# - how to populate a combobox

    can someone please give me a hand on how to populate comboboxes. Below is a sample of how I started, but I know it's grossly in correct.

    I'm just trying to get the hang of C# for the first time....
  24. Replies
    6
    Views
    5,377

    Re: C# - Accessing form1 from form2

    Hi Hack,
    I can use ADO/DAO to connect to database/tables/recordsets using vb/vba, but I haven't done that in C#.

    Any guide/examples will do me a world of good.
    Thanks.
    Giftx.
  25. Replies
    6
    Views
    5,377

    Re: C# - Accessing form1 from form2

    Yes, I want to display values from a database in the ComboBox. Or I might want to add values to the combo just as you add items to a listbox.
    Thanks.
    Giftx
  26. Replies
    6
    Views
    5,377

    C# - Accessing form1 from form2

    Hi everyone, I am so "green" in C# (C sharp) it's not even funny. This is the first time I am programming/creating a GUI apps using C#.

    Question1:
    I have two forms - form1 and form2. If I am in...
  27. Re: VB6 - Unble to Add new sheet to my workbook

    Thanks West.
    I Kept tweaking until I got it right.
    Below is the code I used:


    Set NewSht = xlWbk.Sheets.Add(After:=xlWksht)


    Thanks again.
    Giftx.
  28. [RESOLVED] VB6 - Unble to Add new sheet to my workbook

    Guys, Please I need you help on this. I currently have an active workbook that contains a single worksheet sheet(1). I want to add a another worksheet Sheet(2)next to the existing worksheet.
    ...
  29. [RESOLVED] VB - Generate a report from existing Excel spreadsheet

    Gentlemen,
    I need guidance on the above subject: I have this perfectly working vb module that takes input from an Access table/Query. The module then uses the query data to create Excel report. I am...
  30. Re: VB6 - Unable to create visual basic executable

    Rob, I got a new name for you - Rob-Ginie (for Genius).
    Problem solved after I used vb6 component that you suggested.

    Thanks and have a great weekend.
    Giftx.
  31. Re: VB6 - Unable to create visual basic executable

    I am using vb6 standard edition.
  32. Re: VB6 - Unable to create visual basic executable

    I am running vb6.
  33. [RESOLVED] VB6 - Unable to create visual basic executable

    Help please :(

    I am trying t create executable (.exe) from my ".vbp" and I am getting an error display: "License Information for this component not found: You do not have an appropriate license...
  34. Re: VB6 - Ability to View Access report on screen before printing it

    Yes, it shows now. However, I guess since a user will only be running the executable (.exe), will they be able to still see the underlying db and tables?
  35. Re: VB6 - Ability to View Access report on screen before printing it

    Hi Rob.
    Now I added
    oApp.Visible = True and I was able to view the report. However, it also made the database and underlying tables visible. How can I avoid the db and table from being seen?
    ...
  36. Re: VB6 - Ability to View Access report on screen before printing it

    I am using Access 2000.

    And what is sandbox mode :). If it is network issue, then I am screwed because I can't changed the db location.
  37. Re: VB6 - Ability to View Access report on screen before printing it

    Hi Rob.
    Okay, "acViewPreview" is not doing a thing. When execution reaches that line of code, it waits for about 5 seconds and nothing happens and it executes the next line of code.

    This is my...
  38. [RESOLVED] VB6 - Ability to View Access report on screen before printing it

    Gentlemen,
    I need a little help. I am opening an access report. But I want to be able to view the report in the screen, then print it if I want to.

    I am using the codes below but, it only goes...
  39. Replies
    5
    Views
    602

    Re: C# - Website Development Tips

    Thanks Hack.
    Quite a lotta material to siff thru. In the process of this mini project, if I have further questions or guidance I'm sure you good guys will guide me thru.

    Thanks again.
    Giftx.
  40. Replies
    5
    Views
    602

    Re: C# - Website Development Tips

    Mendhak,
    Thanks for your tips.
    Giftx.
Results 1 to 40 of 353
Page 1 of 9 1 2 3 4



Click Here to Expand Forum to Full Width