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

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!

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

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!

If have a table with billing occurances and one of the fields is "business name" how would I need to setup a make table query which lists unique occurances within that data? Essentially, I want to remove duplicates. If ABC Pet Store has 5 billing occurances and XYZ Pet Store has 1... I want...

I am working through a lot of data and this is basically what I'm trying to do. Let's say we have billed occurances for ABC Pet Store. What I need to do, is to see how many "billed lines" appear in the data. So if there are 3 billing occurances (let's say bill amount greater than zero) - in the...

I just had to pull a large amount of data from an off-site SQL server. Due to speed issues, I broke up the data into 3 pulls and exported the data as text. I have now imported the data into Access and wish to combine the three tables into one. All of the fields are the same, the only difference...

I am attempting to create an Access database that reflects a paper-survey. Basically, surveys were sent and have been returned and we now wish to enter the information into a DB for reporting purposes. The survey is all multiple choice, free-text, or a combination thereof (example being this...

Hello Everyone, Please let me say in advance that compared to many of you, I am an Access newbie, so pardon me if I miss some of what you're trying to say. :) Here is my situation: I have been tasked with creating a survey. However, many of the questions are if/then. Here is an example: "Do...

I am new to these forums and simply wanted to introduce myself. It seems as though a lot of information sharing goes on here, I certainly hope I can learn some as well as contribute! Good day!