Search results for query: *

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...

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...

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...

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...

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...

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...

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)...

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...

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!!!!

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...

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...

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...