I want to sort my OrderID descending in a form. I wrote my row source as: = SELECT [OrderT].[OrderID] FROM [OrderT] ORDER BY OrderT.OrderID DESC The error message is: The syntax of the subquery in this expression is incorrect. Check the subquery's syntax and enclose the subquery in parenthesis. Please rewrite my statement correctly so that I can see how it should be. Thanks
Reply from Alex Hedley:
If you create a Query and set the Row Source to your Query does it work?
Hi :) Is there a way to make the Crosstab Query show in a Form or made into a Report or is it easier just to use Pivot Tables? Alex
Reply from Richard Rost:
Since the column headers will change in a crosstab query, you're better off using a PivotTable or PivotChart... unless you're SURE they're not going to change, then sure - build a form based on your crosstab query.
No, a cartesian product is every record from table 1 paired up with every record from table 2. A many-to-many relationship is SPECIFIC records from table 1 joined to records from table 2 using a relationship specified in table 3.
Elsa, I have not covered Access User-Level Security in any of my tutorials as of yet (see my recent Blog post for reasons why). Depending on how "tight" you secured your database, there are a couple of things you can try. The easiest is just to create a new Workgroup file, or attach to the default System MDW file. If you didn't lock down all of your objects, that might work. You can also try importing your objects into a new blank database. If this doesn't help, contact me via the TechHelp page and I'll try to assist you further.
Hi Richard, I played around with the security settings on my access database and now I locked myself out of my own database. I can access the database from my colleague’s computer (without being prompted logon information) but not from my own. Access prompts a logon message box on my computer but my password is being denied. Do you discuss security options in future tutorials and if not, will you please help me with this issue?
Joel, I'm not sure I understand your question. You want to click on a checkbox and change the value of a textbox? You can do that with an AfterUpdate event which I cover in Access 207 (as a macro) and Access 303 (as an Event Procedure).
Walter, yes... but make sure you type it in as two words: "Is Null" not "IsNull". The latter is a function, like IsNull(FirstName), whereas in a Query paramter, you would type in "Is Null". Confusing, I know.