Recent content by Sullaway

Thanks FancyPrairie, I did get it to working by putting the code in On Key Up instead of On Key Down but you did bring up an interesting point about the Combo's bound column being null. I believe I will give that a shot and see what happens. Good thinking on your part. Thanks again, Shane

Access 97 combo box is on a continuous form. In one of my combo boxes I have code in the key down event, which works fine except in one case and that's when a user types data that is not on the list. I have code that takes them to a separate form to add the new data, which that works fine also...

Thanks Paul, I believe this is what I was looking for. Shane

Wondering if someone could lend me a hand in coding a public function that when a command button gets focus it changes the forecolor and when it loses focus it goes back to it's original color. I have read help and searched on several forums and found code similar but I'm too green to change...

Thanks hsitz, but it didn't work. It fired an error message stating that I had a syntax error and identified where I had put the # signs.

Good morning all, Access 97 I'm trying to use a date field (date of birth) as part of a process to check and see if the customer already exist in our db. I'm using a DLookup variant (varDOB) to search the db for a matching DOB then in my code I'm asking if the date of birth typed in this new...

I thought I might explain what I'm attempting to do so that maybe the above will make better sense. What I would like some advise on how to do is. When a user is entering info on a new customer and has started a NEW record in frmCustomers I would like to use the Name field and Phone field to...

Hello all, What I'm attempting to do with the following code is prevent duplicate records from being entered in our customers records. I'm checking several fields using dlookup to see if I have a match, if I do then I would like to fire a message letting the users know that we have a matching...

Thanks Tmconsult, No my form does not display more than one record. Maybe databaseguy is right. Maybe it's appearing to lock everything because I don't have enough info in it yet. Should I set it to "No Locks" for about a month or so and then change it to "Edited...

Thanks Tmconsult, To be more specific. I'm talking about the choices on locking forms. In the forms properties I chose Edited Records as the locking method but instead of it locking the page that the edited record is one it seems to be locking the entire table. Could this be because I only...

Hello, I'm having a problem that has me confused. I'm ATTEMPTING to go on line with my first DB. It's in A97; multiuser environment. In reading help on record locking, my understanding on choosing Edited Records, is the record being edited and possibly a couple more would be the only records...

Terry, Thanks for the help. It almost always turns out to be something simple. Shane

Hello Tek-Tippers, I'm having problems getting this error fixed. I have been reading books, past post, & etc. for about 3 hours now. I have found a lot of information on it but just can't seem to fix my problem. I'm trying to pull infomation from Table Customers and update the Address...

Hey Lloyd, I have been fighting this same problem for a week. Like you the same things that was working for me before were not working this time, so let us all know how it goes for you. I know for me IsNull didn't work either. Your code Nz(Me.txtStartDate,"")="" should...

Hey tdenny, When you say the standard DoCmd. are you specifing to go to a new record? DoCmd.OpenForm "FormName", , , , acFormAdd With the error message that your getting it sounds like it's trying to find a specific record. If your DoCmd is like above. Then in your forms...