Recent content by Capo

  1. C

    Outlook "Task" Functionality in an Access DB

    I want to incorporate an Outlook like "task" function in a DB I am creating. Essentially, I want to enable users to be able to create tasks with due dates where they can check on a due-dates and progress of each task when needed. Additionally, I want to enable the functionality where the users...
  2. C

    Adding Fields in a Make Table Query

    If I have a make table query where I want to add in some blank fields, say: Field1: “” , Field2: “”, etc…. is there a way I can make these fields a yes/no type instead of the default text? I know I can manually go into the table in design view after I run the query, but I was hoping I could do...
  3. C

    PL/SQL with Non-Oracle Databases?

    I have the sybase DBs as valid data sources in windows and they work fine with Access... I suppose I need to see if I can find a way to get PLSQL to recognize these.
  4. C

    PL/SQL with Non-Oracle Databases?

    I am still a bit new to PLSQL, so any help would be appreciated. I have all of my ODBC connections setup under my windows data sources... I am seeing my oracle databases in that list but I am not seeing my sybase ones. How do I get those to showup so that I can query them via standard SQL? I...
  5. C

    PL/SQL with Non-Oracle Databases?

    I know PL/SQL is an oracle tool, but can you use it to query non-oracle databases (such as sybase)? I know it has the ODBC importer, but I'm referencing connecting to the DB and working in the SQL window as you do with oracle databases. Anyone know? Thanks!
  6. C

    Help with Resource Materials

    /bump Anyone?
  7. C

    Help with Resource Materials

    Hey everyone, I am looking for some effective resource materials (books) for the following topics and/or applications: SQL VBA PL/SQL SQL Server 2005 Thanks for any suggestions!
  8. C

    Using Access Objects vs. Pure VBA Code

    If you all don’t mind, I’d like to touch a bit more on the performance issues. Let’s say we have a form that auto-populates several fields by pulling data from an ODBC connection. Now, which route would be more beneficial? 1) Having the table linked in via Access, building a query in access and...
  9. C

    Using Access Objects vs. Pure VBA Code

    Good points, thank you for sharing. I'm curious to hear other viewpoints and/or additions, if there are any. Thanks!
  10. C

    Using Access Objects vs. Pure VBA Code

    I am wondering what you all think about designing front end applications via Access and whether one should use Access objects or simply hard-code everything via VBA in forms. Essentially, what I'm asking is whether one of the two following routes have a preference, and why. Route 1 would be...
  11. C

    Windows Installer Issue

    Hello there, I use access 2000 but also have access 2003 installed on my computer. Access 2000 is my default version and is usually what I use 90% of the time (for various reasons). Anyways, every time I launch 2000 (without going into 20003 at all) it ALWAYS brings up windows installer. Is...
  12. C

    "Select all that apply" Check Boxes

    /bump Anyone?
  13. C

    select mutliple items in a combo box

    I have a thread asking the same question here: http://www.access-programmers.co.uk/forums/showthread.php?t=131983 You can see the discussion, so far.
  14. C

    "Select all that apply" Check Boxes

    Just a follow-up here. I have created a child table to populate my options for my question. I changed the question type to a list box and am getting the answers to populate correctly in the list box. I assume I also need to change the Multi-Select option under properties? If so, do I go with...
  15. C

    "Select all that apply" Check Boxes

    Yes, basically the point is to allow a user to select multiple options as apposed to just ONE option. But you're saying that the best way to do this is to create a seperate field for each possible answer? Such as, if it's question 18, do q18A, q18B, a18C, etc?
Back
Top Bottom