Search results

  1. V

    Change the format of a newly added Field in VBA

    Hi there, I have a form that adds new fields specified by the user to a table. My only problem now is that I need to be able to change the format of the new field. Right now the user chooses the fields name and data type. However when the boolean or Yes/No datatype is...
  2. V

    Error with "cascade update related field". Unable to change field.

    Hi There, I have created a database to record research studies data. Everything is organized as I want it, but I cannot modify a field (Study Name) which is in pretty much in all my tables. I have all my tables linked and the option “Cascade Update Related Fields”, yet when I...
  3. V

    Changing from a single form to a split form

    Hi There, I have created a “Single Form” which I want to now change to a split form. I can do this easily by changing the “Default View” of the form in the properties window to “Split Form”. However the datasheet portion now appears above the whole form, even above the header...
  4. V

    Query changes drastically complex after saving and reopening

    Hi There I have a somewhat simple query, that once saved and re-opened MS Access changes the programming to be drastically longer and more complex. It still works as it should, but as soon as I tamper with it, it no longer runs. It states (and rightly so) the query is too complex...
  5. V

    Obtaining the trendline equation

    Hi There, I am using MS Access. I am trying to obtain the value of the trendline equation from a chart. The chart is premade and on a split form. I have been trying to obtain the equation using VBA. The best way may be to use the MS Excel reference library or the graph library. Yet all...
Back
Top Bottom