I have a field in my column for employees to enter the day of days of the week. I want them to be able to enter one day, i.e. Mon or several i.e. Mon-Thur Is...

Hi Groupies Does anybody know what is up with the F6 button in table design mode? It used to be that you could move between the field names and the field...

Hi all, hope you can help me. I have a huge (and I mean huge - over 200,000 records) database that I use for telephone and contact data among other things....

Should I use two tables related one-to-many with lots of duplicate data? Or should I reduce redundancy into a single 100+ field table? And could I break that...

While creating my first database, I used lookup tables before I knew better. However, I can't figure out a way to remove them. Layout: static tblCounties -...

Hi I have a problem in access 2002. When I add a table to a query it changes the amount records displayed without me adding any fields or changing...

I have created a db for a service centrei based on northwind my invoices sometimes only have a labour fee and no parts (products) are used this expression...

I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please

Hi I would like the value of a yes/no field to change to yes on click of this field in a form then update the value of a date field in the same form to...

Hi I've created a report, when I print it I would like to print 3 copies 1 with the header back ground in plan 1 in yellow 1 in green . What is the best way...

Hi I've created an invoice based on northwind. I would like to create a table with the invoice total & vat in it . Because this is generated in the invoice...

Hi i have purchased a Brother ql570 label printer I need to print a label in my db with this my problem is when I print my label it prints 2 blank labels as...

I was thinking of creating a table with the new attachment field. I want it to hold photos. Does this field bloat the Database?

I recently updated from 2003 to 2007. In the relationship window I can pick the tables but the relationship lines are missing. The database is functioning...

Hi All, Does any1 know if access 2007 has a design wizzard as I aint got the slightest clue how to design a database to my needs Thanks Chris

Hello, In my database, I have an Office Number and an associated EU title. Due to structure needs I cannot combine these two pieces of information, but when...

I have 2 tables that are linked: Proforma Invoice and Items Ordered. For one Proforma Invoice, there could be many items ordered. The challenge is that I need...

I have a database which tracks client investments. Periodically we have to recommend a change to these investments. When we recommend changes I need to...

I need to graph a Gantt style chart in Access. Is this possible?