Search results

I am not sure what you mean by format event - but what I can say is that some of the fields that are selected from the query were expressions. Could it be that there is one field on the report where I have set an expression? Kesh

Thank you pbaldy. In fact I tried doing print preview and I am still getting the same message. I also tried publishing as pdf and sending as attachment in an e-mail. The data on the report is sourced from a query using several joined tables. I tried removing all tables and joingin 1 by 1...

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

Oouuff!!. Thanks a LOT pbaldy!. You are a life saver. It worked. WOW!!!

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

I was able to find the cause of the problem by myself. In one of the tables in the query, there was an indexed field. Once I changed it to non-index, the printing worked. Thank you All

Hi All, I used the following and it worked INSERT INTO TABLE A ( Field A ) SELECT Table B.Field B FROM Table B; Thank you All 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

Thank you Pat for the advice on naming standards, I will take good note of it

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