Search results for query: *

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.

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...

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...

Thanks BrainB, Can this be automated? Andre

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

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

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

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

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

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

Thanks johnwm, it was helpful. [thumbsup]

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...

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

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

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...

Thanks guys.. :) André

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

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

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

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...