Search results

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!

I am having the same problem, did you ever fix it? on access 2007?

I am using access 2007 to update an old db. The records are still 2003. When i open up a few of the forms, they open maximized, which is not what i want. I have resized them, changed fit to screen to no, changed autosize to yes, made them thin border not resizable... nothing works. Some of my...

I have an 2003 db that i am using 2007 to update (have not converted records yet.) on my switchboard, i have a button for a form that was created in datasheet view. I have changed the properties to NOT allow any other view. If i open the form from the navigation I view it correctly in datasheet...

I changed autosize to yes, fit to screen no, and when i click on it it still opens up full screen.

i already ck'd that, and even if autosize is no and fit to screen is no, a few of my forms open up maximized.