• How do I count specific numbers in an Access 2003 database table?

    I have over 6700 numbers in one field. No other fields in database. I want to find out how many times there is a number 1, 2, 3, 4, etc. in this list of possible numbers. I am not proficient in Access like you all are and am lost on creating a report with the results of this data. I appreciate any...

    Cgarbeads5 pointsBadges:
  • Can an Access 2003 query exclude the results from a previous query?

    I have a database with 2 tables: one with name/address info, and another with info on yearly donations to our organization. The 2 tables are linked through an ID number. I have set up a query that will give me name/address info for those who donated in 2010 (where the year field is 2010 and the...

    Susan3955 pointsBadges:
  • Old Recovering Access database password

    A client of mine worked on a database 5 years ago for a research project, but she had to quit for a while for cancer treatments. She's now responded well enough to go back to the project but her database, done probably in Access 2003 (perhaps even an earlier version, but certainly not a later one)...

    KyleFreeman130 pointsBadges:
  • How do I copy an Access 2003 database and table?

    I'm using Microsoft Access 2003. How do I copy a database and table? They were set up by someone that's no longer with the company.

    Secretary15 pointsBadges:
  • Access Report Headers

    I have a problem trying to display a report header at the correct time on a report I am building in Access (2003). Lets pretend I have a report with 3 levels (cuz I do!!!):  Proposal, Supplier and Parts.  The report is for the Proposal.  It is grouped by Supplier and then has a subreport for the...

    Clangingsymbol5 pointsBadges:
  • Converting text to number for calculation in Access 2003

    I have a field that stores time taken as text i.e. 5 mins, 10 mins,15 mins, half hour - for various kinds of activities. I need to do a report that calculates the total time taken for each activity - which means converting to number somewhere along the line. Any ideas?

    BedfordSurfer25 pointsBadges:
  • Combo Box Selection Locks Form

    I have a combo box that locks/corrupts all of the controls on a Access 2003 form.  The locking symptom only seems to occur when the list index is greater than 0. The problem control may not be the combo box.  It may be one of two list boxes that are affected by the combo box's 'after update'...

    McNitro255 pointsBadges:
  • Access 2003 – command button to show query in pivot format

    I have a form with a comman button.  I want the user to be brought to a query when they press the button.  The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead.  What am I doing wrong?

    Smbecker5 pointsBadges:
  • Basic Access Database query question

    I have an "Early voter list" table that I queried for matches against a "Dem Voters" table with the results generating a new "Identified Early Dems" table.   I would now like to query the "Identified Early Dems" table against the original "Early voter" table and be left with a table of "Early...

    Sharx2th5 pointsBadges:
  • Display External File Properties in Excel

    I have an MS Access database that uses two tables (tblOrders1 and tblOrders2) that are linked to two MS Excel spreadsheet files (Orders1.xls and Orders2.xls). The Excel spreadsheet files are occasionally updated by being replaced with new files with the same file names. I want to continuously...

    OdeMitch35 pointsBadges:
  • Client Loves User-Level Security, But Needs Access 2007

    Hey Guys, I have a Client for whom I have remodeled an access database. The database was initially created in Access 2003, and has been updated in 2007, though it is still in .mdb format. I showed the client a few simple user-level security options, and they worked like a charm. The only problem is...

    Washkuhnw90 pointsBadges:
  • How to use the data from other table into the main table in Access 2003 and 2007

    I'm trying to use data from other tables to make a sum and then display the result in a "Total" text. For example: I have in table1 3 qty's, in table2 2 qty's and in table3 5 qty's. I want to sum all those qty's and display them into the Main Form. I use MS Access 03 and 07

    Eddy20 pointsBadges:
  • Data Changing when closing an Access 2003 form

    I have a form in Acess2003 with a subform, the subform is linked on two fields, name and date. If I close the form when my master form is on the first name in the combox everything works fine - If I close the form not on the first name in the combo box, then whatever name it is on gets the date of...

    Nainey455 pointsBadges:
  • CONNECTION VB WITH ACCESS

    how to connect visual basic 6 and msaccess 2003 by using connection string

    Yusuphsngoroge5 pointsBadges:
  • Hide print page that is blank in Access 2003

    I have a report that from a query displays multiple fields. In some cases a second page hold additional data. How do I suppress the second page when the main data section is blank?

    Richpax5 pointsBadges:
  • Linking users of Access 2003 to SQL Server 2008 database

    We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

    Mike8005 pointsBadges:
  • In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?

    I have some data with a list of Product IDs and I want to assign the Product IDs a category name based the criteria below. <br><br> IIF Product ID = #*C#* then category name = Cable<br><br> IIF Product ID = 00#* or 497* then category name = Component<br><br>...

    As2301495 pointsBadges:
  • Linking Carrier and Products in Access 2003

    I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I want to only...

    Jasmine15 pointsBadges:
  • Direct synchronization in Access 2003

    The Direct synchronization in Access 2003 “Synchronize Now” has stopped working. The popup window named ‘Synchronize Database ‘program name”” does now display anymore. It seems to me that a switch of some type has become disabled, but I’m not sure.

    Rbknowledge201015 pointsBadges:
  • convert string to double in Access 2003

    Hi - I'm trying to convert a string into a double using this expression in Access Expression builder: Field1: CDbl(string) It's not working. does anyone know why? thanks...

    Contactesa5 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