Recent content by Earl C Phillips

  1. E

    Field level size appears to change

    The solution: Delete the offending master record and create a new one with the correct information. It works. Thanks for all the suggestions.:D
  2. E

    Field level size appears to change

    I have compressed and repaired both the program and the data file separately. This does not cure the problem. Thanks for the try.
  3. E

    Field level size appears to change

    I have a form that contains a blank text box for each field in a record. Until very recently it functioned correctly for years. Lately data enterers tried to fill a ten character field with five characters (ANNNN format, example X9999). Some records require an entry in this text box, some do...
  4. E

    Show VBA Code on Form That Will Not Open

    :D Thank you very much. I learned a valuable lesson today.
  5. E

    Show VBA Code on Form That Will Not Open

    I tried typing in the password, then pressing ALT+F11, then submitting the password. That worked.
  6. E

    Show VBA Code on Form That Will Not Open

    Alt-F11 does not work either. The app has a front end password which I cannot seem to circumvent.
  7. E

    Show VBA Code on Form That Will Not Open

    When first opening the application by opening a file, I do not have the choice of opening in design view. I would happily do so if I could, but that is not a choice. Earl
  8. E

    Show VBA Code on Form That Will Not Open

    In the initial Form_Open code there is a string that fails before the form is open, preventing me from opening the form and accessing the VBA code to correct the problem. How can I access the VBA code to correct the problem if it otherwise prevents me from opening the form so I can access the...
  9. E

    Formatting Export of Query To Excel

    I have solved all but the transfer of the formatted spreadsheet. I have formatted the spreadsheet headings for columns and cells as follows: A SQL Stmt creates a recordset of expected volunteers: Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Add Set xlWs =...
  10. E

    Formatting Export of Query To Excel

    I am trying to post a list of volunteers who will be at the Food Bank each day. When certain people sign on each morning, I execute within Form_Open DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "qryScheduledOfVolunteers"...
  11. E

    Cannot Stop Updating Prior Record

    I am building a student register for a school for disabled children. There is a screen listing all students, one showing detailed student data chosen by #=IIf(IsNull([ID]),"(New)","Open")# clicking on "Open", one listing all the guardians, choosing a guardian by...
  12. E

    Protecting VBA from user changes to code

    Your suggestion may have merit but I think it is beyond my skills. I am a converted COBOL programmer from mainframe background (eleven years ago when I worked for money). I will research your technique and see if I can duplicate the process, but it will take me some time to read up on the...
  13. E

    Protecting VBA from user changes to code

    Most of my code is written in ADO versus DAO. What is the comparable ADO version of DAO.QueryDef?
  14. E

    Protecting VBA from user changes to code

    I forgot, is there a way to prevent the use of the tool bar or similar way to get at queries?
  15. E

    Protecting VBA from user changes to code

    Making an MDE or ACCDE is easy enough, as is puting a copy of the SQL into a table, but will that allow the SQL to source parameters from report pages? Most of my SQL contain parameters taken from fields on Report pages to match the needs of the current user. I also have stacked queries to...
See more
Top Bottom