I am trying to design a database which will be used by Technicians and Engineers to store information relating to lots of different pieces of equipment in a...

When I save a relationship layout and close the window, when I come back the tables are in the same places, but the joins do not show up. When I open...

SO I've read a little thing that warns against using the LOOKUP feature when designing tables. Apparently its not good to assign values to a field based on...

I would like to use the calendar control to set a start date in the database and then automatically calculate a date 12 weeks after that date, but I would also...

After upgrading from Windows 98 to Windows XP Home Edition, Photodraw doesn't work even after reinstalling.

Hi Guys, What do you think is better functionality and design wise: One large table (avg import 135,000 records a fiscal quarter) OR 15 smaller tables (avg...

How do I select and store multiple values from a lookup list

In Word for XP, I can't backtab using shift/tab. I'm guessing there is a box that needs to be checked or unchecked somewhere. thanks much

Hi I am Creating a Database ( Inventory Management ) And the Products I have Multiple unique Codes (this is Industry Standard). How do I use these codes in...

Hello Everyone, I have a table which is linked to a fairly large (and wide) text file. The text file does not have tabs in it, so each field on the linked...

Hi I am currently helping set up a database for a Rare Book Dealer. My first initiative in designing this database is the stock control issue. The Dealer...

I would like to change the position of buttons on the expanded field created by the Zoom() function.

Please guide me to where I can find an access template for calculating commissions on sales by sales person. We are planning to integrated to our existing...

Hi, I want to have one of my tables protected so that it's contents cannot be changed. Other tables are to be open as normal. Can anyone point me in the...

In the section about improving the performance of an Access database, MS Access Help first says: You can make dramatic improvements in the speed of queries by...

Hi, I use Access 2000 to store and report on data extracted from an RMS (Point of Sale and Back Office). To improve the reports I produce I want...

I have been using DateValues from Excel in one of the fields of my Access db to be able to sort accurately on its matching date. I'm sure the...

I have a situation where I added indexes to a table in my sql svr db back end and went into the table design from Access (where they do not allow you to edit...

From two tables I run a query which gives me, for example: RecNo Name Add1 Type 1 Joe A Plumber 1 Joe A Plumber 2 Fred...