Search results

possibly: control panel > display > appearance tab > windows and buttons

the simplest approach would probably be to check if a value is selected when the user tries to move and show a msgbox saying either "no value is selected, is this what you want?" or "value x is selected, is this what you want?" and offer yes or no as options. no returns them to the form and yes...

w3schools.com

how do you highlight what exactly?

i see. it's not the actual syntax i agree with it's the missing loop. i'm not sure of the vba syntax for dealing with xml but there does seem to be a loop missing. sry i can't help more than that.

i knew you would.

i thought i'd skip that part... :|

brent, is there any reason, then, to remove the default control setting in the table or can it stay there?

i'd go along with the previous responder.

how about an append query? your save button can do the save and append, or a separate button for the append with values you want already filled in.

i use a book by Deitel and Deitel (c#). it's extremely good. (except it's falling apart, terrible binding).

subversion. google 'tortoise svn'. at least i think that's what you're after.

looks like the server delays got in the way and i deleted the thread that was responded to (this post came in three times). sorry to whoever responded there. this is the active thread now.

ME.mycbobox (value is not required) always returns the first column. you'll have to specify a specific column. ME.mycbobox.column(1) <-- 2nd column

definitely. you could also create variables for each part, or subpart. create an int variable that looks for the position of a hyphen (InStr(1,"John Boxer-Smith","-")). if it returns 0, there's no hyphen and you would know not to include/bother with that.

Left("John Boxer-Smith",1) & Mid("John Boxer-Smith",InStr(1,"John Boxer-Smith"," ")+1,1) & _ Mid("John Boxer-Smith",InStr(1,"John Boxer-Smith","-")+1,1)

i'm not sure off-hand if this works for combo boxes but have a look at the Old Value property. you can do a comparison with that. Old Value represents the original, saved value. you can compare the current entry with the value. if old value doesn't work with combos (i think it does), you can...

there is no rule. if you are comfortable creating a class, or want to give it a try, do it. as they say, it might take some time to set up, but it will pay off later. i created one recently to calculate the sum (price) of rows in a subform. i originally did the calculation in code behind...

might not make a difference but you could try creating another query to use as the basis for this one, but remove the fields you aren't using in your calculation.

i think there are several threads around here about books databases so be sure to search this site. instead of us starting from scratch it would be much easier and faster to see a basic outline of what you have already and we could comment on that.