Search results

Thanks for replying. I have a fair idea of the importance of normalisation and I had a brief look of the tutorial in the link. I think for businesses in products/manufacturing/frieght etc. normalisation should be applied strongly. But in my case, its a home fitness service business, so I...

Thanks for reply. I considered using a table but its not just the address that can be common, I would like to copy the address, phone-1 & 2, Email Address, Next of Kin. And that would be a few tables which seems abit to do. And some family members can be just 2 or 3 or more joining at a time...

As the title says I like to know in more detail how to copy certain fields of only a current record to a new record in a form. I work on MS Access03 and have a database of client information. Because I come accross many family members, storing one member's personal info and then again at the...

I use MS access 2003, so what I’m looking at doing for my database is add a duplicate form (duplicating some fields in the form) of an exiting record to a new record, but the new ID number assigned should be from a sequence (ie. unsed ID numbers) and would be automatically be inputted into the...

After a mail merge in Word, the links in the hyperlink are broken and the hyperlinks goes nowhere. Below are the manual instructions that I have to do to restore the link. 1 - Right click on the hyperlink and select 'Edit Hyperlink' 2 - In the Address field, remove the hash key on either...

I would like clickable hyperlink on mail merge to actually work. In my access 2003 database the field that corresponds to the Hyperlink is named “VideoLink1” and I have made it a Hyperlink type field. However, when I insert the field within a MS word Hyperlink field brackets shown like this: {...

Ok, so now I know can't get that "x" feature to work on Msg box. For the vbYesNoCancel, I input this code: Private Sub Form_BeforeUpdate(Cancel As Integer) Select Case MsgBox("Save?", vbYesNoCancel) Case vbYes 'go ahead and save. 'do nothing Case vbNo 'undo the changes. Cancel = True Me.Undo...

The "X" close option is to return to the form as it was before the message box appeared in the case I don't want to save what was edited or don't want to remove what I added, I just want to close that box when it appears. I hope I'm making sense here. Not sure why I need another message box to...

For one or more of my forms, I have a Message Box feature in place for editing the form. Box Title/Heading "Changes Made", message reads Changes have been made to this record. Do you want to save these changes? Yes No However, the "X" in the right hand corner is...