Search results

IsEmpty() is a VBA function to check to see if a Variant variable has been initialized to a value. .... So are you trying to see if the Query "Check_Date" has any records? and if not, then execute the query named "Append_EC_Totals(Trend)"? If that is the case, then one method that should...

>> Because I do everything the most convoluted way possible. There's something wrong with my brain. :) << Welcome to the club!! ... :) >> Wait, maybe there was a reason I used the subquery. I wanted to order by Package, not PackageName. Package is an alias, which can't be used in the Order...

This is a behavior of the query compiler/optimizer for JET. The "square bracket" syntax is the sub-query syntax for Access 97 (A97 will not accept the parenthesis syntax). So when you go from ... SELECT * FROM (SELECT * FROM SomeTable) As vTbl To this ... SELECT * FROM [SELECT * FROM...

Grasping a bit here as the quick sample I threw together could not duplicate your experience ... - What is the base height to the sub-frm source object compared to the height of the sub-form control? - What is the view mode of the subfrm source object (datasheet?) ... do you have all other...

You are most welcome! .. Good luck with your project! ...

>> Or alternatively is my procedure completely wrong? << You really should investigate a "Crosstab" query !!!! .....

>> I know how to do this using queries of queries with the Design View interface but would like to do so using VBA so that it all occurs 'behind the scenes' without crowding up my database with premade query icons. << I am assuming you mean that you are creating a Crosstab query object? If...

The first think you need to do is remove the spaces from your Table names! ... those square brackets can, and do, create havoc with the suggestion I am going to propose ... The following SQL will return all the Contacts that have NOT had CommunicationID number 9. SELECT Contact.ID ...

>> non-Microsoft Access Databases << The "non" seems to become invisible with the lead in of "does not suppot" ... I had to read it twice to make sure my brain absorbed it... :) SQL help ... JET SQL Reference ACE SQL Reference The are both probably the same information ... but I thought I...

Hey Banana! ... My quote: "So a relationship simply defines a rule for your data.." "Data" does not mean the fields values in that statement its meant to be the "data" as a whole, as in the structure of the framework in which the data values are stored. Just like an INDEX really has nothing...

I would suggest you check out the results retruned by sp_who and sp_who2 In a passthru query from Access, you SQL property would look something like this ... EXEC sp_who or ... EXEC sp_who2 You can then use the PT query objects as sources to other query objects and thus filter the...

- When you opened the file in A2007 did you convert it? to A2007? - "I have sent back small database objects" ... what do you mean by this... Do you crate a stripped down version of the db? .. - If you create files for her, I would suggest that you set the default file format to mdb (Office...

>> On a bit of technical note- is it really fair to call Access's Relationship without RI a relationship? << Yes .. is it not only fair, but it is correct. A "Relationship", by definition, is used to show (or define) how column(s) in one table are linked to column(s) in another table. So a...

My summary ... and possibly an important point ... Relationships with Referential Integrity: control data going into the database (data integrity, as has been eluded to) JOINS: Control how we get information OUT of the data (ie: how we view/present/extract the data) Relationships WITH OUT...

>> but often you will find yourself creating records in an accounting period AFTER the true accounting period << True indeed ... the point of my post was meant to reveal that the table should have a date of some sort, then the UI should filter on that date accordingly ... basically trying to...

I am assuming you have a date/time "stamp" (Date/Time typed field with a default) on your records correct? ... If NOT, then you need one, and default the field value to Now() ... With a Date/Time typed field used in this manner, there is NO NEED for more tables ... just filter the date/time...

The bracket modification is how the Access "Opitmizer"/Compiler/What-cha-majig behaves... You create this really nice looking SQL with a sub-query, then POW! ... Access with drop the parens and add square backets and a period, when the query optimization is saved. Note that the execution plan...

How was this table created? What is the datatype (assuming text, however, if you have a Lookup Table defined at the table/field level, you may visually experience blanks, when in fact the lookup just does not have a match) ... ... given all this, and the assumption that the field is a Variable...

>> your query did not work, sorry. it gave me a 'syntax error in the FROM clause'. not sure why << My parenthesis seem unbalanced, also was missing a character (PropIDBx4 instead of PropIDBx14)! ... >> it's a bit too complex for me.. << Mine is no more complex than yours! ... :) Here is...

Why not use the standard TreeView control that ships with Office? ... Since it comes with office and is installed with Office, I would not think there would be any concerns as to the presence of the library.