Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by belovedcej

  1. belovedcej

    problem referencing aliased field/table names

    thank you so much! perfect. and it fixed ALL my errors in the larger query.
  2. belovedcej

    problem referencing aliased field/table names

    Thanks for the explanation and tips. It turns out I just missed the apostrophe when I copied from SQLPlus, so that part was ok. But I changed everything else. But now I'm getting a different error on line 3: ORA-00923: FROM keyword not found where expected I've run stuff like this on...
  3. belovedcej

    problem referencing aliased field/table names

    I'm having difficulty with the below query (actually just a portion of a much large one - thus the structure.) I am told "invalid identifier" at line 2, allV.AllVoters. However, if I swap the fields, I get the error at line 2 again, this time on allV.AllDate. Any ideas what is wrong? SELECT...
  4. belovedcej

    Problems with this query

    good research Melagon. I'm going to make a note of that, because it looks useful and I didn't know it existed till you brought it up.
  5. belovedcej

    Problems with this query

    true enough IIF would work. I just don't like all those nasty nested expressions! Makes me dizzy. LOL I wonder, too - would there be any place that these values would be used? Because if so, a table with the categories and values might be better whether SQL or Access, because who would want...
  6. belovedcej

    Pie Charts in Reports?

    Well, you can do pie charts in access. Check out the wizard under reports, "New/Chart". However, I personally don't like them. They don't like as nice and tend to be hard to use when compared to Excel. For my users, I provide data that they can export into Excel and then make much nicer...
  7. belovedcej

    Problems with this query

    Correct, Access does not support a case statement. The cleanest "Access" way of doing this would be to have a table containing the possible categories and their values, and then do a sum of the values, grouping by employeeID.
  8. belovedcej

    Improved stability Access FE/SQL backend

    I may be wrong about this - but I think I remember the NZ function being a "if the field is null, provide value1, otherwise, provide value2." If my memory is correct, SQL DOES accomplish the same purpose - it just needs to be rewritten as the following: Case When myfield is null then value1...
  9. belovedcej

    Adding Attachments to forms

    What I do is provide a table that contains a field of hyperlinks. Then the user can copy and paste the Windows address of the file or folder into the field in the database, and it's linked. Prevents you from having to store the file itself and bloating your table, and accomplishes the same thing.
  10. belovedcej

    Improved stability Access FE/SQL backend

    Have them give you your own database that you have db ownership have. Then have them give you whatever level of permissions is appropriate for those few additional tables. They should be comfortable doing this, because in SQL security settings are pretty straightforward. They can give even...
  11. belovedcej

    Improved stability Access FE/SQL backend

    For that number of people, moving to SQL is a better option. The problem is that with locking/unlocking records and other database issues, Access can end up corrupting the data if things aren't done just right. SQLServer handles all that much better and you won't have a data corruption...
  12. belovedcej

    Soft touch buttons

    open your database and go to tools/options. Choose the tab for forms/reports. At the buttom there is an option for "use windows themed controls". Check that, and your buttons should be rounded.
  13. belovedcej

    Converting Query from .mdb to .adp

    On the other hand, if you want to execute the query and then do something with the data using a recordset object in vba, you have the following options: TYPE 1 Dim rst As New ADODB.Recordset Dim cmd As New AdoDB.Command Dim parameter1 as string Dim parameter2 as string parameter 1 =...
  14. belovedcej

    Converting Query from .mdb to .adp

    There are a couple of ways of doing it. Perhaps the easiest is if you are opening a form or report based off of this query, open the properties dialog of the form or report, and under the data tab, put the following in the input parameter row. @myParameter = [Forms]![frm_1]![txtBox]
  15. belovedcej

    Record Bottom Line of Report

    thanks for the clarification, genoman. I thought i remembered something about the report events! :)
See more

Part and Inventory Search

Back
Top