Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Neak1

  1. Neak1

    Reports In Access How do I use VBA

    Hello Everyone, I have an Access Report with 3 fields Name,Code,and Amount fields. I need to generate totals at the end of the report if some conditions are met. For example: if the code field is equal to A then sum all the amounts in the amount field and display the totals at the end of the...
  2. Neak1

    Finding Records

    Hello Everyone, I have two forms within Access. I have a combo boxes on both forms which lists SSN's. What I want to be able to do is when I select an SSN from the first form once I have saved that record I have a command button which opens the second form when I open the second form I have...
  3. Neak1

    Extracting Data 2

    Hey Everyone, I have a field called Name. In this field there is First Name, Last Name and middle initial. The field is 22 characters long. Each Portion of this field is separated by a blank space. Ex: Mary K Jones or Micheal J Jordan Jr What I need to do is extract the First Name only...
  4. Neak1

    Production

    Hello Everyone, Has anyone ever worked with an Access Database which had more that 12,000 records, if so how did it perform. I am trying to decide what type of Database to use to have a more efficient database as far as production is concerned. There are many users that will be accessing the...
  5. Neak1

    Security

    Hello Members, I have designed a database in Access 97 now I want to secure it. The only problem that I am having is that I don't want to have to enter in the hundreds of users and ID's because the database is to short on a LAN. Is there a way that I can hide the database window from the...
  6. Neak1

    7 Control Situations

    Here is the situation, I have 7 controls on this form. I am trying to find out what type of syntax to use in order to do the following. The first controls label asks the question. Is there a payment discrepancy? "Y" or "N" (are the two options for this 1 position...
  7. Neak1

    Syntax for OR controls

    Here is the situation, I have 7 controls as stated above. I am trying to find out what type of syntax to use in order to do the following. The first control asks the question. Is there a payment discrepancy? "Y" or "N" (are the two options for this 1 position control)...
  8. Neak1

    Syntax for OR controls

    Hello Everyone, I have a form wil 7 control 3 of which must be coded at all times. Example: The first control is a yes/no box. If the answer to the question is yes, then controls 1&2 must be coded or 3&4 must be coded or 5&6 must be coded. I have tried using or between each group of...
  9. Neak1

    EXTRACT DATA FROM FIELDS

    I HAVE A FIELD CALLED ADDRESS. THIS ADDRESS FIELD HAS CITY, STATE AND ZIP. THIS FIELD IS SEPARATED BY SPACES. WHAT I NEED TO DO IS EXTRACT THE STATE WHICH IS IN THE MIDDLE OF THE FIELD. IT IS A 2 POSITION STATE CODE. PLEASE HELP!!!!
  10. Neak1

    Underlying Table Problems

    Hey Experts, I have a form which has about 30 fields. This form has some data that was downloaded from the mainframe. It is the users job to enter more data to complete these records. I wanted to know how do I make it so that users can only access one record at a time. Before they can move...
  11. Neak1

    Duplicate Values in A Query

    I am trying to stop duplicates in a query. I have two tables. Both of them have an address which is the same. I have the relationship things going on with the lines from one table to another connecting the address fields. When I look at it in datasheet view it gives me so many duplicate...
  12. Neak1

    Valiation of Form Data

    I have a form the contains about 30 fields. Some of these fields are required at all times, and the others are required under some kind of condition. What I do know is that you can control this in some way by using the validation rule which is listed on the properties window of every field...
See more

Part and Inventory Search

Back
Top