Search results

Excellent, glad he got it working! Smiles Bob

Hi Kate, Let me guess, the DoCmd.Close is imbedded in the midst of the subform VB code. After the command executes, the control is passed back to the original VB module, and the next statement in that module cuases the subform or form to re-activate. Place the DoCmd.Close at the end of the...

Try Dob < DateAdd("y", -12, #04/30/2009#) in your criteria. Smiles Bob DateAdd description: y=years, -12 is take a way 12 ... translates to take away 12 years from 04/30/2009 Hope that helps and welcome to the forums.

Good example MStef. Question, wouldn't it be easier to link the table(s). Then they would be accessable like any other table. It all depends on how often you need to do this function, I guess.

Rich, I tried pushing George, and you to answer the question in that post. That type of connection table has it place at the 5NF for large database structures. I really don't want the impression the last untitled_1.jpg was fine, when it in fact is overkill for rudeboymcc's current development...

Rich, Your schema is great. I was making a comment in regards to this post ... untitled_1.jpg in the post. Are you saying, tables Flat Rooms, Properties Flats, Properties Tenants, and Property Landlord should stay in the design? I personally disagree, but I've only been programming since 1972...

Ok, so is this not the time to create a database? EG: Sections table SectionID Section Description Section info Srction National this year (Y/N) Special table Special SectionId Special Prize Number Special Prize Info

This is interesting... 1) Create a query 2) Column 1...numbergroup field....count 3) Column 2...use expression builder ... Expr1: name where CountOfnumbergroup=1 4) Column 3...use expression builder ... Expr2: name where CountOfnumbergroup=2 Etc for as many possible names Hope this helps...

As you can see from Rich's relationship, your first releationship post was not 1NF, but was in fact 3NF (even 4NF...not knowing all the data requirements). The last relationship you posted was 5NF+. The HNF (highest) is what you wish to achieve..ergo your original post. You normalized till it...

These are methods for DSN-Less Connections to MDB or SQL Server To Connect to Access MDB............................................................ For Standard Security: oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=c:\somepath\mydb.mdb;" If you are using a Workgroup...

You very welcome...and welcome to the forums. By the way, that example was meant to stir the pot, get you thinking. As you can see with the Structure table, fields/elements became data items with the table. The same could be done with other fields. The Ventilation popup could be modified to...

It seems the connection to the server is not an issue. Point 2 was suggesting an automated process that establishes a very short term connection to the SQL Server. If the number of users is not an issue, then the automation is not required.

Here is my idea on how to structure the tables and forms. Ventilation is an example that can be used for the other components (Gas, Electric, etc). I created a form called Room...open that form to see the handling of the tables.

No offense, just wanted to point out that "IF" the date was created using Now() then that statement does not work. I actually read you comment and changed my current development code, removing the #'s from the dates in my Select's. I then tested, and the results were all wrong. I tried a number...

I am back to assumption mode. I assume you have a main form (Sections) and a subform Specials. The Subform is a continuous form or a datasheet. You want to be able to 1) add a special to the subform 2) delete a special from the subform 3) move a special from postion x to position y within this...

Glad you found the answer, and welcome to the forums. Smiles Bob

Absolutely, that was what I assumed was being done...I know...do not assume!

Geroge, I didn't say the DBA's were good. LOL. They learned a lot in that exercise. And whats wrong with normalizing until it hurts (the highest NF) then stepping it back when you cannot create code to support it? By the way, do you have a comment on rudeboymcc's design and comment?

Yup, don't specify the primary autonumber field as a field in the append query.

Glad to help and welcome to the forum! Smiles Bob