Search results

  1. T

    Continuous Form Validation Issue

    Hi everyone, I would like to find out if someone has encountered this problem before or if someone knows how to solve the problem I have. I have a continuous subform that displays lots of questions. This specific form has 10 questions on it. Each question has one answer and the users are...
  2. T

    Help with Validation code on exit event

    Hi guys, I need some help with this code snippet. I am trying to perform a validation on exit of a specific tab of my form and I am calling this function in the form exit event Public Function fnValidateForm(Form_2 As Form) As Boolean Dim ctl As Control ‘Dim Msg, Style, Title, Response...
  3. T

    Highlight mandatory controls on a form tab

    Hi everyone, I am trying to provide a visual highlight for users of a multi tabbed form. I do a check as users go from tab and tab and i.e. on exit event and I would like to highlight all mandatory fields that have been left incomplete. I did a test with one control and it worked as expected...
  4. T

    Update a database column when mandatory fields are completed

    Hi guys, I have a form with lots of combo boxes and text boxes. They are all linked to various MS Access tables and some of the fields are mandatory. I would like do an check to see if all the mandatory fields are not null i.e. are populated with a value and then run an update query for my...
  5. T

    Rewriting repeated blocks of code for combo boxes

    Hi everyone, I just recently started programming in MS Access. I have some forms with lots of combo boxes. I do not want users to type anything in the boxes, but to only select stuff that is contained in the drop down menus. I found this useful code and I am using it in my combo boxes on the...
  6. T

    Specifiying a connection string in ms access forms

    Hi guys, I have a question about connection strings. Basically I have an access front end and an access back end. It works fine for now, but when it gets rolled out, I don't want to have to manually relink the tables every time. Is it possible to hard-code the database connection strings for...
  7. T

    Problem with Form starting at the wrong position of a page

    Hi everyone, I am a newbie to ms access and forms and I have a small problem with a form. The solution has lots of different forms with different tabs for each section. This particular tab has a few sub forms in it. When I switch into the specific tab in question, the screen moves down ever so...
Back
Top Bottom