Require to validate all Identity Nos of my clients when capturing data. When you enter the invalid ID no, it must report error.I have the validation code from...

What I am trying to do is have two separate tables. One is for current inventory and one for inventory disbursement. I would like to have the quantity...

I need to make a database for a Career Day coming up soon at my school. There will be 300-350 students making 5 choices of 20 different presentations. However,...

Hi everyone, Happy new year! Using A02 on XP. Have my DB's in a multiuser environment in a shared drive. I have one lone DB that needs to be a single user...

I inherited a db and I am trying to add new reports to the DB. Our current report functionality is set up so you can enter the date range you want to run...

I'm looking for help with an expression/formula. Situation: Text23 is the subtotal///Checkbox29 is the check box that would be checked if customer is...

Does anyone know of a link to a list of all Access's datatypes, ideally showing name, how many bytes each of them takes up, and min/max values. Must be...

Create Your FREE Niche Search Engine For Earning Affiliate Program Commissions. http://Findality.com/tissa.htm

Selling your digital products via ClickBank is the easy way to multiply your online sales. a.. Leverage our 100,000+ active affiliates to find new...

I have a form that is posting a transaction amount straight to tbl_transactions. I have a crosscheck on this same form (frm_Transactions) that will not allow...

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

Hi, im a begginner in Access so please be ready for my question . Im designing a table, and have a data field, i want to be able to make a criteria so the...

I think I may be over my head, but best ask. I need to do the following. import an excell sheet of time logs and have my database automatically calculate...

I have a database on an intranet that has tables that are shared by 15 different users. I need to limit the users to acess only their tables without...

I want to change the week starting day from Sunday to Monday I have Access 2000 (9.0.2812).

How can I have the value of a field depend upon which table the value of another field can be found in? e.g. Table 1: Table 2 has a, b, c, Table 3 has c,...

I currently use A2003 w/sp3 on a lan. All databases are designed FE/ BE. A piece of the code of a module I've written inserts the hyperlink to a file stored...

sorry for the cross-postings - not sure where this best fits. running access 2k, in front/back split configuration. focusing on front end application. my...

I am designing a system for entering tickets. I want it to be auto number. Problem is the company is at ticket # 3516, and I wish to start the autonumber...

Hopefully this is the right newsgroup to ask this (and I apologize up front--this is probably going to get kind of long).....it crosses so many lines it's hard...