-- Gil

I am having difficulty with normalizing data. I am creating a client call center database. Currently, when a call comes in from a Client Contact, the users...

I'm storing some fairly long filenames/paths in a table (they easily exceed the 255 character limit for Text fields). Does using a Memo field unnecessarily...

I am using access 97. Is there a way to export a table or query from access into a .csv file in another directory on my "C" drive? Thanks.

Hi there, I received some good advice relating to having an alphanumeric reference number, which I have been able to create and it works well in a query....

Hi all, I'll try and explain this as best I can to make it easy on you. My database is for keeping track of documents, drawings and action items all relating...

I'm quite new to this so any help will be very much appreciated! I have a 'master' table that holds the core data on pupils (Each pupil has a unique...

Will the websites created using Sharepoint portal server 2003 will be secure? Or do i need to have a third party software for doing the security job?.

Hi Found a problem I can not fix (back only recently to coding in Access so I am very rusty!)... I am importing a database from a legacy HR system, and it...

I am using a normal SQL script for creating a table : CREATE TABLE sample ( id int NOT NULL, value1 int NOT...

OK, this is what I have so far from John V.: Movies MovieID Autonumber Primary Key ' links tables together Title Medium DVD, VHS, CD, Super-8 film, 8-track...

I'm creating a database that has ~500 records in several different tables, each record having a PDF document attached to it as an OLE Object. The database is...

I am using Access 2003 and want a list box under the heading Division for a personnel database. Each employee will be either in Painting,...

Hi Jeff Error message when using module "OpenMyForm" is The was an error executing this command". I copied and pasted your new suggestion in but am...

I need to set up one table of basic information for our physicians that can be the start of several other tables. However, I will need all the other tables...

I want to import data to an existing table. I want to overwrite the data for existing primary key records and append new records for those that do not already...

In the Edit Hyperlinks/Exiting File or Web Page/Browsed Pages is there any way to remove the reference to previously visited sites and are these stored locally...

I am designing a database to manage product returns. I'm after an experienced persons opinion regarding set up. Can someone please help and/or make...

I am designing a stock control system that requires pricing information. I Have tables that deal with (amongst other things) Purchase Ordering and Issuing of...