• MS Access 2007, IIF and Null expressions

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. I believe that I should be using...

    Phil12550120 pointsBadges:
  • Loading CSV files into Oracle tables

    I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then use...

    Gaugelc0 pointsBadges:
  • SQL query – Unique item with latest date of entry

    Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three...

    SmurkyIS15 pointsBadges:
  • SharePoint 2010 Capabilities

    Using SharePoint 2010 can I create a page with a template of fields that users can fill out (system change requests) and submit generating an email to a dist list? I also want the page to store the request information, so those can check back on status of their system request changes. I have read...

    SarahBeth5 pointsBadges:
  • How to merge all MDB files

    I have more than 100 Access 2003 .MDB files and all the files have same structures and tables. I want to merge all to one MDB file.

    ssddssdd12310 pointsBadges:
  • Best way to set up longitudinal database

    Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester - but on a larger scale - who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and...

    admstr5 pointsBadges:
  • Updates in Access

    Can multiple users make updates in Access simultaneously?

    prakshabpatel5 pointsBadges:
  • Finding a specific record with user input

    I am very new to Access, but have used Approach in the past. When I used Approach, I could create a find in a form, user would be able to enter the find criteria in the blank field. I can not figure out how to do that in Access. Help!

    5boznme10 pointsBadges:
  • AS/400 pass through query from Microsoft Access

    I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN...

    lionbank5 pointsBadges:
  • Questionnaires List

    I managed to received on MDB files that contains various examination questionnaires. I believe that its possible to take and retrieve answers inside from the file itself. Can someone tell me how?

    themondcyte5 pointsBadges:
  • TIME String using Variable H (0 to 23) & M (0 to 59)

    Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO "IBNserv"."ChkMe"("Clt")>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST('12:14:00' AS TIME) STATUS INSERT INTO...

    Apcalogic50 pointsBadges:
  • If logical function in MS Access

    I have to use IF logical function in MS Access.

    administrat15 pointsBadges:
  • Table setup

    I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date - Quote # - Customer - Cust Quote # - Part # - Part Name - Quote Due Date - Qty - Lead Time - Price...

    ValleyGirl10 pointsBadges:
  • Cannot find tables

    I am working with a ms access file. When I look at the objects in the access objects window using a category of "object type" I only see one table, when I use the category "Tables and views" I see three tables, these extra two tables are in the dropdown list if you try to create a new relationship....

    Chucky6665 pointsBadges:
  • editing in grid forms

    How do I add,edit,delete in gridforms with Microsoft Access?

    vidyam5 pointsBadges:
  • ms acess trouble

    i am having trouble with my vb programs. I have several vb programs that make data reports from access datatables. All of a sudden my datareports will not update until i close my program and reopen it. Any help would be greatly appreciated.

    Dmattin25 pointsBadges:
  • unrecognized data base format

    hi, i had an application written with visual basic 6.0 with ms access data base (dao connection). it was installed on server using ms windows 2000 advanced server.i have two users,one of them uses windows 2000 & ms office 2000,the second uses windows xp & ms office xp. some times when the users...

    Micus20050 pointsBadges:
  • AS/400 Profile getting disabled by MS Access

    We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400's in to MS Access. The other...

    Kdh05045 pointsBadges:
  • Printing the contents property of an EXCEL file

    I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access. I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?

    SharieL10 pointsBadges:
  • Vista and Office 2007

    We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.

    maryann465 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following