Hello All at MVD,

This question probably has been explained in numerous ocassions but I've searched the forum looking for something to solve
my problem and frankly didn't find it.  I have a multiple tables and several forms.  In the main form, I show a grid that displays
an employee database with different fields, idnumber, name, department, ss#, hiring date.  I have  a button to add new records,
in this form, you add the information that will appear on the grid with the corresponding fields.  I want to add another button to this
form ( the new record form ) that will open up another form to enter additional actions to be taken on that particular employee,
i.e.  vacation, leave of absence, medical leave, destitution, etc.  This new form will have two combo boxes that display values to be
chosen, memo field, and other things.  What I want to do is to bring the information I have from form1 (New record form) and display it on this second form (Actions Form)
plus save the new information from the combo boxes and memo fields , all in the same record in the database. Is this possible?  Please help!!
Thanks.

152

(11 replies, posted in Script)

Thank you all for your kind replies, I'm learning a lot with the examples.  Much appreciated smile

153

(11 replies, posted in Script)

gonpublic2k wrote:

Thanks to all of you, yes ehwagner, I did see that and fixed it in my project.  Thanks.  Everything is working fine, another question
how do you display in a datagrid only certain columns, say based on user profile?   i.e.  If I have two users that access the database,
one with administrator privileges to the database and another with only view privileges ( I created a login form for this ) how do I enable
only certain columns to show in the datagrid for the user without administrative privileges?  I know it's a bit confusing, sorry for the long
sentences.. sad

Appreciate your help!

Still need help with this, please sad    yikes

derek wrote:

Hello Gonpublic,
Have a look at the attached.  You can either display what you want into fields or, as they are not connected to any DB, you could simply display them as labels.
Derek.


Perfect!   Thanks a lot Derek.  big_smile

NOBODY???  sad

I want to use two textboxes to show current date in one box and current time in the second textbox.  These two textboxes will be read-only and not
connected to the database, just to show current date and time on the form.  Is this possible?   Can you show me a script on how to get this
accomplished?  Thanks!!!!

157

(11 replies, posted in Script)

Thanks to all of you, yes ehwagner, I did see that and fixed it in my project.  Thanks.  Everything is working fine, another question
how do you display in a datagrid only certain columns, say based on user profile?   i.e.  If I have two users that access the database,
one with administrator privileges to the database and another with only view privileges ( I created a login form for this ) how do I enable
only certain columns to show in the datagrid for the user without administrative privileges?  I know it's a bit confusing, sorry for the long
sentences.. sad

Appreciate your help!

158

(11 replies, posted in Script)

Okie!  big_smile   Thanks Derek, will post my results.

159

(11 replies, posted in Script)

One more thing @ehwagner... what if I wanted to do the same exact thing but with a picture?  If I have a picture that shows on
suppose, form1 that I loaded from the database, how do I get it to show on form2 when I press a button on form1?   Is that
possible?  thank you in advance!

160

(11 replies, posted in Script)

ehwagner wrote:

Here is an example. See attached.

Thank you so much man!  that worked like a charm!!  smile

161

(11 replies, posted in Script)

[Hello All,

I'm a newbie and need help with the following issue:... I want to be able to pass data between forms to enter on a textbox.  Example: When I have form1 open, I enter text in a textboxfield, then I press a button on form1 and it opens form2 and displays the text I entered on form1 in an empty textbox on form2.  Is this possible?   Here's a graphic of what I want done in VB:


Attached.

http://i63.tinypic.com/15wf4e9.jpg

Thanks in advance!!