• printed out in Access to populate the box

    I want to have a field where the date the form was printed out populte that box in Access 2007. How do I set this up?

    Rlbanks25 pointsBadges:
  • Simple SQL server question?

    I want to do something that WAS easy in my former world (a dBase environment) but I can't figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone's help. This is what I want to do, in order: 1) Select the top # records of a table, "#" is a field in another table....

    Jtischler5 pointsBadges:
  • Data Entry in Microsoft Access using ASP

    Data from the form not able to add into the database although using Internet sample source code.

    Mr.Poor In IT10 pointsBadges:
  • Using Microsoft Access to create reports from MACOLA

    Where can I get instructions on using Microsoft Access to create reports from Macola?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Delete duplicate values in Microsoft Access

    there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.

    Kimidiramana30 pointsBadges:
  • subform

    I have one table and a main form and a subform. All fields for these form are in this table. The subform is called from the main form via a command button. When I go to the main form and go to, say record 3, it displays the correct data, but when I use the command button to open the subform the...

    Donb5225 pointsBadges:
  • Database Access 2007

    Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can't any hint? When I go into my design mode those new fields do not apper?

    Ld23315 pointsBadges:
  • Access Form Question

    Hi, I've studied Access for a couple years and can't seem to wrap my brain around the following: if a form and subform that has fields from multiple joined tables, how do you link the form with the subform so that the subform references the right record? I know the primary key of the parent table...

    Dataempress115 pointsBadges:
  • Application.FileSearch no longer exists (in 2007)

    My company is migrating to Office 2007 - I have VBA code that works wonderfully in "older" versions of Access, but will not work in 2007. One in particular is "Application.FileSearch" - what can I use instead? (And why was it removed??)

    Dhoosier5 pointsBadges:
  • Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event

    Hi, I’m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I've come against a business rule I can't even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we're hosting. One...

    Dataempress115 pointsBadges:
  • Pop-up reminders in Microsoft Access

    How to create popup reminder in Microsoft Access?i do not know to create with macro.can give me the answer step by step?

    Wanie5 pointsBadges:
  • Format a field

    I need to format a text box to begin with a zero with no decimals (i.e. 0310) If I type in 0310, it appears as 310.

    Sue775 pointsBadges:
  • Windows Sharepoint Servs 3.0 – Linking existing Access 2007 Database with new list.

    Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to...

    Domc1115 pointsBadges:
  • Subject: Limiting information in combobox

    I have two comboboxes, one shows a list of customers, the other shows a list of contracts. One customer can have mutliple contracts, but a contract can only have one customer. I want to limit the contracts in the second combobox to only the contracts of the customer in the first combobox. I have...

    Gavaughn10 pointsBadges:
  • ActiveX control for Webcam

    I'm creating an application with a webcam to get a snapshot data image, i want to use MS Access for database and use Crystal Report 10 for the print out. My friend told me if i want to use the cam then i hav to use the activeX control, can u help me, please..

    Abekane5 pointsBadges:
  • Formatting a subform for printing in access 2000

    I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the subform. I Don't want the name of...

    TRYINGTOLEARNACCESS30 pointsBadges:
  • Allow Additions Property on Subform In Form View in Access 2000

    I have a main form and a subform in access 2000. I have set both the properties to NOT Allow Edits, Or Deletions, but Yes to allow additions. However, when I open the form in form view the property for allow additions changes back to no. I am able to go back and change the property in form view and...

    TRYINGTOLEARNACCESS30 pointsBadges:
  • 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:

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