Hello My database has 2000 to 3000 records. My staff does not know how to use queries and expressions to filter it. How could I create one simple form with 2...

I am a relatively new user to access. I am having a problem. I have 2 tables, each table has the same field and it is formatted as text. I need to be able to...

I am relatively new to VBA and access. I have existing access tables that I use for invetory. I have a barcode system for tag # and I track coil inventory....

I am new to Access, and I want to know how to display just the month and the day not the year. Is there anyway to do this

Hi I am fairly new to Access. I see code posted for various functions but have no idea how to use this. Does anyone know of any simple guidance which would...

i dont know how to ask this question, so bare with me please. i have an Access form that is linked to a table. The table has columns for Name, Number, Date,...

I have a database with names and 4 fileds for the phisical address and 4 fields for the postal address. Some of the address fields may be empty or not. I want...

I have 2 tables: Events and Vendors. I want to be able to enter data in the Events table fields: Hotel Name, Hotel Address, Hotel Country from a drop down...

I have 2 tables one for all my vendors and one for all the meetings we process. In my meetings table I have fields for different types of vendors,i.e....

I have a user who is getting the "Update or cancelUpdate without addNew or edit." error message 3020 on a data entry form. This happens when the user first...

Hi, We have a pests Spreadsheet which is used to record the types of pests found at different locations. If the certain pest is found there, then there is a 1...

I have a database for purchase orders with approximately 40 Manufacturers. I would like to have a separate pricing table for each manufacturer. Is there a...

I'm a new user of Access 2003, what's the best method for learning VBA code?

I have a form (Worksheet) with a subform (Equipment), the subform is a data sheet for entering equipment for a proposal. I would like to bring the subform...

I am trying to write an expression the will give the sum of a column. example: I have a quote sheet and I want the sum of the "Item Cost" for all items....

On a purchase order....how do I creat a page break and repeat the header only when I have more line items that will fit on one page?

I know that in table, general tab, format will force uppercase. When I view my data from the table all is uppercase, but when I query out this information...

I am trying to write an expression that will bring together my address, city, state, and zip. I need the code that will start a new line after the address,...

I have a form "PurchaseOrders", on the purchase order form I have a cmd button to take me to another form "ItemList". This is used when an item is not in my...

I want to have a mark-up field for calculation the mark-up of my products, every time I enter 1.4 the system rounds the number to 1, 1.5 rounds to 2. How do...