Search results

I need this done to work by 4:30 Atlantic time...OY I have the 2 forms that are to: 1) Take in the names of new children and add them to the db 2) Take in points based on the child chosen. I have the following problems: 1) The Points form will not update to a newRecwhen a child is...

even if it did appear, depending on the version of access, it prob just say #error as it will not be counted as part of the detail section. suggest put at top or bottom of detail section

right, but in my case the design view AND the form view are the same and hence my complaints. i cannot get it to look like it is supposed to in design view... THIS is what i need help with...

perfect as always, thank you! ;)

here, frm included this time

but what of it being in a field with 2 columns, name|code ie accommodations | 9000-5999

problem is that if stored at table level it still wont show at form... mike, can you alter it and send it back? included is the '97 version

db here is the DB, the problem is in table employer_SIC_codes and i was trying to do it at the form level, :(

the problem is there is a name associated with it, thus i return 2 fields in a single control name | code

it inserts it in the table and the field retains the mask, but the table does NOT return the hyphen when called out of the table

how do i do this, mask on controls

i realize now that i am using the date (#) instead of number (0) but it still poses the problem of not accepting the format as 0000-0000

the problem is that as an input mask it does not store the information with the - as i wish it to..

If (CountryID = "US" Or CountryID = "CDN") Then txtMyText.InputMask = "!(999") "000\-0000" Else txtMyText.InputMask = "" End If This should do it, but it won't store the information in the table in this format, rather as ########## instead of (###) ###-####, unfortunately hope this...

I am trying to make the data entry person have to enter numbers into a field in this format 9000-9599 always 4 digits, a dash, and another 4 digits, no spaces, 9 chara total I tried the validation rule as "####-####" and "####\-####" and in the validation txt "please enter number as...

different... apparently on my own computer at home i encountered a different view for the properties menu, i will try to capture a picture when i am home to show you the difference... :confused:

ok but how can i get the choice back at the top?

sorry yes, that's right i see what you meant now. that is where i wish to be is in the properties not the section, but when i go to properties it opens section.

basically i have had the actual properties window have a combo box listing all the things on the form from labels to the form itself where you could choose an object and then play with it's properties, if you look at the pic you'll see that this combo box above the tabs for an object are not...

look at pic in the pic the properties will not allow me to select the desired object, i have to select them individually this poses a problem as i want to change the properties of the form and i connot select it, it goes automatically to details. (at the top of the properties box there...