• 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:
  • SQL Group by Query with aggregate function as well as detail information

    Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, ... I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the...

    idontknowthis20 pointsBadges:
  • access query criteria using LIKE operator and msgbox if no results

    I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*"......so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens a blank...

    draia10 pointsBadges:
  • editing in grid forms

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

    vidyam5 pointsBadges:
  • Report design Access 2010 / 2007

    I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. acct 120100 for $5, acct 120202...

    gc4evr5 pointsBadges:
  • Find a string in text file using MS Access

    I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences. Sample file: ------------ Patch 123456 : applied on Wed Jun 27 15:42:09 CEST 2009 Created on 23 Mar 2009, 00:48:16 hrs PST8PDT ... Patch 654321 : applied on Wed Jun 25 15:41:56...

    masrawi20105 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:
  • Access, Searchable Combo Box within a Form?

    Hello, I'm trying to create a combo list box in an access form that has all 12 months (January, February......etc,) listed and depending on the selection will bring up only that particular month within a range of dates. I don't want it to look at the day or the year, but only the month. Example: I...

    Accote15 pointsBadges:
  • VB6 retrieving MSAccess all records in VB6 ComboBox

    Im beginner to VB6 and I have project to buildup company Database, I will be so grateful if anybody could help me in that: "How can I get all records of any field of MSAccess database in ComboBox or ListBox of VB6

    ScorpionEyes45 pointsBadges:
  • Problems exporting Access table to XML file

    I am having a problem with exporting a table from Access as an XML file. I export the table and the XML file has the following at the beginning of the XML file: [!--l version="1.0" encoding="UTF-8"--]- [dataroot xmlns:od=""urn:schemas-microsoft-com:officedata""...

    Epk19635 pointsBadges:
  • create database using java

    How to create database (not table) using java? For example, I want to create database in MSAccess, MySQL, Oracle etc.

    Theremustbeananwer5 pointsBadges:
  • Access and sql server wide tables

    Does anyone know how to access sql server wide tables using Access

    Johnatsteeltorchdotcom5 pointsBadges:
  • VB 6.0 Database

    Hi guys, I have a question about vb 6.0 database. I used ms-access to connect the database with vb project. the component I used adodc. when I try to move the project to another computer the project will say misplacing the database it lost the pathe of the db. Is there anyone can help me without...

    Abbly15 pointsBadges:
  • Access datasheet

    Can I export a parts list from BPCS to an access database? 

    Erinsue5 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