Search results

Hello could anyone help me with my understanding here? I have what I think is a normalised database that uses foreign keys quite a bit, as I believe (correct me if I'm wrong) is regarded as good practice. For example if I had a 'contracts' table which refers to 'clients', then there would be...

Dear all, Hopefully this won't be too difficult to sort out. I think it is probably a common scenario. I have already searched the web, but each answer I've found doesn't quite tell me enough to fully 'get it'. Regarding my 'level', although I don't write my own SQL if I can avoid it, I do...

I would like to use datasheet view for what is probably the most important form in my database. I like/need its unfussy ability to display large amounts of data at once, such that moving the eye from one record to another and back is very easy. I also really need cascade lookups. But my...

As a beginner I am not as familiar as most here with normalisation. Consider a Buildings table lending a foreign key to a Rooms table that in turn lends a room foreign key to an Equipment table. Building>Room>Equipment. I imagine that re-recording the 'building' characteristic in a seperate...

I'm a beginner. I am up against the problem where the second box will not refresh if the first box changes. I do not know how to deal with it. http://www.access-programmers.co.uk/forums/showthread.php?t=199762 Here someone posted me an example. Please look at it, especially frmSearch, which...

I am an Access beginner, particular with forms. Ideally, I would like to create a split view form. The lower section datasheet view will get used for editing existing records, and... key point: data entered in the upper form section would not accidentally ammend any existing record, but...

I know how to do this with Forms. I'm also aware that it is bad practice to use lookup fields in Tables. But I like to learn by exploring, and by experimenting to find out how stuff works. Don't jump to the conclusion I am trying to use this technique for a finished job, I'm not. I'm trying to...

As per title. This does not seem to be possible, unless Display Control can be called in SQL code? I doubt it, but maybe. This really annoys me. I want a check box to come up for my CALCULATED FIELD in my Table, and especially in my Query. Yes my caculated field will deliver True or False...

I've read up a bit on SQL, but basically I am a total coding and SQL beginner. I understand how to write some complicated Excel formulae, and that's about as close as I get (not very close). To practice I thought I'd try what I thought would be a simple easy step. To create a calculated yes/no...

I'm a beginner and mentally wrestling with a many-to-many relationship. I have an IT equipment inventory database. The main table is All Equipment, and two lookup tables that it currently references are Manufacturer (where the choices for the Manufacturer field in the main table come from) and...

Question about equipment inventory database design Hello, I am a relative beginner with MS Access. We are trying to create a database of all IT equipment in our large-medium size organisation. I have read about database design a bit and played around with the program, but I am facing a number...