Search results

Hi there, I have been asking question on the forum for the past year. It is a great resource...I am so glad it is here... I am a librarian, but have studied databases some, and worked on one project (I am on reading a recommendation I received about the project--an excellent one, I just want...

Hi, Quick note--I was not in the best mood Sat. and Sun., so sorry if that became reflected in my posts. I really appreciate the help--this forum is awesome! All the information is extremely helpful--I will study the examples provided. So, I will be a better forum member in the future, I...

But, you do bring up some concerns I have. I don't have the IT people to help, I am making this at home, using the server where it will be implemented is not an immediate option... However, my friend needs a database, has no fund to hire someone, and has no help from IT--so, here I am :) The...

Rabbie, Oh no, not to change the design of tables! Just make the user input their initials when they change data in the table, so it is known who last input data. I don't think these users would want (or even know) how to change the table designs! But, I won't be on staff as the database...

Hi, Thanks Gemma--and HiTechCoach-- Sorry if I sounded frustrated--I am learning on my own at this point, and that can be a frustrating experience-- I think Gemma's suggestion would work for this office--not that many employees. And, "last updated" is really what is required (from what I...

I don't know that building in the multi-user environment from the beginning makes a lot of sense--the design, the table structure, queries, would all have to be put in place first. To quote an article cited in a previous thread: "Users often ask at what point in the development process do...

Hi, I am appreciative of your help--I just wanted to clarify what I knew. I spent many hours up late studying database design (and other IS topics)--I just have spent most of my career as a cataloger for a library, so haven't really worked with database design and implementation in a work...

I will read the bit on sharing a database...I have actually already designed the database, and implemented all of it. I have studied database design in a master's course (including extensive study of normalization), and took advanced courses--I know about normalization, indexing, SQL...

As an update--just starting to read about splitting the database--understand that is needed! MC

Hello, I will first apologize for what may appear to be a naive question. For the database I am working on, an important requirement for the user is the ability to track the last person who edited a table. In this way, the manager is able to track which employee has <or may have> a form...

Thanks, Gemma-- This got me to think of various ways data could be input, for example, a set of data on grantees needing grant money, but their project may not have a potential funding source at present. That flexibility needs to be built in... The relationships are a bit tricky--the...

Hello, I thanked you twice on accident, not realizing my first post actually made it on... So, I edited this to explain why there were two-- Anyway, I will escape...it is Friday night, maybe I need a bit of fun, and less computer :) Michael

Hello, Just a quick note--what you suggested worked very well. Thanks for taking the time to respond--I very much appreciate it. I am thinking about exploring VBA for Access...I have done some PL/SQL, so it may not be an entirely new field.. Anyway, many thanks! Michael

Hello, First off, thanks, everyone, for the responses I have had so far--they have been wonderful... I am having a strange form-design problem. I have a design in which grants fund specific projects. I have a relationship like this: [contracts/grants] (N) ---- (1) [projects] So, each...

Hello, Thanks for the response. After some experimenting, I find I need to simply find a good resource on forms--the books I have are not that helpful (one from Microsoft Publishing). Any questions I would ask now would not be very productive, until I know a bit more. But, your reply has...

Hello, I have a question relating to creating forms, the relationship between forms and underlying tables (record sources). I'm making a database that tracks grants administration for an environmental protection agency (my friends works there--I'm not that impressive :) ). A major rationale...

George, Quick thank you for the reply--this project has been great because I have been able to put into practice some topics I learned in course work (ethnomethodology in action! :)). I appreciate your time--I hope to help others, too--it's awesome when something like this is available...

Hello, New to this community...glad to have stumbled on it.. I am using the "relationships" activity pane, defining relationships between tables. In my database design, I have defined some specializations..the parent table of these specializations is participating in a many-to-many...