I would like to sort data alphabetically in ascending order based on a column of names. I am then exporting the data to a SQL database, but when I do so the...

I have a table that decided to be "un-editable." I cannot change any data in datasheet view. The computer just beeps and one of those prohibited...

Im designing a stock control system in access, and would like to write my own code for one or two simple macros which I could use. Trouble is, I dont know any...

What I have is database (still developing) for a small storage business. We have it setup to print letters like invoice, late letters, balance due etc. I need...

I created a form that is filled by data input from a barcode reader. Once the last field of my form is autofilled, I'd like access to open a next new...

hi, I am designing a calculation program. It has 2 tables, calc_header, calc_part The calc_header has many parts. and the product_price The calc_part has a...

Before you create a database what should have been thoroughly completed?

Does anyone have a recommendation on how to create a database to track number sold in a sequence. I have an order form that has a reference number. This order...

Does anyone know how to minimize a form automatically when you open another form? I have a Master Switchboard and have a couple of windows I'd like...

Where would I go to learn about form size? I would like my forms to be able to open up at different sizes and to open in the browser in different places that...

Hello, I hope someone can give me a little direction. I built a database, which has actually turned out to be very large. I have learned along the way that I...

HI, I would like to use a validation rule for a field which would restrict the values to be entered based on the previous fields combo box selection in...

Hello, I was wondering everyone thought on a problem that just occured with one of my tables. Yesterday I noticed that in one of my tables that all...

I need to create a data base of names and addresses that can be printed onto labels

I'm using Chinese windows 2000 with sp4, and English office 2000 with sp1. I design a table with creating 1 text field and 1 date field, and have "phone"...

I created a switchboard using the switchboard manager. It shows up in the manager and the swithboard table, but does not show up in the forms area. I can't...

For design simplicity, all of my lookup tables have two fields, an autonum for the primary key and text field for the value. Example: tblPriority PriorityID:...

I've had to break a multi-relationship (three - one-to-one) between two tables (say "A" & "B") in order to edit the properties one of them. The problem is each...

You can't query the fields directly with SQL. There are options such as the Documenter or snippets of code like this page on Allen Browne's web...

If I have a lookup table consisting of a single field, should I need to have an autonumber primary key in addition to that single field? Currently I have only...