Search results

Hey guys, slow down and look at the audience here....you are giving advanced table design advice to a new non technical user who simply wants to get started with Access to simplify a horrendous task. We want to take baby steps. So far, by breaking one huge table into logical groups, littleme...

An old DBA expression, Normalize till it hurts, denormalize until it works. In a large corporate environment with 187 tables normalized to the average 2nd level, I had the DBA's experiment...they were only able to normalize to the 4th normalization...they really couldn't understand the 5th. The...

Excellent start! I see from your Database, you have already broken the Room Table into logical tables. That will make the creation of forms simple. The report as well will be pretty easy using the query that joins the tables (the query is your one big Room table). The management of many...

My memory is foggy with old age, but if I remember correctly, I searched the Microsoft Support and found a patch that is not part of the Office Updates when I had a similar problem on one of my Vista machines. Like I said...foggy and probably wrong but it wouldn't hurt to search Microsoft Support.

I understand now. Couple things... 1) Until the database is closed, you will be logged onto the SQL Server that you said has a limit of 3 users. 2) Im not sure about the importance of the user count on the Sql Server, but if it is important then..You may want to automate the process. Click an...

namliam, thanks for helping... Microsoft in their help advocate the use of date functions. They also advocate translation for comparisons. They do this because of the way they store the date ... the functions and translations remove the time (decimal) component when it is present. Using...

You have done well so far! The more info we have the better we can help, in that respect what is the purpose of the data being stored. Is this a simple data entry, update, and online lookup? Or, is this for reporting, and if so, by what type of grouping? This combo box appears to be the source...

I agree, Could you create one table with a test project (remove all the names and replace with test client, test addr1, etc.) and a room with all it's elements (again changing the data to 1" ... we just really need the field names). This will allow us to determine if normalization can be...

I believe you have 2 tables: Table 1 = Project Table 2 = Room Each project has many rooms. Each room has hundreds of fields Is this correct? Sorry to go over and over this.

I have attached your DB with the changes I made.

What version of access are you using?

No, in access 2007 I got 5 and 2, like you stated you wanted. I editted the previous post ... I wasn't sure where you want the exactly 7 days ago to fall...I have it in both dcounts.

I am using Access 2007. I have tested what you sent and made a few tweeks. 1) In the carried in from previous week =DCount("[Request Type]","Sheet2","[Request Type] = 'PLA (New)'" & " AND [Date Received] <= #" & DateAdd("d",-7,Date()) & "#") 2) In the received this past week...

Question, are the hundreds of fields associated with one room, or one project?

If it is not confidential, attach it in this thread. Maybe someone else might shed some light on the problem.

Having delt with architects, I understand the vast amount of unique elements/fields you have. Question, how many of these are blueprints or diagrams? If there are a lot, then the access database limit may be a larger concern. I agree with Geroge, hundreds of fields is a bad thing...normally. In...

Hi Bill, The forum is a place where a question is asked and hopefully you can get an answer. Since you are learning, you have had a number of followup questions. I believe you have a fair start now, and if you believe designing a new form will improve your application. Feel free to continue with...

George, If you have 300 unique elements with no commonality for one Item, one table with 300 fields is appropriate. Not a desired condition, but to break a table into many tables, linked 1:1 is even less desirable. Now, if the elements can be broken down into logical groups, such as ventilation...

If that data is unique and a component of the "Room number", leave it as part of the table. You can extract the data for the consultants from the table. When updating the consultants data using an Update Table function, any deleted records will be written to an Update Error table (created by...

Sorry, I missed that when I went back through the posts. Try =DCount("[Request Type]","Sheet2","[Request Type] = 'PLA (New)'" & " AND [Date Received] >= #" & DateAdd("d", -7, Date) & "#")