
Please Click to see clearly!
Hi Journal,
BIG, BIG, BIG Problem had occurred while I was making my buttons.
Okay.... On Friday I had finished everything and just had to make my buttons and decorate. Our assignment was extended to being due on Monday. So I went home and tried to make my buttons. I was doing this on Access 2007. It was so different from 2003(obviously) and a little complicated but it was easy making a button but it didn't work at all. I was getting worried, it was due Monday, what was i going to do???? I tried going on Microsoft's website to download the 2003 version but they didn't have any at all. They weren't giving any 60 day trials obviously because it was an old version. So I kept trying and trying, still didn't work. I also couldn' t add any music on, but my buttons were more important. So I decided to finish off Part A : The Word Document. I saved the database on my USB and made sure to pick the option: that the default format would be 2000-2003 Access.
Now today, Monday the 6th I tried it at school, on Access 2003, but still it wouldn't work. I also discovered that to make a button, instead of picking the Miscellaneous option then query, I had to pick form operations and then open form. So it wouldn't work still, unfortunately I was stuck, so I went to my teacher, told him my situation and I told him I would try again at home and Yeah I have to upload as soon as possible. I already uploaded Part A onto the W drive.
Now for the good part, I have found a solution, what I did was make a *Macro and attached a form to it then I made my Button, clicked on properties and then events and formatted it to that specific macro and IT WORKED YAY!
So I am done everything, its all good my music has been added as well, my main form, queries, forms , tables everything... I have finished!!!!!!!!!
Took hard work and in the end it was great:)
Sanea.
* Information on a MACRO-
A Macro is a rule or pattern that specifies how a particular input sequence should be mapped to an output sequence, this being according to a defined procedure.(Specific definition).
The mapping process is known as :-macro expansion
In short it is basically a set of computer instructions that are able to be recorded and associated with a shortcut key combination or macro name. When the shortcut key combination or macro name is clicked, the computer(program) then carries out the specific instructions to the macro. Using the macro function also saves time by instead of using, a frequent, lengthy series of actions just use a shorter action.
With Microsoft Access 2007, the use of the macro enabled me to make one macro for each of my queries and then this was linked to my buttons.
So overall using a macro in this assignment, didn't only solve my problem of making a button but I also learnt about what macros are, what they do and how effective they are!

No comments:
Post a Comment