Recent content by pam0566

I have a database (Cnpr 2003.mdb) and inside a table "Table1" and a field in that table "Email_Addr". I have a list of names and email addresses. i am trying to create a field that merges all of the records "email addresses" into 1 string separated by a ";". (so i can email via outlook to a...

I have a form named "frmvehicles" in that form is a field "vin". it is 17 digits long, and auto tabs to next field. I want something that will tell me if the 17 digit vin number has been IN My system before, and if so pull up a form Called FrmHistory. I need the system to ask "Would you like...

I am also trying to do a simple Capitilazation of the first letter and lower case on other letters in the word. i am not doing names, do dont care about exceptions. I copied this in put mask from above : >L<??????????????????????????? but not sure where to apply it. if i do it in the tabel...

sorry, wrong link, i was referring to the sticky re: vista. i will go thru this one. thx!

the service pack 1 [i have] and hotfix, yes, but said the hotfix for 64bit vista wasnt needed when i tried to install. so .. rest of my computers are running on xp.

Did you ever correct your problem? i am having the same problem. We are running access 2007 but the DB is still in 2003.. its SOOO slow, takes minutes to look up a record. THanks, Pam

I dont ONLY want it to open that way. When i use the switchboard to "add" i m only in data entry mode. I want to be able to open form with no record showing, but all my records there if i want to use the arrow key etc.

thank pat, i just saw your post... same idea... thanks for input

ok i figured it out. i created a macro to open form in data sheet view, then used my switchboard item to run the macro. I think there should have been an easier way, but this works ok. thanks

How do i force a form to open in INPUT mode as opposed to opening showing existing records?

yep!!!! Dont know why it was only on 3 forms.. but now i know... live and learn! Thanks

OK, Sorry if this sounds ignorant, but how do i put that into the button when its a switchboard item... i can't change the properties on those buttons, if i click on the properties for the switchboard only the main page shows up. :(

wher do i put that? on the form properties "onopen"?

i figured it out. those particular forms had the do.cmd.maximize on them, took that out and works great. thanks!!

me.restore gave me an error, but i took out the docmd.maximize that was in there, and it works now!