Search results

I understand your confusion. I don't know why they want it this way either. I would think that the way it is is fine, but they want to do it this way. I have learned that apparently you can make the controls unbound by going to the properties in design view and changing the Control Source to...

What would the code be like to get the input to the correct table? Would I need to use something like... me.txtUserID.ControlSource = ... or something else? Is SQL involved at all for telling the form where to send the data?

So...what I need to do is put all of the necessary code in an AfterUpdate even for, say, a textbox for User Id's (txtUserID). What I would do would be to use specific code to tell the DB which field in which table the information is connected to along with any data validation checks I want to...

Here is some code that will only allow the user to hit the backspace key, upper and lowercase letters and integers. You can adjust this by simply taking out sections or simply taking out specific keys. Private Sub txtUserID_KeyPress(KeyAscii As Integer) Select Case KeyAscii 'Allows...

I have a database and have to create forms for data entry. However, I have been informed that having the controls bound to the fields in the tables is out of the question. I was just wondering how I would go about getting the information to properly submit and be transferred to the appropriate...

Here is some code to prevent users from hitting certain keys that are not part of the alphabet or integers, such as F1, Esc, Ctrl, and so on. Public Function DisableKeys(KeyCode As Integer) Select Case KeyCode Case vbKeyF1 'F1 Key KeyCode = 0 'Makes it so that if user...

Here is some code to override and change the error message that the user gets for specific errors. Private Sub Form_Error(DataErr As Integer, Response As Integer) 'Overrides default error for input mask violations and replaces it with a more descriptive messagebox Const INPUTMASK_VIOLATION...

This is some code that I ran across that will let you know the error code for the particular error. This is extremely useful when you want to change/override the error message associated with it. Private Sub Form_Error(DataErr As Integer, Response As Integer) MsgBox "Error#: " & DataErr...

Also, thanks to your help. I was able to use this knowledge to actually work backwards through the query that the wizard created so that I know how to run the queries myself now, saving time and allowing me to have the flexibility of changing controls in later iterations. Thank you again very...

PERFECT! Thank you so much. I was told to just use the autoform version at work so I did not even think to remake it using the wizard.

SWEET! Thanks for the advice. I will give that a shot.

Public Function txtUserIDAsciiKeysToAllow(KeyAscii As Integer) Select Case KeyAscii 'Allows users to use ONLY integers 0-9 and all capital letters as well as the backspace, except for vowels Case 48 To 57 'integers Case 97 To 122 'lowercase letters Case vbKeyBack 'Backspace Case Else KeyAscii =...

Here is what I am trying to do. I have several combo-boxes that are, at least for the moment, bound to controls on a form and bound to certain tables. I want to have the user open the combo-box and choose from a selection of text (words) that correspond to different areas of the organization...

I put this thread in the Forms section as well. Sorry about that. I tried to find the move thread function but was unable to. I am really short on time so I was trying to do what I could. I will be dealing with this in the Forms section after this post. To answer the questions... What I am...

I am not exactly sure how to deal with the problem by correcting whatever error there is or that the computer thinks is there. Howver, here is some code that will help tell you the error number and some code to change the error message to whatever you want (including absolutely nothing)...

Sorry about that. I am not extremely sure myself because I did not realize that it might be possible to not directly enter data into a table. I was given very little direction at the beginning of the project. I was told to make it possible to use forms for data entry for the four (4) tables...

Hi. I am new to "in-depth" Access programming and structure creation. I have done some programming already and have made switchboards before, but nothing super complex by any means. I am not sure this question goes here, but it looked like the best fit to me. I am making a switchboard in...