Search results for query: *

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...

Hey Victoria, I'm assuming your still talking about the combo box. One thought is go to your properties for the combo box and make sure the list width is the same as the width of the box itself. Maybe that will get everything to line up like you want it to.

Hey Dawn, Thanks for responding. I tried what you suggested already and it does work. I think, once the tab button has been pressed then the exiting of the field has already started and it will have to be cancelled some how. I not sure on this just trying to use common sense (which I don't...

I have code for a combo box that handles NotInList event, which works fine. I would just like to add one more thing to it but can't seem to figure out how to get it done. I would like to have the focus stay on the combo box. My code fires after the user has typed in something that is not on...

Hey CWillsh, No, I'm not saving any type of a format and the wierd thing is nothing shows in the text box (at least not that you can see on the screen). The Trim work around does work but I was just wondering if something happens behind the scene's when a user deletes the contents of a box...

Terry, Thanks for the help. I am trapping in code, to be more specific. Wondering if I could bother you a little further and ask you to explain why after a field has had a value entered then deleted, that IsNull or "" none of those work. Apparently there's some type of value. If...