Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. andrest

    Query Number Variable.

    I'm trying to query a number variable to populate a listbox but no records are selected: Dim stSQLString As String Dim num as Integer num = 2 stSQLString = "select * from emp where empno = '" & num & "'" lstEmp.RowSource = stSQLString Why is this not working? Thanks.
  2. andrest

    Help.... How to write a SQL that will query an Excel file.

    Hi Bob and thanks for the fast reply.... The company I work for have an application that populates a reports database to generate reports and when a new job is selected the database repopulates with different data... But they want me to save that information somewhere... i save that information...
  3. andrest

    Help.... How to write a SQL that will query an Excel file.

    Hi! I'm a virtual Rookie when it comes to programming.... I have to import data from a temporary Access Databas.. (it's flushed every time a new record is created and then repopulated).. I store the tables in an Excel file... How can I, using VB, populate a datagrid with this excel file...
  4. andrest

    Exporting to Excel....

    Thanks BrainB, Can this be automated? Andre
  5. andrest

    Exporting to Excel....

    I have 2 Access Database tables. I want to export them to separate sheets in the same excel file. Is this possible? Thanks in advance. :) Andre
  6. andrest

    <Exporting to Excel....

    I have 2 tables. I want to export them to separate sheets in the same excel file. Is this possible? Thanks in advance. :) Andre
  7. andrest

    Question on exporting.

    I have 2 tables. I want to export them to separate sheets in the same excel file. Is this possible? Andre
  8. andrest

    Saving Access infomation into an Excel file.

    Thanks Eric, I'll give it a try and let you know. Thanks. Andre [smile]
  9. andrest

    Saving Access infomation into an Excel file.

    Thanks for the prompt response Eric. I had not considered that option. Wouldn't it take alot of space to create thousands of databases. Andre
  10. andrest

    Saving Access infomation into an Excel file.

    Hi! I want to create Excel files every time an Access Database is populated so I can later on repopulate the database with any of the saved Excel files. I'm a junior programmer and I'm on my own with this problem. Any suggestions? Thanks in advance. :) Andre
  11. andrest

    Resize question?

    Thanks johnwm, it was helpful. [thumbsup]
  12. andrest

    Resize question?

    Hi, Does anyone know how to resize all the controls on the form when the user tries to resize the form? If the user tries to make the form bigger, all the controls (such as textbox, labels, command buttons...) have to be made bigger also. Is there a control that can help to do that? Thank...
  13. andrest

    Like operator help......

    How can I query a table using a variable instead of a string? SELECT AuthorLastName FROM BookList WHERE BookTitle LIKE '*Cook Book*' It doesn't work like the following. SELECT AuthorLastName FROM BookList WHERE BookTitle LIKE '*VARIABLE*' andrest
  14. andrest

    between...and operation help........ sql newbie

    Ok... i finally got it going.... thanks guys....
  15. andrest

    between...and operation help........ sql newbie

    Hi I'm trying to query a database using a BETWEEN operation to choose between to dates. adoAllJobs.CommandType = adCmdText adoAllJobs.RecordSource = "SELECT Jobs.JobNumber,Jobs.Date, Clients.BussinessName, Jobs.ProjectName, Jobs.Salesman, Jobs.SubTotal, Jobs.GST, Jobs.Total, Jobs.Balance...
  16. andrest

    Help... Dates!!!!!!

    Thanks guys.. :) André
  17. andrest

    Help... Dates!!!!!!

    Does anybody now how to get the first day and last day of a month?
  18. andrest

    ScrollBars????????

    Can you add scrollbars to a Standard EXE? If yes, how?
  19. andrest

    HELP..... select statement newbie

    Thanks alot, it works fine with your second post. Andre
  20. andrest

    HELP..... select statement newbie

    I'm trying to query a table based on the value of a variable (which comes from another table) but it doesn't work. My code works like this. Dim myVar as String myVar = "1001" AdoJobs.CommandType = adCmdText AdoJobs.RecordSource = "SELECT * FROM Jobs, Clients WHERE...

Part and Inventory Search

Back
Top