simple tasks..
- Thread starter DAPPLE
- Start date
David R
I know a few things...
- Local time
- Today, 01:04
- Joined
- Oct 23, 2001
- Messages
- 2,633
Formatting as SSN: Input masks in help.
Form size: Make sure you design your form on the lowest resolution screen you'll be using it on. You can't resize a form on the fly easily like you can in Word, though there are codes and programs you can use to do so. I don't recommend you try to tackle them yet.
Form size: Make sure you design your form on the lowest resolution screen you'll be using it on. You can't resize a form on the fly easily like you can in Word, though there are codes and programs you can use to do so. I don't recommend you try to tackle them yet.
David... First THANK YOU...
Next, I looked up the codes for entering masks. I entered ssn 000-00-0000
And it included the 'ssn' in the number format. Then I tried doing it another way, now I can't get anything to work. One thing at a time I guess.
Next, I looked up the codes for entering masks. I entered ssn 000-00-0000
And it included the 'ssn' in the number format. Then I tried doing it another way, now I can't get anything to work. One thing at a time I guess.
David R
I know a few things...
- Local time
- Today, 01:04
- Joined
- Oct 23, 2001
- Messages
- 2,633
When you are in the Properties window, click on the [...] near the end of the Input Mask box. It will walk you through the input mask wizard and put the correct format in your field. Once you do it a few times you may get the hang of it but it can't hurt.
David R
David R
It worked!... you're so good.
Do you have a cheat sheet with these wizard calculations or something?!
You could fax it to me - if so, email me at work and I could give you fax number.
[This message has been edited by DAPPLE (edited 04-12-2002).]
Do you have a cheat sheet with these wizard calculations or something?!
You could fax it to me - if so, email me at work and I could give you fax number.
[This message has been edited by DAPPLE (edited 04-12-2002).]
not_rich_yet
Registered User.
- Local time
- Today, 07:04
- Joined
- Mar 19, 2002
- Messages
- 39
Dapple, in all of these posts, I don't think any of us know what you are actually trying to create!
Any chance of you posting what you are trying to do, with a list of what tables(and their fields and field types) you currently have (and maybe any relationships you have between tables?)...
I think some of the problems you are having could be down to the wrong table design/field type etc....
nry
Any chance of you posting what you are trying to do, with a list of what tables(and their fields and field types) you currently have (and maybe any relationships you have between tables?)...
I think some of the problems you are having could be down to the wrong table design/field type etc....
nry
Ok, here's more detail on what I'm trying to create.
I need a form that will display the following information on each salaried employee:
L Name, F Name, SSN, EE ID, Hire Dt, Birth Dt, Term Dt, Position Start Dt, Position, Company(because we merged several), Location, and a lot of salary / bonus information.
This is to be formated so that we can view one profile at a time, and print individual or print by critera (such as all EE's within this particular company).
Also, icing on the cake would be: if I could learn how to formulate the fields so that (ex)
10% was his personal/local performance level
18 % was the company performance level
Divide those percentages by two = total bonus percent for that yr.
Mr Jones should get 14% of his annual salary of 40,000 = calculates to: 5,600.00
Make sense? I'll settle with just getting the form set up for now.. haha. Information is not all on one spreadsheet. The table was created from one spreadsheet, then saved as form. Now I want to incorporate the other information... hmmm.
I need a form that will display the following information on each salaried employee:
L Name, F Name, SSN, EE ID, Hire Dt, Birth Dt, Term Dt, Position Start Dt, Position, Company(because we merged several), Location, and a lot of salary / bonus information.
This is to be formated so that we can view one profile at a time, and print individual or print by critera (such as all EE's within this particular company).
Also, icing on the cake would be: if I could learn how to formulate the fields so that (ex)
10% was his personal/local performance level
18 % was the company performance level
Divide those percentages by two = total bonus percent for that yr.
Mr Jones should get 14% of his annual salary of 40,000 = calculates to: 5,600.00
Make sense? I'll settle with just getting the form set up for now.. haha. Information is not all on one spreadsheet. The table was created from one spreadsheet, then saved as form. Now I want to incorporate the other information... hmmm.
