Search results

I have a sheet which contains several columns. The sheet displays blocks of data with a total at the end of each block. I want to copy the cells from the sheet (named Citi) to Sheet1 from column D but only from those cells with a value. The value occurs several times but I need to copy it once...

I have written a VBA code with the following line row = Application.WorksheetFunction.Match(ComboBox1.Value, Sheets("Agent Summary Report").Range("A1:A10000"), 0) it returns the value of the row after value from a combobox (a name) matches a list in another worksheet. If it does not match...

Excel 2007. Hi I want to send an e-mail automatically from Excel. Can anybody please help me? Thank you Kesh

Ms-Access 2007 I have built up a report and I want to send it to users as attachment to an e-mail. The e-mail is to be sent automatically at 8:00 a.m daily on weekdays, I have written the following code which does open the e-mail and attaches the report but waits to be manually sent: Can...

I need to select records from an Excel worksheet which has several columns but with a certain criteria. There is a column called "Call Scheduled for" which contains data and time. So if I run a macro every morning at 8:00 a.m. the records selected from the worksheet will be those which are...

Access 2007 A few days ago I requested help on this problem and after some time I stated that the problem was resolved. It was resolved but it has come up again When I do a report view everything is fine but when I try to print preview and print an error message is discplayed. I have...

Access 2007 I have set up an autoexec macro to run when the database is opened. The macro runs a task and closes the database. I do not have a back up and I am not able to access the DB. Can anyone help me Please? Thank you Kesh

MS Access 2007 I have a table with the filed "Call Scheduled For" in the format "2012/05/22 10:07:00 AM". I have to to write a query which will list from table all the records where the "Call Scheduled For" is 72 hours older than today. Can anyone please help me? Thank you Kesh

Access 2007 I want to add a date to a column in a table which contains dates only from another table which contains 1 date only. I am trying to use the following sql statement but I am getting a syntax error INSERT INTO (([Arrears Frequency - Date] ( Date_Range )) (SELECT RunDate.RunDate FROM...

I am using MS-Access 2007. When I select Print Preview, the following msg is displayed "The expression On Format you entered as the event property setting produced the following error:Return without GoSub" I do not have any macro on this database and none of the fields used in the report...