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....

Hello, I'm setting up a database that I would like to capture information from multiple spreadsheets. The spreadsheets will contain similar fields, but will...

How do I format a textbox in Access to only take addresses in formats - streets only St., Place only Pl., Avenue only Ave., etc. ? If I am suppose to use the...

I want to create an access database. Now from a query that I will be doing every month from MySQL i will be importing an excel sheet. Now on this sheet there...

OK... I have taken your advice and have change my way of thinking and switched from Excel thoughts to Access thoughts. With respect for my scenario of a...

If I create my database, can it be shared amoungst users. In other words, we do have a workgroup set up between all of our office personel, with a main...

Can anyone assist me in my design? Real world: I am a manufacturer of goods sold to a national retail chain. I have 10 different items in 1800 stores. Every...

Is it possible using the input mask to format all data displayed in a field to Title Case? I've seen that you can use: All characters that...

I am trying to enforce referential integrity on tables where a compound key is implemented. I want to enforce integrity on the DETAIL table so that it can...

Hi I need to develop a database that outputs a monthly Statement where the first column should be "Week Beginning" and show the dates of all the Mondays in...

Hi all I'm having an extremely difficult time trying to design a database for a Childcare centre. There seems to be a lot of variables, but the...

Hi Just want to get some feedback what is better business practice - for a record to be deleted or just flagged as inactive? I'm working with Insurance...

I use a msgbox with vbYesNo to return 2 option (Yes/No), instead of displaying "Yes", "No" I want it to "In" or "Out" buttons, how can i do it? Thanks Qan

Hi Listers- I have this data file that's exported from relational database and it's being use as datasource for merge document. The problem that I'm having...

Hello, I have a seemingly simple question: In general when joining tables I assume we generally use the default option which is an inner joing/ both tables...

I have (in an Access 2003 database) a series of fields of the yes/no data type. I would like to transform them into fields that have the names/topics of the...

I have a new Windows Vista Premium 64 Bit, and my Microsoft Picture it! 2002 does not work on it, as it is no longer available and my question is what is out...

I posted a request for advice on table design and received a reply from "Henry" who kindly suggested I should attach a copy of my db to him. I realise no-one...

I am trying to build a database that will measure performance management in the delivery of a service The table I have built so far allows the user to...

I'm not too savvy with interfaces in Access but I need to know at least how to start one like this: In this interface, I need two buttons--CLIENTS and...