• Locking Forms in Access 2000

    I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going through and...

    TRYINGTOLEARNACCESS30 pointsBadges:
  • Combining fields to create a unique ID in Microsoft Access

    I have been working on a database for my research job.For our research purposes we are trying to create a unique identifier that tells us 4 things: 1) what study they are a part of, [this will be “QQQ” for EVERYONE] 2) what group they are in, [this will be a four digit number, such as 2222] 3)...

    FSUResA15 pointsBadges:
  • Access 2003 using IIf statement on a form

    I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for 'current grade' and a field for 'target grade'. I also have a field 'progress' in which I am using an 'IIf statement' to compare the two fields (to show either 'under...

    Malcplant35 pointsBadges:
  • New Access user!

    I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there's about 12 -15 copies. ( Example: mdb12 ) Is there a...

    Tami8550 pointsBadges:
  • MS Access 2007 Author credit

    I'm designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?

    Lwbadgr5 pointsBadges:
  • Microsoft Access Drop Down List

    Hi, I have combo boxes in Microsoft Access where if the user starts typing the drop down list expands. Now if they use the keyboard to select the item, Access moves to the next control and the list is brought back up, but if they use the mouse then the list stays down. I was wondering if there was...

    RoadDust390 pointsBadges:
  • access 03 sending emails

    I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can't get it to work. Please help

    Bent4lf5 pointsBadges:
  • Word and Excel

    In MS Access you can create a form so when its all filled out the data is automatically put into an Excel spreadsheet under the correct headlines. Is this possible to do this with a form made in word?

    AerospacePJ5 pointsBadges:
  • Viewing the guts of a Microsoft Access form, query and report, programmatically

    I have over 1000 MDB's which need to be checked to make sure they don't reference any external sources. So, I'm searching for 'A:', 'B:'... 'Z:', '\', etc. I need to search the guts of each form, query definitions, and reports to find any references to something external. The data is done. Is there...

    DMoseley5 pointsBadges:
  • Microsoft Access linking

    Hi, I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key). I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form. I would like to be able to open...

    Donb5225 pointsBadges:
  • Can I link items between Outlook, Word, Excel, and Access, through the Calender view?

    Can links be set in Outlook Calender '07 to docs in Word, Excel, Access? I want to be able to go to a set date and access from that view all items pertinent without having to go looking for each item separately. Is possible?

    Notumbo15 pointsBadges:
  • How can I print all picture attachmens attached to a record on an access report

    I have a number of records that each have multiple attachments (pictures)> I have created a report and only the 1st attachment of each record prints on the report. Is the a way to have all the attachments print on the report for each record?

    FBDave5 pointsBadges:
  • Microsoft Access AutoNumber

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to be of 8...

    Ansh12320 pointsBadges:
  • Resizing Microsoft Access 2003 properties form

    I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling...

    JNewmarch5 pointsBadges:
  • How can I select unique records from Access based on two criteria

    I need to do the following: SQL = "select amount, count(amount) from table1 group by amount having count(*) =1" This returns all unique records, but I need to add another criteria to that statement ie: I need to select all unique records only if a second value is met as well! This is what I had in...

    Grantp40 pointsBadges:
  • Sending more then 1 Access Report to Outlook

    Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie

    JulieSandra15 pointsBadges:
  • Update database when combo box value is changed

    Hello, I am wondering how to update all the text fields, other combo boxes, and memo's when values are change in a combo box in MS Access 2003. For example, I have a form that when values are change of a combo box that has dates for every quarter. I want the values that I have set for the other...

    ProgrammingGal30 pointsBadges:
  • Temporary recordset in MS Access VBA

    Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don't need to make...

    Darryn765 pointsBadges:
  • Problems with VAL function

    I have a table with an NVarChar field that contains left aligned numeric values. I've tried using the VAL function to return the integer values, but I'm getting back Short Date results. What can I do to get integer results? Thanks, Arlin

    Arlin70 pointsBadges:
  • Combo search box – “Invalid Outside Proceedure”

    ..and before you ask, no I don't use anything linked into Access 2007 to program my database. So, I've been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my "search box" gets this error in my normal form. HELP!

    Abaumeister25 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