Search results

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...

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...

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.

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...

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!

/bump Anyone?

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!

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...

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

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...

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...

/bump Anyone?

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.

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...

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?

How do you setup your tables to handle "select all that apply" questions in a survey? Must you have a field for each possible option and then flag it yes/no or is there a better way to do this? Thanks!

Can you elaborate on the difference between the two beyond just turning off warnings? Let's say I have a report which is generated through a 20 step query process, I've tested it, know it works, etc., why would I still need warnings on? Just trying to understand, still a newbie myself. :)

Just off the top of my head, you could always build your queries as you wish and then simply create a macro to run them automatically (make sure you turn off warnings, of course).

How are the tables setup? Do those tables have a primary key assigned to them?

Thanks for the help! But, I'm still a bit confused as to how to set this up. If you, or anyone else, can please assist, it would be appreciated! Here is a bit more info on how things are setup: I have two tables: tbl1 has a location ID number and some additional demographics. I have also...