Search results

I've been creating a fairly complex (the equations and calculated fields anyway) Access 2007 database for the company I'm at right now for the past several weeks. I have run into numerous issues and have been able to overcome them all (with help from Access World Forums of course). Here's the...

I have a relatively complex query that I have built (it is pulling information for calculated fields from roughly 30 other queries that were created to make calculated fields) and one thing is really causing me problems. We have clients, but some clients are split into 2 clients (Client and...

Calculated field issue dealing with other queries Here's the deal. In my continuing quest to replicate my company's fee structure in an Access database (to create a query to spit out the information they need in the format they need it in) I have run across numerous exceptions which have...

If/When (most likely when) this becomes way to complicated to understand please feel free to ask for clarification. I am unable to put any code or databases on here as of yet due to permission issues at my place of business. Here's the deal...I'm creating a database for my company. The database...

I have 2 unbound controls. 1 combo box and 1 textbox. The combo box is comboID and the textbox is txtPopulate. I want to send this information to 2 different fields in a table in the current database. This is the code that I have and for some reason I keep getting an "end of statement...

Here's the deal. I have been working on a project (I am an intern at a large company) for Access 2003. I have been coding it and reworking it and I just finished it yesterday...or so I thought. Apparently my superiors who are running the project are scrapping EVERYTHING that I did because they...

This is probably a really simple solution that I am overlooking, but I am just not able to figure this one out. I have two combo boxes (User ID and Assignment ID). The Assignment ID combo box is dependent on the User ID combo box. This works just fine. However, this is what I want to do. The...

This code is for anyone who wants to limit the user to which keys they are able to use for data entry. Private Sub myTextbox(i_KeyAscii As Integer) Select Case i_KeyAscii 'Allows users to use ONLY integers 0-9 and all capital letters as well as the backspace, except for vowels Case...

This code is for anyone who is new to VBA and/or Access and is not sure how to deal with null values in their textboxes. This code changes the null values of the First Name and Last Name textboxes to empty strings. If you don't want an empty string then you need to do some KeyPress event...

I want to make it so that the user has to hit my close form button in order to close the form. This is the code that I found. This works perfectly, except I am unable to close the form because I get the following error... Compile Error: Label Not Defined It then highlightes the line Private...

I have two combo boxes that contain information that needs to match. The combo boxes are Assignment ID and User ID. I have these choices in the combo boxes directly linked to the field in the table where they can be located. The table that these two need to match up in are in a table for...

I am under directions from my bosses to use unbound controls and then have the input go to the appropriate fields in the appropriate tables upon the clicking of a submit button. I am not sure how to go about writing code for this. Could anyone give me a hint as to where to start? I had the...

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

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

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