I have a table with one of the fields a long int w/ default value set to 0. I get a null value instead. Mike J

I've inherited a project with three tables. One has an ID field (number) which is manually set, related to each of the other tables in a...

Hi there. I've had a recruiter call me about a job which among other things, involves the above requirement. Does anyone have any insight as to what this...

Presently I have clientid and ticket# set as both as primary keys. Together they can not be duplicated - so I made them both primary. However I am having...

Hi, I am creating a database that includes classroom information, such as: grades, attendance, etc. I have one table that is called Student information and...

I am working with Access tables given to me by a client and incorporating their data into a larger database. The old tables have the first name and last name...

I have a table that is created from an imported call log. The call log puts the date and text into one field...not separately. For example the resulting...

Hello... This is my situation... I am trying to develop an Access DB to capture observations where there are multiple observers that will observer for a 15...

I have 4 number fields in a table: Field1, Field2, Field3, and Field4. The default value of these number fields is zero. A user may or may not enter data...

I have two tables, TableA and TableB. In a form I use a combo Box to select data from Field1 in TableA and place it in Field2 in TableB. What is the exact...

I am importing an address register from Excel to Access 2003. I have a list of email addresses and links in the Excel file. When I go into table design I can...

Hi, I am trying to create a many to many relationship between two tables, and am currently having no luck whatsoever, Is there another way? I have...

I need to set up a database to record all of the pupil reports sent out to parents. At the moment we are using excel and although it is possible to do this by...

I am trying to relate two tables together by 4 fields in each table as follows: Table 1: Contract No., Project No., Supplement No. & Task No. Table 2: Contract...

I'm trying to use the ApplyFilter method in a VB event procedure. I keep getting a runtime error. I'm not sure what I'm missing. Runtime Error '2488' You...

I'm tracking containers, which hold parts in a small assembly line, these containers have a fixed ID attached to them and are used over-n-over again, from...

Moody The best thing to do is start the design of your database all over. ask yourself what data you want to see on your forms and reports. Translate...

My company has a Access 2002 database to track construction jobs. The database is 26MB, main table is "Jobs", which has 40 fields. When a new job is created,...

I am trying to create a new Report and I have all the necessary labels and information included, but I have some fields that are blank. I understand...

Hi All. I'm trying to create a table with a autoincrement field of type GUID using DAO code. In the past I used this type of procedure with dbLong type as in...