dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: Giftx

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. VB6 - Error 3170 - Cannot find installable ISAM.(DAO.Workspace)

    Hello everyone,
    Please, I need some insight or fix on an error I am getting when I running my VB module.


    Me.MilLv_Cursor.Refresh

    The above line of code gives me the error msg:"Error-3170 -...
  2. VB6 - Format Excel spreadsheet with xlCount and xlSum

    Hi everyone,
    please look at my spreadsheet attachment.

    I am using Visual Basic to generate an excel spreadsheet.

    The spreadsheet has four columns:
    "Population", "CheckCount", "TotalAmount"...
  3. Re: VB6/Excel - Go back to original Worksheet after copy.

    Thanks.
    Giftx.
  4. [RESOLVED] VB6/Excel - Go back to original Worksheet after copy.

    Hello everyone,
    I copied/create a new worksheet from my existing worksheet(sheet1). How can I go back to the original sheet after the copy function?

    This is my code:

    sheets(1).Copy...
  5. Re: [RESOLVED] VB6 and Excel spreadsheet - Delete Unspecified range of cells

    Thanks dg.
    I got it going.
    Have a great day.
    Giftx.
  6. [RESOLVED] VB6 and Excel spreadsheet - Delete Unspecified range of cells

    Hello everyone,
    just one more thing on my spreadsheet manipulation: Currently I am hard-coding deletion of a range of cells. However, this range may change at any given time, in other words, there...
  7. Re: VB6 and Excel spreadsheet- Moving records from one sheet1 to sheet2 in the same Wrkbk

    Hi Raj,
    thank you guys for your input so far.
    your code looks simple enough to understand. However, after pasting the data into Sheets(Dependent), I want to delete all recores who DOES NOT have...
  8. [RESOLVED] VB6 and Excel spreadsheet- Moving records from one sheet1 to sheet2 in the same Wrkbk

    Hello everyone.
    Too late to say happy new year :)

    I need help with my vb/excel module.
    Objective: I have a report on a spreadsheet(Sheet1) with data. I want to create another spreadsheet...
  9. MS Access 2000 - Inserting records in a new table by joining input from two tables

    Ladies and gentlemen,
    I have an issue inserting records into my new table
    Output table is: "TblProgrammersHours". In this table, RequestID and ProgrammerInitials are combined to form my Primary...
  10. Replies
    5
    Views
    1,317

    Re: VB 6 - Re: Run-Time error 3075

    Hello "dg".
    I quite don't follow what your code example is saying.
    This is my objective:

    I have two input tables "TblRequests" and "TblPersonnel". I am creating a new table Called...
  11. Replies
    5
    Views
    1,317

    VB 6 - Re: Run-Time error 3075

    Hi all
    sorry for the inconveniences, I just wanna get this syntax thing out of my back.

    I modified my vb module and now I'm getting "Run-Time error 3075 syntax error(Missing operator) - query...
  12. Re: VB6 - Run-Time error 3131-Syntax error in FROM clause

    Hi dg and WoF,
    Actually, I've got a question: "Isn't the "Insert" statement supposed to end with ";"?

    The first select statement
    Select * From ( is highlited in RED, so I commented it out.
    ...
  13. [RESOLVED] VB6 - Run-Time error 3131-Syntax error in FROM clause

    Hello members,
    I am trying to execute the module below (SQL statement) and I am getting the above error: "Syntax error in FROM clause" on this line
    Call db.Execute(strSQL).
    When I hovered the...
  14. Re: VB6 - Make Tab key also an "Enter" key.

    Thank you for your response. But can you be a little specific? Like an example or demonstration?
    Thanks.
    GiftX.
  15. [RESOLVED] VB6 - Make Tab key also an "Enter" key.

    Hi all,
    I am trying trying to make both the "Tab Key" behave as the "Enter" key. keys. In otherwords, both the Tab and Enter should acheive the same objective.

    I am using the code below but...
  16. Re: VB6 - Locate/Access Database in a Server directory

    Hi dg.
    That's not really the case here. The database is in a centralized location and everyone can point to it and access it from their workstation.

    For example, this is the location of my...
  17. VB6 - Locate/Access Database in a Server directory

    Hi everyone,
    I am attempting to access a database that is located in a shared server/ directory "K:\". Assuming I don't know where the database is located, how can I programatically tell vb to...
  18. Re: VB6 - Copy a table's columns to another table Within the same database

    Hi dg,
    thanks for your input. Just forget about the Foreign Key issue. I'll work that out.

    I simply want to copy specific fields from TableA and TableB into TableC. And after copying the...
  19. Re: VB6 - Copy a table's columns to another table Within the same database

    Hi dg,
    You probably didn't get what my objective is. TableA and TableB already exist. I created TableC. I want to populate TableC with values from TableA then delete the copied values in TableA...
  20. [RESOLVED] VB6 Add a new worksheet to an existing workbook

    Hello all,
    Problem #1: Please could anyone show me the code to add a new worksheet to my existing workbook.

    Problem #2: I want to assign my old worksheet name to the new worksheet(NewxlWksht),...
  21. VB6 - Copy a table's columns to another table Within the same database

    Hi everyone,
    I have two tables "TableA" and "TableB" TableA has 9 columns and TableB has 4 columns. I created a new table "TableC" with 5 columns. I want to copy 3 columns from TableA(with its...
  22. VB6 - Run-Time error 1004 Unable to get the add property of the sheets class

    Gentlemen,
    I wanna kill two birds with one stone here, I hope you won't mind

    Problem#1:
    I am getting a "runtime error 1004 - Unable to get the Add property of the sheets class" on this line of...
  23. Re: VB6 - Programatically tell excel to print only the area that has data.

    Hello dg,
    I quite appreciate your contribution and expertise but I'm a bit confused at your directives.
    As you already know, I am dealing with an existing spreadsheet (.xls) that is generated...
  24. Re: VB6 - Programatically tell excel to print only the area that has data.

    Sorry but I quite don't understand what you mean by "splitting" the memo field.
    Please, could you show me exactly what you mean programatically?
    Thanks.
    GiftX.
  25. Re: VB6 - Programatically tell excel to print only the area that has data.

    Hi dg.
    Based on your last post, I doubt if your suggestion can do it. Because, even if I process 50 records, each record has almost a paragraph full of text (data).
    After much research, I found...
Results 1 to 25 of 51
Page 1 of 3 1 2 3


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)