Search results

So far I have seen no difference in VBA from an English Version appart this case. All are in Greek appart the VBA that is in English.

My computer is set for Greece. Thanks to your comments I have tried to replace the "m" with the relevant letter of the Greek character and works fine. Thanks a lot

I Normally work with semi-colon rather than commas. I have test this on another access file that is a Demo, but still does not work. Attached is the relevant file

Here I am again, While trying to build a query I type Expr1: DatePart("m",[ExpenseDate]) after I press Enter it shows Error I type Expr1: DatePart("m";[ExpenseDate]) but it turns to Expr1: DatePart("/m";[ExpenseDate]) and does not work Any though to solve this problem? PS I work on...

The solution you sent me few minutes ago, solved my problem. Thank you very much for your great assistance.

I tried to work on this way as I do not know how I could extract the report by quarter. As I mentioned in my original message I am not an expert therefore my luck of knowledge drives me through complicated plans. I appreciate if you let me know which way I could report per quarter. Is the...

Dear GalaxiomAtHome, Thank you for your reply. Actually I am not working with dates but I presented the simpliest edition. I try to create a database with various fields to input various expenses for a school i.e. School bus fuel Wages Electricity Insurance etc. All these expenses should be...

I have created three forms and three subforms in sequence also three tables i.e. Tables : Year-YearID, Quarter-QuarterID, Date-DateID Α) Form Year and field YearID, Year Subform and relationship on YearID VB code of Year subform: Private Sub ViewRptForm() DoCmd.DoMenuItem acFormBar...