I added a field on our form. It looks like it was okay but every time I put a value/data in, the value/data isn't saved. Am I doing something wrong? Did I...

I'm a new access user. I created a simple table and then created a form. I've since gone back to my table and added lookup columns in some fields. How to I...

AFTERAfter creating a form based on a table 1, I needed to add a combo box based on records in table 2. When selecting records from the combo box, I need the...

MS Access 2003 on Windows XP Sequence of steps taken to date: 1. Created 7 tables 2. Established relationships (tools relationships) with all tables using...

I have a field and have set it up as "memo" and can it looks great but when you go to, say, put an address and extra info in it it's all one line and won't...

Good Morning all, I am finishing up a 2003 application and I have come across a small problem... I decided to add an autonumber primary key to one of my...

All worked fine until we added this table to form. Now cannot even delete table and get form to work correctly. Here is SQL statement from form's record...

I have created a form in access 2003 with 1 textbox. I want to add the value entered in the textbox, to the value of a field in the table and update the field...

Hello, I'm doing a program for a friend and for some reasons it had to be done in Access, which I never used before, so I have this (entry level?)...

Hi I am in the process of creating a database. i have several combo boxes and then "Quantity" boxes what i would like to do is add a box that adds all these...

Hello, I am hoping there is someone out there who will be able to help me with this problem I'm having. I have a form with a combobox and when a selection is...

This is a follow on from a recently posted query. I am building the criteria for a query on the fly using a form which has 3 elements: 1. 2 check boxes...

I have a control that is to display in the On Enter event, a concatenated sentence including the users choices in a multi-select list box. The code is...

I have dropdowns that I use to select inputs for queries. I would like to add the option to select "all" of the options for the query. Specifically, they are...

I am fairly new to vb coding fo Access so forgive me if this seems obvious. How do I create a form to allow the user to enter new data thereby creating a new...

I have a combo box set up with a query as follows SELECT VendorNames.NAME FROM VendorNames; in the Row Source under the Data Tab When the user selects a...

Hello I want to create a dynamic form, which will create and remove fields from a form based on the data accessed. The field names, data types and...

how would one set the text in a combo box to be something like "(Select One)" instead of just being blank? Where would you put the expression or...

i have a table with the following fields autonumber mnumber ,fname, lname, etc. i need to find the last number entered in the table and add 1 to it. I tried...

hello,, I am trying to add 2 controls together to get a total R1=1 R2=2 Total=3 I am using the following =Nz(,0)+Nz(,0), but the total control keeps...