Search results

I put Cancel = True in each of the edit conditions if the condition is met. Then I made changes (does not work) to the subroutine 'CloseEditForm_Click' as follows but it goes ahead and does spell check and updates the table. I thought if I checked for Cancel = True it would go to the exit as...

Great responses! I created a routine to edit all of the controls that need editing with the submit button but now I need help with the syntax if I trap an error. I want to bypass the updating if there is an error. Does Access know there is an error by just using the code Cancel = True. Sorry...

How do you handle a user tabbing through a control that needs to have data entered in it? LostFocus is the only thing I know of that handles that situation. Appreciate your help!

I am stumped. This is working fine on another form in this database. What are the reasons for a SetFocus not working? I am displaying an error message if the user leaves the control without entering data (LostFocus). I then set the border on the control to red - works fine, but when I try to...

Help please! This may be the beginning of a string of questions. I am developing a new tab in my database that uses a field 'Client' that is entered on the first tab and originates from a 'Client' table. For this 'Client' a list of students and identifying information needs to be entered into a...

Hi! I have several places in my code where I am performing the same initializations. What is the syntax for setting up one routine that can be performed from multiple places in the code? Thanks, jketcher

Hi, !never mind I figured out that I needed to do a Requery on the subform) Thanks anyway! Needing a little more help. The database I am working on consists of four tabs with data from two tables. The form in question has a subform that pulls in a 'Description' field. The problem is that it...

That worked! Thank you so much. :) jketcher

Hi, I am working on some code that will check a combobox entry (category)against a table for duplicate entries. The code is working (with help from your colleagues) to display a msgbox that will redirect the user. But, no matter what I enter to redirect the focus and end the sub routine, I get...

Did anyone get a chance to look at my last message. Still need some help. Getting a runtime error 2108. I need help handling this. Thanks so much! jketcher:confused:

I entered the code you recommended and when testing got an error message to the effect 'You must save the control before you execute the GoToControl action, the GoTo Control method, or the SetFocus method.' Here is the code I created thinking it wanted something to respond to the OK button...

I need to navigate from one tab to another tab depending upon results of some If/Else code to edit combo box data. Here is the code that works to produce an error message if a user has made an invalid selection. When the msgbox pops up and the user enters ok, how can I display the correct tab...

It WORKED!!! Thank you so much. Jketcher

I entered the code using the model you recommended (by the way thank you so much for all of your help). It resulted in a syntax error: (missing operator) in query expression 'Client = xCollege AND Category = Application and Verification: Correcting Errors'. The good news is it is picking up...

I am trying to set up an edit that will return a message if a client/category combination is already in the table. The user selects a client - no problem with this. Then selects a 'category' from a list of about 150 categories. The problem is that the client and category fields are not keys in...

I entered the following code and received an error message. Private Sub category_AfterUpdate() DoCmd.ShowAllRecords Me!Category.SetFocus DoCmd.FindRecord Me!Category Me!Category.Value = "" If Not IsNull(Me.Category) Then MsgBox "Category already entered, select Edit tab to...

I am new to developing VBA code and need some expert recommendations. I have two bound combo boxes that are based upon non-key fields. One holds a list of clients of which one will be selected by the user (Client). The other holds a list of Categories for entering findings (Category). A client...