i need to create a recursive function that allows me to create a different table (with the same fields) depending on an answer entered into the current table....

I have 3 tables linked together. Customer, Fillers & Service. All three are one to many. I'm trying to change the name of two or three fields in the...

Hello everybody, I created a survey questions table with the following fields: SurvID QstnID QstnText QstnCtrlType AnswCtrlType QstnType

Hi Everyone Somebody suggested that I could use update query to add all values from one field to another one. I want to add autonumber values to a numeric...

Fire District has database of running cards (directions to streets). The database has a front end and back end. We are building a firehouse in a different...

I am the Treasurer for a Habitat for Humanity affiliate. I am trying to create a database to track the hours worked by our volunteers. I have already...

I have a report that within the Report_Open event, I create a temporary database and create a linked table to it (using the code fragment below). Dim...

Hello All I have to create a facility within an existing 'Employee' database to manage employee sickness absence. The data to be input will be the employee's...

I have three tables in my new database: Courses, Instructors, & Courses and Instructors. Courses has Course Number (AutoNumber, key) and Course Name (text,...

Hi there, I am trying to wrap my brain around the following problem unsuccessfully. (Using Access 2003) I have the following tables: Contacts,...

I have a single database to cover inventory where there are 3 types of inventory and different detail questions to be asked for each, depending on what the...

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

I have been using Beta 2 for the last fortnight and I am still asking myself the question - What is -really- new in Access 2007? They have spent all their...

numeric fields seem to default to zero - despite having no apparent default value - you would imagine that if a field defaults to zero, then zero would appear...

Hi! Like I often see in these, I'm somewhat new to Access and I'm tasked with making a database that tracks employee performance in our warehouse. So what I...

I have a field that consists of an alphanumeric string that serves as a barcode. It's Input Mask looks like this 00"-V"0\T0\R0\-099\-0. A barcode will...

HI, I've designed a very complex database (60 tables x 550 fields x about 150 relationships) and have come up against a huge obstacle. The database...

hi how i could know teh size of my tables ? also my forms

Ok, well, I've been reading a few threads about Primary Keys, and the use of natural vs. surrogate keys. Sadly, a little learning is a dangerous thing, and...

Hello, I have a table with a fe for users and be that holds just my tables I have code that will create tables, but it creates them in the be and links them,...