• Extra Page Printing

    When I print a form I select a record but it gives me an extra page with part of the header printed with it.

    Phagerman45 pointsBadges:
  • New member contest: ASK, Answer and Win a $50 Amazon gift card

    As 2008 winds to a close, IT Knowledge Exchange has one more fun contest to end the year. From today until December 23rd, you can enter to win one of ten $50 (US) Amazon.com gift cards. There are two things, however, that you must do in order to enter: 1. Ask 2 questions 2. Answer 2 questions...

    ITKE352,415 pointsBadges:
  • how to recover database if it is deleted

    How can I recover the database if it is deleted?

    03765 pointsBadges:
  • How to combine 2 linked Excel tables in access 2003 with same field names, using query?

    I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create one master table. Here is the...

    Accesstables5 pointsBadges:
  • Storing HTML in a Physical File

    Hello everyone, I'm looking for ideas for the best practice of storing HTML in a Physical File (PF). - A huge character field with VARLEN? - Some other data type available in DDS? Can't describe the PF with SQL (I'd like to, but need to use DDS). Thanks in advance! Dave

    Dcantwell470 pointsBadges:
  • Microsoft Access 2010 DB Macro that allows a count of a date filter, and an email to be sent

    Hello, I was wondering if, within Outlook 2010, is it possible to have a script run that runs the date filter command within Access,displaying the weekly total number of values logged within the Access database. Once it pulls that value, I then would like it to send an email saying the count to a...

    Chris311fan5 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:
  • Soon you can redeem knowledge points for Amazon.com gift cards

    Yes we are coming up knowledge points and will be announcing the ability to redeem all the points you have earned thru december this year for amazon.com gift cards. Next week we will be sending out an email with all the details but it should be fun to see who ends up asking and answering to beef up...

    ITKE352,415 pointsBadges:
  • Embedded SQL Update Query

    Suppose I have a file with empid and telephone number, I realised the telephone number value is not correct for some 3-4 employee ids. I have a backup file for this file and it has the correct telephone number value . I need to write an SQL querry to correct the wrong telephone number by making use...

    RamvishakRamesh2,505 pointsBadges:
  • DB2/400 basics

    How will I find out total number of records in a DB file without causing any I/O operation?  Also How will I detect the existence of a record in a DB file without causing any I/O operation?  I think I can use INFDS and the field *RECORD but not sure how this works. Thanks, Nutan

    Nutangujar895 pointsBadges:
  • Delete query in Embedded SQL

    I have a delete query in embedded SQL. How can I know how many records are deleted?

    RamvishakRamesh2,505 pointsBadges:
  • Email Validation Software

    We do a lot of bulk email blasts to our Students, in which we get a high percentage of bounced emails. We are looking into purchasing an Email Validation package and was wondering if anyone can recommend a decent package that would either run on the i5 (AS/400) or that can interface (via ODBC,...

    I5NEPA0 pointsBadges:
  • V6R1 restore Opt 21 to replacement box

    I have a complete Opt 21 save tape from my current 520 running V6R1. I have the following license pgms installed...Performance tools, DB2 query & SQL Dev kit, WDS, Client access. We found another 520 box(hardware upgraded), it has been wiped clean , no OS. Can I use our opt 21 tape and restore it...

    Svocal200940 pointsBadges:
  • Microsoft Access 2007 – Code for connecting two related forms, bringing up same record?

    :sigh: My database suddenly requires me to have my forms appear as read-only's (since my employees are too stupid to NOT going flailing around, typing madly for no reason). However, we still need to be able to edit the information. I've created a second form, mirroring the original, to be my edit...

    Abaumeister25 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:
  • Access 2007 type mismatch

    Why is Access 2007 macro getting type mismatch error message for a simple macro to pop-up a message box when a form field is left blank upon exiting the field?

    Floridaboy5 pointsBadges:
  • How to add a text box within a option group on a form?

    I need help trying to add a text box to my option group on Access 2010. Within my option group I have it listed: Materials Labor Heat Rate Other: (text box) Or at least thats how I want it, but as I input the information to the "other" text box, it shows up on ALL the forms. I guess my question is,...

    Amroberts120 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