Search results

great! as long as you don't have a 5-digit ID you're good to go. thanks for the update.

try: Dim intZeros As Integer With Me intZeros = 4 - Len(.IDField) .NewID = "084567" & String(intZeros, "0") & .IDField End With if you put a new field in your table called NewID and put the code above in the On Current event of a form, the NewID will be updated to...

are you trying to store this in a new field, or trying to alter the autonumber field data? edit: nevermind, i see what you're doing.

if you mark someone's post as a duplicate, get the url of one of the duplicates (browse to it and copy the address), browse back to the other and add a post of your own: "duplicate of [url you copied]." this will (hopefully) stop people from replying to both, and the link will take people to...

you could create a query with all of the fields. in the criteria for the year enter Forms!yourformname!textboxname for the month enter Forms!yourformname!combobox name you can then lookup the id of the query. if you get a result then you know that a record exists, otherwise enter a new...

moved to forms forum. :)

ayfour, i wasn't sure how far you wanted to go with this so i threw in those links. if you're building the forms with a wizard or by hand, i think you can disregard those links for now.

must be the time zone. yeah.

there are more ideas in the sample databases forum, too.

one possibility: put two comboboxes on the form. when one is updated, update the other to match with the other info. it sounds like your tables are normalized - you are not duplicating data - so the two boxes would always have to work in conjunction with each other.

sorry scooter, didn't see you had replied.

you can stop right there. no need to add controls to tell you something that you can already find out. if "the country is x", then you can find out by checking the text box or combo box or whereever the info is. you can/should do that with a query. use the check box to select one item. if you...

answer depends on how you are indicating or selecting the month and year on your form. are you using comboboxes?

oh mr. bolt ... missed it by seconds ...

try changing & WHERE to AND you working with copies of your tables i hope. :)

what data? you said it is blank.

see if the agent will defer it somehow to a another date. they're bound to find someone else to fill the spots. if they must, let 'em keep the cash, but you get space another time.

welcome to awf. http://msdn.microsoft.com/en-us/library/aa221170(office.11).aspx http://msdn.microsoft.com/en-us/library/aa221167(office.11).aspx hth.

" Private Sub object_BeforeUpdate(Cancel As Integer) Object The name of a form or a control. Cancel The setting determines if the BeforeUpdate event occurs. Setting the Cancel argument to True (–1) cancels the BeforeUpdate event. Remarks Changing data in a control by using Visual Basic...

you can compare with OldValue.