Good day: I have the following problem. I have a form in the datasheet view and I have some fields that I hid and that have the visible property set to NO....

I work for a therapist. He would like an Access Form that patients can fill out on a touchpad that is essentially a series of about 100 organized check boxes....

Hi, I have a DB in production created using Access 97. There is lot of data in the existing db which we would not like to touch. However, under...

(Final Part Of Loop Within a Loop) Good morning all, This is proving to be very frustating for me becasue my understanding of code is quite obviously rubbish....

Percent problem again Hi I have a form with a percent field. Percent is number and doublein the table. To show the actual percent, I put this code in the event...

Using Access 2003 w/Windows XP. I have a database originally created with the tables internal. I split the database into a front-end/back-end with linked...

I have a table of measurements made on a number of birds. For each record there are the measurements and the date, location and identity of the measurer. On...

Access 2000. I have a main table and a details table. I have 2 PK joined in the main table to prevent duplicates at the main office. The problem is I can...

I have a large database. I created a query that runs a report. My report only displays part of the database because of using criteria parameters in the...

I was just wondering if I could get your suggestions on the best table design for my situation? I've gone with one, but it has been problematic. I have one...

I've been using a application I've developed over the last year to run a self storage business. I'm in the process of fixing some design flaws in the Ledger...

Hi, I have 2 Access 2003 databases will call A (client) and B (physician). Each of these have 2 main tables, Table A and Table B. I have linked the...

I have a screen scraper written in perl that populates the same database every night with new additional information. Why is it that when I try to...

Mostly I've been able to have complete control of table design on projects I'm a part of. But recently I got a project *just* to add an ASP front end for a...

Hello, I have John Viescas' excellent book 'Building Access Apps' and the membership app is great, but it does not permit having multiple membership rates,...

In the middle of database design and need some advice - I am unsure if I went down the right path... In my DB, each customer has lots of information -...

I have a DB that someone who once worked here created. The DB is not set up properly and I don't have the time to create another one and learn how to import...

Hi all…… I have never used Microsoft Access before and I am in need of serious help. I have a project that I have to complete and have no idea how to use...

I would like to create other subfileds after answering a yes/no question so once a answer has been choosen, then other type of fields appear to be answered....

With the help of Allen Brown we've come up with this idea. Here's a simpler suggestion that identifies country, state/province + country, and city +...