Recent content by thebionicredneck

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...

Thanks again for your reply. InitializeCommon makes all my code in the Common module available to use in other parts of my code. The subform only has two events. One for On Enter and one for On Exit, so I am stumped.

Hi CJ, I mean tabs on a form i.e. different tabs and you can click on each tab and each tab contains a different page with different information. I know I can set the required property to yes, but it would be much nicer to have an event that is triggered when a user tries to go from tab 1 to...

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...

Can you please give me an example of how to use conditional formatting in a form? Thanks

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...

No, I am using a form with bound controls

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...

Thanks to Chris and Bob. Chris's final answer gives me exactly what I need and is much easier

Hi Bob, I used that, but it allows people to enter data then it does the validation afterwards. I would rather prefer users not to be able to enter anything at all.

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...

Thanks for all your responses. Using the UNC path seems to be the best option as it ensures it is consistent across the board

Hi, the reason I need to re-link the tables is because the solution is not yet live and I was just thinking about having something robust so that when implemented, I can manage the connection paths if the backend ever moves

Thanks for the suggestion Pat. Is there a way to do this without the users needing to do it themselves to reduce the risk of errors?

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...