Search results

Your correct - I meant handwritten. I'll try your suggestion when I get back to work. Once again thanks for pointing me in the right direction. Regards CarolW

Hi vbaInet, Apologies, for I should have expanded upon it a little. At the very end of the report, however there might be an occasion when it'll need to go at the end of a group. Thanks for taking the time out to reply.. CarolW

Good Evening Everyone, I have successfully created a report which generates random examination questions and everything is fine with it, however I’ve now been asked to add/create 2 extra pages at the end of the report which effectively holds a TABLE with 2 columns and it spans the entire height...

Hi Momog, Have you tried to use concatenation .... works for me.http://www.techonthenet.com/access/functions/string/concat.php CarolW

Hi Everyone, I have a question regarding a small database that I have at work (80 records) and what I'd like to be able to achieve is a mechanism whereby I can attach an e-mail message(s) (some may have attachments) to an individuals access record. I routinely receive various e-mails about...

Dean, Go into the properties of the text box, select the 'Other' tab and where it says 'Enter Key Behaviour' change it from Default to 'New Line in Field'. Give that a go - it worked for me?? CarolW

Jon K, Thanks for the quick response to my earlier request. I tried what you said above and 'hey presto' it worked like a treat. I am no longer getting additional records which fall outside of the Start And Stop parameter boxes which is just great news. Thank you so very much - I've learnt...

Jon K Thank you ever so much for your advice, particularly with relation to the use of the IIF expression. The bit that you mentioned about the "dates parameter should apply to the DateDone field", the main problem that I have is basically that they want it done on the TestDueNext field...

Good Evening Everybody, I am currently helping some people out at work with their database. My knowledge of Access is very limited, and whilst my it is improving I have nonetheless come up against a ‘hurdle’ which I am struggling to jump. The database in question is not complex, quite the...

Thanks RuralGuy, Your advice was gratefully appreciated. Not quite sure how to do it but I'll 'dig a little deeper' and will attempt to try to solve this problem myself? Thanks ever so much CarolW

Thanks RuralGuy, Your continued help is very much appreciated - just wish I was more knowledgeable? Regards CarolW

Hi RuralGuy, Apologies for the delay in responding....... Currently using Access 2007, running XP Home Edition on my PC? I take it that you did not have any problems using it yourself? CarolW

Hi RuralGuy, I'm not that familiar with 'references' but I've managed to navigate to that area and I have found a check mark against Microsoft DAO 3.6 Object Library. Is that the correct setting? Please excuse my lack of knowledge in this area. Appreciate your prompt response Regards CarolW

Hi Everyone, I was wondering if anybody would be kind enough to help me with a problem that I have with regards to a 'Contacts Database' that I found under the Sample Database link on this site - posted by MStCyr. When I try to navigate through A-Z buttons I am presented with a dialogue box...

Paul, Thanks for your help.... I'll have a go at what you suggested - with your guidance I'll hopefully achieve my aim. Regards Carol

Hello zyxwvu44 and Paul, Thanks for taking the time out to reply................ Your advice about the 'cascade delete on the relationship' is something I already have in place, and if I am correct should automatically delete stuff from Table B when I delete records from Table A? Paul - with...

Hello Everybody. I was wondering if anyone could please help me with a SQL syntax issue that I am currently experiencing problems with. I have a requirement to archive data over 2 years old, the data from which extracted from two tables on which I there is a one-to-many relationship. The PK...

Save to specified directory - now see what you mean? Hello RoyVidar, My apologies... You are not at all rude - it's me getting confused again, which happens alot? I now see what you mean? I will give the code a go when I next go back to work, and I'll let you know the outcome?? Your help and...

Save to directory as.SNP file - slightly confused? Good afternoon RoyVidar, Many thanks for the very prompt response however I'm still unsure as to what you mean? I am still very new to this sort of thing and as a consequence would gratefully ask if you could amend my code so that I might see a...

Hello, I wonder if some kind person might be able to point me in the right direction regarding a problem I have encountered? Basically I am trying to create a command button that will 'On Click' first open my report and then open a dialogue box that will show the proposed path where I want the...