Search results for query: *

Hi im the local lotus notes administrator for my company and use domino administrator. Recently I archived a few emails for an employee, but now if i go back into their archieve i cannot see any of the archive destination defaults eg(last modified). And when i go to view the achieve settings...

well currently i have comboboxes which give selections and the recordset fills the next combobox from the previous combobox - comboboxes (month, year, department and employee) and when a button is clicked it fills a textbox with the total vat (for a mobile phone billing system) but what i want...

Does anyone know how i fill the results of recordsets in access and export them into excel... i know its very hazy but gotta start somewhere. Would be grateful for any help

Im trying to do the same thing, can you tell me how you exported the results of the recordset into excel?

Could you simplify that please...?

Does anyone know how to export the results of a recordset into an excel file, i know it may sound abit vague and alot of work but i honestly dont even know where to start the exporting... heres the recordset code that originally fills a textbox with the recordset result... Private Sub...

Its ok, I found out what the problem was, tis all working now! thanks guys for your help, very much appreciated!

Great, that seems to work, now, what im trying to do is fill the Total ExcludingVat Textbox with a euro sign (DONE) and the value that results from the query - how do i do that?? Me.TotalExcludingVATTextbox.Text = strEuro + VATQuerySet.Fields that code is what im trying but it obviously...

thanks, but I wish that was the solution, there are no errors when it comes to quotation marks etc... im nearly sure it has something to do from reading the values selected from the comboboxes, im not too sure if im going about it the correct manner

Ok - so the problem is that the recordset that I have created is not filling, or entering any value into it, CAN ANYONE HELP as this is the very last part of my program.... Maybe its a problem reading the values that are selected, in my program, from the comboboxes... im not too sure. here is...

Ok - so the problem now is that the recordset that I have created is not filling, or entering any value into it, CAN ANYONE HELP as this is the very last part of my program.... here is the subsequent code -> Dim strEuro As String Dim VATQuerySet As DAO.Recordset strEuro = "€" strMonth =...

I did that but it didnt really help me, am still down to "expected 2 parameters".... I honestly cant see where its going wrong

Remou I tried what you have told me to do Yes, strYear should have been numeric but I still have an error with the query... "too few parameters - expected 2" at least the expected has gone from 4 down to 2 Can you help me a little more??

I have 3 comboboxes - Month Year and Employee I need to match the user chosen month, year and employee to the database and print the employees VAT amount in a text box Below is some of the code and the query I am having problems with (the query gives error: too few parameters - expected 4 can...