• Access 2003 changing the company name

    I am working in a 2003 access db that was set up by someone else. the Company name has changed. How do I change the company name so it prints out correctly on our work orders?

    bathgenie5 pointsBadges:
  • Access reports dropping data included in query

    My primary key for my database is based on phone numbers. I have created a query which includes anyone that has an outstanding balance. The query includes last names that are the same which I see. I have 3 people with the last name of Thomas, all have different first names. I created a report from...

    osbornisle5940 pointsBadges:
  • Anyone familiar with 4D front end to DB2 database

    Has anyone had experience with using 4D (4th Dimension) as a front end of IBM DB2 on iSeries? I've tried FTPing a database, it was downloaded to a PC into Excel, Excel had no problem retaining formatting...however I can't get DB2 to maintain the formatting and I used DDS to to generate the physical...

    Gmil494365 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:
  • CPYF

    Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan't any data to be copied from LF1 to PF2 (dont want to use clrpfm after copying data) Is there...

    anuppdas105 pointsBadges:
  • Deleting a Table

    I have full permissions to a DB, but I can not delete a table.

    dshafer15 pointsBadges:
  • Modify Hexadecimal Flat File in AS/400

    Hi, I am working on a project, but have got stuck and I need expert advice. I received a flat file from another system (probably a Windows system) in AS/400. The flat file contains the data separated with hexadecimal (x'05') . The file I am receiving is through connect direct. My requirement is to...

    As400t10 pointsBadges:
  • Security

    Can someone tell me how you handle user security since it is no longer available in Access 2007 or 2012. I have a database that I need to pick and choose who can edit certain forms.

    bgharrod5 pointsBadges:
  • Access Find the previous checkout record and add a return time

    I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID record...

    TeaBone5 pointsBadges:
  • Database trends

    I am researching the following topic and need to find relevant articles. Database trends and their impacts on commerce.

    jms8420215 pointsBadges:
  • Alternative name of Physical file

    How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.

    anuppdas105 pointsBadges:
  • Formatting Cells individually in a Table – Microsoft Access

    I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?

    azuby2420 pointsBadges:
  • Basic O & M activities for any database server

    What are the basic O & M activities for any database server

    anshu4020 pointsBadges:
  • Difference between EAI middleware and TIBCO middleware

    Plesae explain difference between EAI middleware and TIBCO middleware.Which will be better useful for integration between two ORACLE database

    anshu4020 pointsBadges:
  • Are there any Pl/Sql like features in j2me?

    I want to deveplope a mobile game in which i want to use database and all its features which is possible in pc through oracle and sql...is there any way to use them in j2me? Is rms an answer? Can i use java db.?

    hussain22juzer530 pointsBadges:
  • SQL Server TempDB

    How do I clear data from TempDB?

    wertq5 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:
  • Access 2003 Query

    I have a table (tblRents)with the following fields: RentID, LeaseID, StartDate, EndDate, RentalRate, TenantID and LessorID. For each lease entered, there could be several rent rates, each entered seperately with it's own RentID. I am trying to write a query that will give me each rent rate for the...

    kgonzales20 pointsBadges:
  • Date format in table

    I record dates of birth and death from headstones. Often I only know the year, or sometimes the month and year. How can a create a table field to accept the info I have and not require a full date (month, day, year). I also would like to have a DateDiff field that will show the age at death from...

    LostSpring5 pointsBadges:
  • Microsoft Access change

    I'm trying to add fields to a table that says it is read-only. I don't want that,  how do I turn it off?

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

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

Following