Access Help Please!

[RB1618]

Hello, I am very new to access and am setting up a user friendly database.

I will try to outline the situation the best I can.

I need the following:


Step 1:On the Form: The user will enter the "ACPREX" and press the first button. When they press this button the "City" and "State" fields will populate the information from Table #1 into the fields on the form. This is so that the user can double check that they entered the proper info.

Step 2: The user will press the second (bottom) button and when they press this button the values in the "ACPREX", and "SMSMESSDOMAIN" fields will be transferred from Table #1 into every entry on Table #2. (All 1000 entries)

Step 3: This will be an option to export the data, but I am not concerned with this step until I get the other 2 done properly. (Forget about this step for now

)

I hope this clarifies.

(Also, Right now the buttons don't do work and the fields don't populate. That is my question: How do I make these work for what I said above?)

I also really appreciate the help. Thanks again.

Please see the pictures for more info: (FORM2.JPG has the instructions on it. This picture will make it very easy to understand what I am trying to do)

 

[Fuga]

Hi,

Judging from the first sentence in your question, I gather that you have only just now started using access or creating databases. I appologize if this is not so.

However, I think in general that you should check out these topics:

Relations, parameter query (update query) and vba programming (referencing to fields on forms etc).

The relations is so that you store your data properly. It seems to me that you have som unnecessary data in your table, which will have impact on both performance and your ability to do what you want.

A parameter query is used so that you display some data, depending on user input for instance.

The VBA-programming is very useful when it comes to perform predefined operations that you don´t want the user to concern themselves about. You can do a lot of cool stuff with this.

Now, here´s what I would do, for starters (provided I understood the question):

Base your form on a parameter query, where the parameter is the "ACPREX" value that the user puts in. This means the form will display only those rows where the "ACPREX" is the same as the users input. If you have a lot of rows with the same "ACPREX" then you will probably need to be able to chose from some sort of list, and that´s a different story. Also I´m not sure you should have more then one of the same "ACPREX".

After this, you use an update query to fill in table 2.

Hopefully this will get you started, but like I said I think you need to take a look at you data structure.

Fuga.

 

[RB1618]

Thank you for the help, I really appreciate it!

Yes I am brand new to access. I have used lotus approach before, but it is very different in its own ways.

Thanks for the tips. I will try to play around with them.

Every record has a different ACPREX code, so that won't be a problem.

I wil let you know if I have any success.

 

[RB1618]

Fuga, I have been playing around with what you told me, but I cant seem to get it right.

If you get a chance would you mind showing me an example? Maybe you could create a very small database with 2 tables and a working parameter query and update query.

Thanks for your help.

 

[RB1618]

Wusup Fuga? I know the girls in Sweden are the finest in the world, but if you can break away from them for minute would you mind helping me?

I would appreciate it.