Search results

  1. H

    Get External Data - Prevent - Security

    Hi all I am been searching for a while for a solution to my issue but cant find it anywhere. Any help would be greatly appreciated. Here goes.... OK, I have disabled the F11 key as well as the Shift Bypass, hidden the menus and restricted the access to the design of the forms. So its secure...
  2. H

    Error Trapping and Autoexec

    Dear all I'm totally lost and confused and need some help. I send a db out once a month to over 200 users (it has to be a local copy). Because of the size of the file (and that outlook will not send .mdb files as attachments), I have to zip it up. If the user doesn't unzip the file and...
  3. H

    Create Google Maps URL using loop

    Dear all, I need some help and advice using VBA to create a URL. I want to plot several points on Google Maps. The URL I am trying to create is this:-...
  4. H

    Group by function alters any memo fields

    Hi I have a problem with a particular bug in access 2003 that I cannot for the life of me understand. Help/suggestions and opions are greatly appreciated:- Problem If I have a table with two columns in. Columns are as follows:- name - notes Name is formatted as text (John Smith...
  5. H

    Enable/Disable Command Button

    Hi all I'm having a problem with enabling and disabling a command button on a form. Here goes.... I have a form that has two fields on it Name ----- Select (Text) -- (Yes/No) Jonathan Yes Sue Yes Alison Yes David Yes If all four records are selected...
  6. H

    Check to see if your connected to the net

    Hi peeps, need your help on something I have a control on a form called [url]. The control brings through a specific web address based on the choices that a user makes in previous steps. In the Got Focus event, I have the following code:- Private Sub url_GotFocus()...
  7. H

    Export to Excel (Groan)

    Hi folks, need some help on a problem I am having:- I have three tables I'm trying to export into Excel. These are:- Master Live Archive I have a template excel spreadsheet called:- Draft Workbook.xls Inside this template file are three worksheets called:- Master Live Archive The...
  8. H

    Disable Combo box

    Hi all, I have a combo box on a form that I would like to disable if a value in another query returns false. The form with the combo box is as follows:- Form - search 2 Combo - combo53 The query with the value is as follows:- Query - search lease event results count Field...
  9. H

    Dim Form on lost focus

    Hi, Need some help if possible. I have a form that displays information on a building. One of the fields on that form is the name of a person that is responsible for that building. Alongside that control is a button that opens a contact information form (over the top of the previous form)...
  10. H

    Button on a form to open a URL

    Hi all, I am trying to place a button on form to open a specific URL. I have two fields in a table. The table is called location and the two fields are called location and url. When the user selects the location (from a combo list) it displays a whole range of detail on that location. I...
Top Bottom