Recent content by mike7

My report was built from a query where I just put ''Enter the customer's name ?'' between brackets in the grid on the criteria's line.

Just to tell you, I'm a complete newbie with no programming notion...I have no problem passing a parameter to generate a report but I would also like to use that same parameter inside a dsum function to be used as my criteria. What would be the proper syntax for that dsum function ? Thanks for...

What if.... What if you have two separate tables. One called ''Revenus'' that increases the bank account (or a credit) and one called ''Expenses'' that decreases it.... How would you do it this time ? Mike

a little mistake As I can see, I made a little mistake in the attached picture in my previous msg. It should have been 1,15025 instead of 1,015025. Nevertheless, do you believe it corrects the problem simply by using a longer divider ? Mike

If you can help, it would be very appreciated. As you can see in the attached picture, I've done a few calculations on a report from the field W contained in a table and you may realize that W should be equal to X + Y + Z. But, if you refer to the same picture, you can see that it's not the...

Also very interrested I'm also very interested in this issue. Can someone respond to denileigh ? Thanks, Mike

How would you do this in a mail merge ? Same question, but in a letter done by mail merge...How would you skip address2 field if null and not get a gap? Do you have to modify the query...? On a label, I know I can apply the CanSrink property, but the letter... Thanks

Good practice ? Nice & clear. Thanks

I created a database for a small non-profit organisation. There's no special coding, nothing special, only tables, queries, forms and reports. These people don't have much experience with computers. My goal here is to prevent them from deleting OR modifying the objects by accident (and...

Can someone help me please ? I'm trying to find this "Repeat section" property in my french version of Access and can't find it at all. I've attached a picture of the screen I get when I look at the page header property. If you don't know the translation of that property name, can you at least...

Syntax error A simple syntax error caused this error msg. Thanks anyway.

I don't know what's going on here...I'm just calling a query by clicking a button on a form and I receive the following error msg: Execution error 3125...'EnvoisO' is not a valid name. Make sure that it does not include invalid characters or punctuation and it not too long. The query 'EnvoisO'...

a little comment.... In response to Rich: If you're looking carefully at http://www.fontstuff.com/access/acctut10.htm in examples 2 and 3, Martin is grouping everything in the same table. I've tested his method and it's working fine now after I redid everything from scratch. I've also had a...

some answers... To answer Rich, I picked up that code in http://www.fontstuff.com/access/acctut10.htm, on the third example. But, to make a comment on Adam Fleck's reply, I have to say that my stuff in not running perfect at this time. My combo boxes are running fine. My table is updated with...

Am I stupid enough.... Am I stupid enough ? I'm just posting my solution to help some other newbies like me. The following instruction just had to be written on one single line, not on two like above. ' Synchronise org combo with existing clients cboOrg = DLookup("[nomorg]"...