Search results

I have a query for a database on the shared drive . I want to export this to excel and prompt the user to give the user a file save as box so that he can save it anywhere he wants. Any ideas how this can be acheived?

. Using the transfer spreadsheet method . It was giving that message yesterday but today it disappeared . Today my problem is when I put in the path to a folder on the shared drive it does not export . When I put the database on my hard drive and give the path of C:\Data.xls it works fine. So...

When I try to do an export to excel for a report - it comes back with a message saying Invalid procedure call or arguement . Any ideas on this one ?

This would be for one Emp ID correct ? I am looking for this Name Sick vacation stat Name 1 total sick total vacation total stat Name 2 . . .Name n Grand total Grand Total Grand total sick vacation stat

I have an employee database . It has two main tables. Employee Info and other one Details about Types of Leave Taken,number of hours and date on which it was taken. If I want to sum the total for each employee all the types of leave that was taken over a period of time - month or year - what...

How do I sum up the rows of a column in a report ? My example is here below Sick Days Employee1 Employee2 Employee3 Total of Sick Days

My listbox displays multiple rows and columns . I want to change the color of the row in which on column says "vacation" . How can I do that ? please help

Good Point . Did not think of that at all . How can I avoid that trap ?

Worked . I most certainly had the syntax wrong there. Moses .

This is exactly what I looked at and it kept erroring on me.

Private Sub Combo4_BeforeUpdate(Cancel As Integer) Text6.Value= DLookup("[last]", "Table1", "First ='& forms!Table1!combo4'") End Sub Any ideas about this ? mehul

Recreated a new form and a new calendar and list and now it works perfect. As a side note can I use a simmilar property like Rowsource or something to insert data in to a table . At the moment I have it using Currentdb.Execute ? Thanks a lot . Really appreciate the help moses

Yes I did . Thanks for your reply once again.

Private Sub cal1_Click() Me.List18.RowSource = "Select * from Table1" End Sub I put this in there and it shows (Select * from Table1 ) in the list ....lol. I am not sure what I am doing right.

I am really not sure how I can do that . Can you please educate me. please and thanks. Mehul

. Thanks for your help . I worked with single quotes after I changed the datatype for DateTaken to text from Date and Time. Any ideas how I can keep it at date and time and still have it work. Thanks again.

Hi Bob, I am getting the same error. Trying to populate a list box using a query based record set. This is the code I have . Can you please help. Private Sub cal1_Click() On Error GoTo UserForm_Initialize_Err Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim calval...

Pasting a snippet from my code cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\new.mdb" rst.Open "SELECT Table1.Name FROM Table1 WHERE DateTaken= '" & cal1.Value & "';", cnn, adOpenStatic rst.MoveFirst cal1.Value is a value to be picked by the user on a...

Is there a property in a list box that I can set to make sure it does not populate duplicate entries ? moses

Can I assign a value from a query to a text box without writing VBA code ? please please help. Thanks. Moses