Search results

Thanks to both the replies. I guess I am totally confused now.... I followed the link that GohDiamond sent, and in it the "MailList" is a record set from a table with all the emai l Ids. My doubt was if there is a way of not using tables, and use the Distribution List directly from the...

Hi, this means that I need to store the emails in a table, right? Is there a way of getting it directly from the outlook?

Hi, I have a Distribution list in my Outlook Contacts called "Test" Is there a way I can send email to this contact group? Currently, what I am doing is this: Dim strMailList as string strMailList = "email1;email2" .To = strMailList What I want to do is instead of strMailList, I would like...

That sounds like another way of data validation. I managed to find the following code in the internet and it is working as I wanted: Private Sub cmdSubmit_Click() Dim rs as DAO.Recordset Set rs = Me.RecordsetClone rs.MoveFirst Do While NOT rs.EOF IF IsNull(rs!Field1.Value) Then...

Hi, I have a table with 2 sets of fields: Plans and Actuals. Plan Fields have values and Actual Fields are empty for the user to fill in from the Form. I have a continuous form with Record Source as the above table. When the Form opens, the Plans are displayed on the Form and User enters...

Thanks Rx and arnelgp for your code and help. Rx, the code in the file you sent works perfectly fine when I run the same file. I copied the code in my MAIN workbook, used your file to open 3 new workbooks and the code worked fine. However, when my internet application opened the 3 new workbooks...

How to I set wb in this case?

Hi Rx, Thanks for your reply inspite of your busy schedule. Here are the answers to your questions: 1. There is no naming convention. When the internet application open the workbooks, they get opened as "Book1","Book2", "Book3". 2. It neither prompts for any location...

Not quite. 1. I open MAIN workbook. 2. I open Internet based application. 3. Internet application opens 3 workbooks (Book1,Book2,Book3) 4. I process data from the 3 new workbooks to the MAIN 5. I click the Button on MAIN to close the 3 workbooks. (This is what I am trying to do) Steps...

Hi Rx, Thanks for your reply. However, I am still unable to do it. I guess my original post was not clear enough. I open the current workbook. Then I open an internet explorer based application. That application opens 3 spreadsheets one by one, named Book1, Book2 & Book2. Once I copy the...

Hi, I need to close 3 workbooks from the current one. So in the main workbook that I have open, I inserted a button, and added the following code to it: Sub btnClose_Books() Dim objXLBook As Workbook For Each objXLBook In Application.Workbooks If objXLBook.Name = "Book1" Then...

Thanks! It worked....

Hi, I am trying to run a query, and export the data to an existing spreadsheet. I would like to replace the existing data in the spreadsheet with the new export. The reason being, there are other sheets which never change. Is this possible with Docmd.TransferSpreadsheet? I used this...

Yes, that was exactly the problem and solution... Thank you very much.....

Here it is... in zipped file

No Combo Box/Lookup/Format Characters I tried to copy the table to a new database, and it is the same results! It is really strange, because I have done concatenation before without any problems...

I tried "Full_Name" instead of "Name". But that made no difference

Hi, I have a table with First_Name and Last_Name. I have a query to concatenate the 2 fields. The query is: Name: [First_Name] & " " & [Last_Name] When I run the query, the Name field displays only the First_Name. Strangely, when I double click each row, I can see the concatenated...

Hi, I am new to this forum, and new to Access too. I am trying to generate a report, and I would like to have a Label with flashing text saying 'report is being generated'. I have set a Form timer at the interval of 1000. In the timer event code, I have this: me.lblmsg.visible = NOT...