Search results

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

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

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

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

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

Is there a way whereby I, or another user, can amend the ‘TOP’ value of a query via a Combo or Text box entry on a form? I have searched this Forum for a solution to this very problem but have had no success. I understand how to achieve this via the queries ‘SQL’ view but cant figure out a way...

Hello Everybody, I have a burning question; one that I hope might be answered, concerning a DB that I have. Dare I say it; my project ‘successfully’ generates ‘random’ examination questions for me. If I speak to loud it'll certainly crash ...ha! ha! The control source of my report is based upon...

Good Afternoon, Could some kind person please point me in the right direction as to how to stop the 'VB code' window appearing and remaining on my task bar when I initially open up my DB. When I look at whats in the window there seems nothing untoward, but I would simply like to get rid of it as...

Good Evening , Could somebody kind person out there please tell me whether or not it is possible to automatically re-size a bound OLE object frame in a report so that it grows or shrinks in size to accommodate pictures of varying sizes. I have managed to incorporate a similar feature in a form...

Good Evening, Could some kind person out there in the world please tell me whether or not it is possible to automatically re-size a bound OLE object frame in a report, so that it grows or shrinks in size to accommodate pictures of varying sizes. I have managed to incorporate a similar feature...

Good Evening, I wonder if anyone could help me please......... I have found Ghudsons attached ‘Browsing2’ example to be of enormous benefit/use to me when I have been creating various Databases, however I was wondering whether Ghudson or any other kind person(s) would either show or point me in...

Hello Everyone, I have encountered a problem at work wherein I have tried to create a DB that genereates a random exam paper based on X amount of question. So far everything has been just fine..........!! Recently however, and to be short, I have received an error that relates to a missing...

Good Afternoon Everybody, Apologies for imposing on you all but I was wondering whether or not you could help me out?? Would you be so kind as to kind as to show me a practical example of how to incorporate a facility into my attached Database which serves to select an equal ratio of my field...

Hello everybody, I have been tasked to create a DBase which at the click of a command button will to all intents and purposes generate an examination paper... At work we are currently using a series of 'Word Doc's'which are static in that we only have a specific set of examination papers...

Hello everybody, Could anyone out there please help me with a small coding problem that I am experiencing.... I have a calculated control on my startup form called txtCurrentAge on which I have put VB code in the on-timer event of the form which makes the control 'flash on & off' if the persons...

Hello everybody, Can anyone out there please help me? I’ve been wandering around the various forums trying to gain some advice concerning password protecting a form. I have tried in vain to tackle this one on my own but alas I cannot, and hence I am turning to some kind person out there to try...

Hello everybody, Can anyone please help me? I’ve been wandering around the various forums trying to gain some advice concerning password protecting a form. I have tried in vain to tackle this one on my own but alas I cannot, and hence I am turning to some kind person out there to try to help me...

Hello Everyone, Before I pose my question I would first like to applaud and thank this forum for the excellent and timely help it has provided me so far. The assistance I have received to date, from you as members, and via the search facility has been extremely helpful particularly as I am new...

Hi I wonder if anyone could re-orientate me and put me in the correct direction regarding the above subject. Without wittling on too much what I,ve been basically trying to do is to get a query that I've made, derive its criteria from a form that has 3 combo boxes on it allowing a user to select...