Hello! Alright so I am just trying to tidy up my code a little bit. I have a Select Case statement that I used and I have it so it runs some sql / query...

I can't believe I'm having this much trouble but I can't get this to work. I have simple table with 2 field - empname and ID which is Autonumber. I have a...

I have a .accdb database that when it is open by the User a tab shows up for every form he/she opens. The problem is that the User can right-click on the tab...

Hi I would like to add a code to form that will close the form using the esc button if required by the user? Thanks Jo

Hello- I have created a bound combo box with three columns. The bound column is 1 (the ID number). Column 2 is the first name and Column 3 is the last name....

I want to create a combo box of a list contries. I want it to be in a way that the first two countries are USA and Canada, and the rest is alphabetically....

I have a simple database, and I am trying to figure out the best way to set up the tables to work best with the form that is created. Basically there is a...

In Access 2007, I want to create a form to calculate an age as of a certain date (insurance effective date). My form will have three fields: DOB, EffDate and...

Hi, I have a text box that allow user to enter a numeric figure. I need a format that will allow me to do so. Example: User Entry System...

Hi, How do I make the text box below change from Unbound to Text. This way I can unlock the field and input info/details on the switchboard form. Can anyone...

Hi, Am not a programmer, but am able to use pretty much all of Access 2000 functions and know what's what. So - Access 2007 !!! Under certain circumstances,...

I have a table with 160 fields of academic disciplines (20) by degree type (8) for each institution. I want to create a form that will show a 20x8 grid into...

I have a main form which is unbound, a single-record subform on that (bound but don't need update here), and a datasheet subform on that. Entries and...

I have a for with some check boxes to select different types of jobs. once i click the next button on the form i would like to open another form with the...

Is it possible to disable listbox items so that users can see what are available but unable to select the disabled items. Purpose is for Inactive items in...

This error is triggered by the Change event when I reference .text property: private Sub tbxStart_Change If Not Trim(tbxTimes.Text & "") = "" And Not...

I have four tables. Customers to Contacts related by Customer ID. Customer System Inventory related to Customers on Customer ID and a Testing Table I want...

Hi, This always worked before but in 2007 it doesn't seem to: Select multiple text boxes on a form or report (all contain text in the same font)) and double...

First off, let me state that I did not design the databse or any of the forms. We have an Access 2003 (A03) file that has a form. This form's record...

I built a pop-up form for creating new employee records, and I open this form with a command button created to "Open Form". After creating the new record in...