If one has a normalized database, then different types of measurement data will not be in different fields, but rather in a structure with measurement.name and...

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

I hope I'm posting this in the right category.. any ideas on how to look for room availability? I have already created forms for adding reservations for both...

Hi all ! I have a strange problem here : I am inserting data from a linked table into a local table (it is a table i my frontend, that I use as a temporary...

I'm setting up a new DB for my employee training records. I have a table for employees and a table for departments. There is a one-to-many relationship in...

Ref "Why is my text being stored as Numeric" 13-Sep-05 Tina provided final solution to my question/need with this code. SELECT Count(tblPatientV1.ChartNumber)...

We have a number of split databases (Access 2002) on our network, where the users have a copy of the front end on their local drives, linked to tables in the...

Hi, I have the perenial student marks database problem which I'm trying to solve for the third time in a simple way. In a nutshell, one table of students, one...

Good morning, I have a database which will be used by more than one user. I will have the Design Master copy in my network private drive and a replica copy...

I have a field in a table and I want to require the user to enter a 10 digit number. How do I do this? Thanks

I have been trying to design a db for simple stock controll for a housing assoc. I want users to be able to select repair materials from a list and the ...

I'm completely confused about relationships between tables. Bassically, I have 4 types of transactions made by the same group of people. However, not every...

There doesn't seem to be much information around about Access Pivot Tables, and I don't do much in Excel. I'm specifically looking for how to do this ...

Can I add a date stamp (and or a User stamp) in a Text or Memo Field when a user updates my notes field (Memo)

Can we say MS-Access as True RDBMS?, What are the key differences between the RDBMS (Sql-Server) and MS-Access

hi: I have a field which is first name and it is obvious that only text should be entered, i tried validation and input mask and i tried to find the solution...

I have two table; TableA and Table B. Both have a key field named Item. When I add a record in TableA, I would like it to add to TableB automatically. How do I...

How do I set it up so that there is no referential integrity in a rtelationship of mine, but the related records in the 'many' table, will still delete if I...

I have a number formatted fields that now needs to have text added to it. if I convert it to a text field then the sort order changes from record 1, 2, 3, etc....

As most of you probably know from previous posts, I am creating a parts relational database. So far with some great help from this discussion group it is...