Recent content by HAMMAMABUARQOUB

  1. HAMMAMABUARQOUB

    Reset or Remove User-Level security for a database

    there are lots of software that provide VBA reset, i used one my self with Excel and it's great, i used another method with the hex editor and it's done. but still nothing worked with the user-level security protected database :(
  2. HAMMAMABUARQOUB

    Reset or Remove User-Level security for a database

    I have created a database and made the steps to the user-level security and VBA protected the project but i lost the passwords and the MDW file is there any way to reset the VBA pass then reset the security level?? this is very important for my business it's a school database with lots of info...
  3. HAMMAMABUARQOUB

    Default values

    you can use a variable for each field... using the DLast Function to get the values of the last records and stor them in theses variables,, then,,, in the befor update event, assign these values to the new record's fields but using the default value properity has shortcums..!! i guess.!! HAMMAM
  4. HAMMAMABUARQOUB

    How to validate form fields

    Can this be ideas! http://www.access-programmers.co.uk/forums/showthread.php?t=176953 regards
  5. HAMMAMABUARQOUB

    What's the best/worst video game of all time?

    I still see the Operation Flashpoint (GOTY) with ECP and other Mods the best game ever, in all values... Also the VBS1 and DF5 BHD TeamSabre.. But OPFP is the best! I spend hours playing and modifying missions,...it's wornderful, realist battle, guns, planning, weapons terrians, effects, and all..
  6. HAMMAMABUARQOUB

    Open Access form in Word

    Alow me to suggest the following: 1-Set the source Doc properity to the file you wish to open 2-use: Application.followHyperLink see attachment
  7. HAMMAMABUARQOUB

    Open Access form in Word

    this is a little not clear to me! do you wanna open the Access form in microsoft word? how can this be true? or you wanna open the Word document directly from theis acces form?!!! the Command Followhyperlink can be done even on any type of documnets without need to make it as a hyperlink... i...
  8. HAMMAMABUARQOUB

    Subform populates Main

    these ideas can possibly give you a hint on how to populate the main form from the sub, and the sub from the man,,, in this example, as you clik on a record or any field in the subform, the current data from the correspondant fields appear in the main,, also, if you move in the record in the...
  9. HAMMAMABUARQOUB

    Linking One Subform

    you are currently liknking the tables great, but the strnge thing you are using Email type as the subform not te EmailAdresses I auggest you delete the subform...creat a new one based on Emailasddresses table, use the first option to link, and you will get a subform linke to the companies form...
  10. HAMMAMABUARQOUB

    Why is my search button searching all fields?

    first of all you did a great job by analysing this all and put the system into action, but i will be honnest with you, you will find it very difficult in the future to redesign and update the forms like this way! I am not pretending to be an expert, but, as my experience in interface design and...
  11. HAMMAMABUARQOUB

    Make entry into a field subform mandatory

    did you try it from the table design! choose the field, go to the properties below(2003) or on the right(2007) go to Required, change it to yes! if you want to do it in the form you need a code, in the OnExit of this subform, creat the error msg other ways, just check the relationships between...
  12. HAMMAMABUARQOUB

    How to perform Countif horizontally in a Report?

    can't a cross-tab query do the job?!
  13. HAMMAMABUARQOUB

    Autonumbering rows in Excel by VBA

    Good Evening for every body in this forum I cam to day with a code on which i worked days to make it the most perfect and overcum the errors that appeared with trial it's an auto-numbering VBA code used to insert autonumbers "Serially" while you write data in the adjacent colums. this can be...
  14. HAMMAMABUARQOUB

    ComboBox Pop ups very distracting - what can I do?

    the attacehd PDF page is upside-down.. anyway! use the .DropDown method in the Getfocus, mouse move, and keydown(the key code for tab )
  15. HAMMAMABUARQOUB

    Simple Quick Question....

    That's it... Dim Frms as String Frms = Screen.ActiveForm.Name MsgBox Frms
Top Bottom