• Access Form Printing Problem

    I have designed a set of forms in Access.  One of the forms prints the form in total.  However tow of the forms will only print the header and footer and does not print the data input portion of the form.  What am I missiong in regards to why I can't get these two forms to print in total? Thanks

    Ranfoster5 pointsBadges:
  • MS Access – Create Median Aggregate Function

    Is it possible (and has anyone done it yet) to create additional aggregate functions in MS Access (I'm using 2007)? In particular, I want to create "Group By" queries that calculate the Median of each group. I have a median function that works on entire columns (or subsets) individually, but it...

    Cantrell10 pointsBadges:
  • VB

    Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form's Combo -- when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 Combo --- so when...

    AnandaDebnath280 pointsBadges:
  • Master/Child Link problem in Subform

    Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the foreign key in the...

    Dataempress115 pointsBadges:
  • Error 2282 in Microsoft Access

    Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...

    Pmallick5 pointsBadges:
  • Access for Windows 5.4

    On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine.

    plaporte55 pointsBadges:
  • How do I set decimal places with VB Access

    I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...

    Reject5 pointsBadges:
  • Date problem with Delphi 7

    I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ;  qrydate.Active := false ;  qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...

    Marieps5 pointsBadges:
  • Write Recordset to MSAccess(mdb) using VB6.0

    How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance.

    Nikhildhar35 pointsBadges:
  • Microsoft Access table dropped primary key and index

    I am using MS Access 2007 on Windows XP Professional. The main table in my Purchase Ordersdatabase has dropped its primary key and index (no duplicates). Previously, it worked without any problems, and caught duplicate values. Now, when I try to reset the primary key, I get the message, "The...

    Swd14420 pointsBadges:
  • Capture SQL Server logged in db User name in Access 2007 Accdb

    I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

    Ppeterso15 pointsBadges:
  • Why won’t my Access subform stay put?

    Hi, I have a main form with a subform below it. The subform supposed to be invisible and 5" from the top. When I click a button, it becomes visible and 0" from the top. When I double click the button, the subform is supposed to go back to being invisible and 5" from the top. For some reason,...

    Dataempress115 pointsBadges:
  • Access Query – Repeating fields

    I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate 'Y' else 'N'. Any ideas on how to create a query to do this

    Dash145 pointsBadges:
  • Modify MS Access using iSeries RPGLE

    I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?

    wkozerski20 pointsBadges:
  • Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files

    Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...

    CompEng1,185 pointsBadges:
  • ACCESS 2007 and SQL Server 2005 Schema Updates

    We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP - that is, as reports are added,...

    NHSNick30 pointsBadges:
  • Excel to Access conversion

    Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

    KSoniat610 pointsBadges:
  • AS400 File to MS Access by SQL Passthrough Query

    I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...

    CompEng1,185 pointsBadges:
  • Form vs. table record order

    Why doesn't the record order for an MS Access form match the record order of the table (form keeps re-ordering the records)?

    Mcoopers75 pointsBadges:
  • Meeting Invitation not updated in Calendar

    I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for any...

    Subbu2k990 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