Search results

where do i insert the code? on what event line?

I have a form that gathers employee social security numbers. I am using access 2007. Is there a way to [after info typed in] only display the last for digits of the SS#? so 444-44-4444 would show as ***-**-4444? I have done a search but not finding anything. I could have sworn i saw this...

How about hiding PART of the field... like to hide all but last 4 digits of a SS# or CC#?

wow.. works GREAT. thanks. i see what changes you made.. and it works exactly how i envisioned.... if only everything in life were like that! thanks so much for your input!

ok, u rock! comes up on BOTH forms. that is fantastic, when i grow up i want to be you :)!!!! thanks so much. can i ask you one thing.. where did you alter the events... so i can learn from this and not mess up... which did you change?

boy u r quick!! checking it out!

hi rural guy. i just saw your previous post. i fixed the dealer thing on my original.. just might not have on this copy i am using to play with the model thing. I find that i need to work with diff copies labled.. otherwise i mess soemthing up and cant find out what i did. the dealer thing works...

Hi Rural Guy. THe code on dealer doesnt seem to want to work on the make model. i think its because of Make or model id's? What i want is for it to work like this? 1) person enters car... they select year make model. model isnt on list. (models correspond to make that was already selected. 2)...

I am trying to have a pop up form come up when a model isnt on list... but i want it to be the models corresponding to the make i selected. I add teh new model, then when i close the form the model field on my frmvehicles is populated with my new addition. this works for my dealers combo.. but...

to Rural guy: hm.. i had fixed my dealer page.. let me try that code on this one.. because what i did isnt working for the make model. thanks will let you know if it works too.

Air force coder --- do i put that code into the "on open" event? or on the other form Close event? or on activate event after it gets back to orig form?

hi.. yes i liked your code [rural guy :)] but i had figured that out a diff way in the meantime and didnt want to mess with something that worked .. .. this is all somewhat new to me.. the last time i did this was 10 yrs ago. THis is a new project, almost ready to re-vamp my old data base...

I am using Access 2007, and have some cascading combo boxes, that i would like to populate one of the fields after i add a new record. if you look at my form [frmvehicles] i have a cascading combo box for MAKE and MODEL. When you select a vehicle make, the combo box for models [cbomodel] only...

Thanks for a quick response! i got that handled [forgot to browse thru page TWO of this post.. duh]. BUT maybe you can help me with a similar problem.... similar, not same or i would copy my approach to the dealer table and sleep better tonight! if yo ulook at my form [frmvehicles] i have a...

Hi, I Am Havin The Exact Same Issue, How Did You Resolve It?

i can try that. i wanted to use some of the access 2007 functions.. that is one of the prob. another question, is there any way to do this that you know of without uploading and working of my data base on the web hosting company? the data base takes a LONG time to upload and its kind of a pain...

I am using access 2007. and Expression Web2. I was trying to get an inventory list to display live on my website, and created an .aspx page to do that. works fine in preview mode, but couldnt get it work once published. after 2 weeks of pulling my hair out, i didnt figure out how to do it only...

after some messing around, i realized i dont NEED the seperate pop up form, but can make my frmdealers a pop up form itself. that works fine, and after i enter the dealer info, i have a save record box that saves and closes the new dealer info, but how do i get the new dealer to show in the...

I am using access 2007. I need some help. I have a vehicle input screen, that has a combo box for the dealer the car belongs too. When the dealer i am inputting [dealerno] is not on list, i want a pop up box to come up [frmdealerpopup] asking if i want to enter the dealer. The "YES" generates...

ooops.. thanks! guess i cant used tabbed documents with a swithcboard!! works now! thanks!