• How to pick a source for a subform in Access 2003?

    I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A's plainid the DB the user is in. To check the DB-A's planid against DB-B' plainid then use the data to fill a sub-form. If...

    Techexpressinc10 pointsBadges:
  • How do I keep the original value of a field in Access 2010?

    Hello, I have an inventory with varying prices (which may change weekly).  I need to compare the current price with the original price. However, I only want the users to input one price value in a form.  I've tried to do this with a datamacro and the "old" command, but every time i update the...

    Vostro12315 pointsBadges:
  • Get the latest unique entries for user ID in Access database

    I have a database with a table that lists message entries. Each entry has an autonumber field ID, and a UID field that groups messages. My question is, how can I get the latest entry for each UID? Example Table: ID UID Message 1  1     Some Text 2  2     More Text 3  1     Message...

    Steveo2255 pointsBadges:
  • 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:
  • Copy Table in SQLPLUS

    How to copy a table from an access database using sqlplus

    VB and Access5 pointsBadges:
  • Access 2000 Database Entry Question

    When creating a table is there a way to set the first entry as a drop down menu and the associated entry as a currency entry on the same line? We are trying for an employee database that has several extra jobs that we would like in a drop down menu and then be able to associate the money that will...

    Mb732655 pointsBadges:
  • Showing or hiding fields in an Access report

    I have a db created for managing employee records. I would like to build a label report that shows or hides different fields on the label depending if a field has a value. The fields are Office, home address, city, state, and zip. If the member has an office location then i would like to hide the...

    USMCLew5 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:
  • Green Boxes in Access 2007 form after deleting O’s & 1′s from database

    I have a database tracking the information turned in on a hard copy form. If a patient triggers specific questions the data must be input: so if someone triggers the depression, I in their suicide rating, treatment plan, etc... I have the access form use check boxes but the data base use -1's. I...

    ARickert20 pointsBadges:
  • Create a Flat File from Access 2007 Database

    How do I create a flat file from a MS Access database. Also, there are some other requirements, (1) a numeric data field must have a "sign (+ or -)" in the first position and the data field must be "right justified" and (2) another numeric data field must be "zero filled" and right justified.

    Tljamison10 pointsBadges:
  • Creating Access table

    How do I create an ERDiagram from this table of information? Table=CUSTOMER- Customer_ID LastName FirstName Address PhoneNumber ContactNumber Email Address and add the following tables with this information: Table names: COSIGNEE -DRIVERS- PICKUPMANIFEST-DELIVERY_TRUCK_DETAILS-DELIVERY_MANIFEST

    CyberFly5 pointsBadges:
  • Visual Basic Email Script

    I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?

    Dragione5 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:
  • docmd.sendobject – “FROM” variable

    I am trying to get Access to send an email from an email address, "response folder", other than mine or anyone else who might be sending an email from the database.

    Rdd111115 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:
  • DB Table/Query Layout for Ranking System

    Hello, I'm building a Membership DB where Members can achieve certain ranks (Rank1 - Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them....

    Artificial15 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:
  • What is the code that links vb 6.0 to Ms Access and how to go about it?

    What is the code that links vb 6.0 to Ms Access and how to go about it?

    nyaga135 pointsBadges:
  • Access form to link to Google Maps

    I have like a form to put all the custome address I want like a bouttom to click then it opens a google maps with the customer address from the place I set prevoiusly for example A: My address (1901 Northwest Expressway Oklahoma City, OK 73118) B: customer Address which is from the Data base

    Agma1020 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