By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 2,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Appending data to a table

P: 85
Here's what I have

A form
A query
A table

The table is where information needs to be stored into (named "Security Master") and it has text boxes to store that data in.

The form "Make Symbols" is what the user opens up and adds data. This form has three controls and a text box. The three controls are drop down boxes where a user will select something from. The text box is where the user will enter a quantity into. A total of four things must be entered.

Note: Those four things are what it takes to generate 6 alpha-numeric symbols.

I have query with those 4 things in it from the "Make Symbols" form along with 6 more text boxes where I have code in it to take that data and arrange it into the alpha numeric symbols. The code works! Thanks to Bytes.

The intentions are once the user enters that data, they click an "enter" button and that data writes to the table "Security Master". Including the 6 special alpha-numeric symbols.

This table of data is what I will use to run various reports on request and/or export to Excel for other users to do whatever it is they do with it.

It's probably simple, right? I just can't figure it out.

Nov 11 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.