Search results for query: *

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

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

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

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

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

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

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

I have a code based on whether we have a zip code on a customer or not. I have trapped for Null and "", which works perfect but only if the zip code has never been entered. Here's where my problem comes in. If someone deletes a zip code out of the customers record and leaves the field...

Well I've read enough and followed enough examples to totally confuse myself. If someone would please give me an example of Parsing a string if it was to have 3 pieces of info in the string (ie FirstName, MiddleName, and LastName), I would really appreciate it. TIA Shane

A section of my DB will allow users to do a price quote. This price quote will be a combination of several vendors products. My thoughts are to have a subform on the price quote that will take the price quote details. In those details, after the user makes a choice of product, the vendorsID will...

I'm using the following code in a Not In List on cboReferralID combo box. If the name is not on the combo list then I want frmReferral to open, which it does, take the New Data from the combo box and put it in the name fields, which it does, then update the combo box list with new record, which...

I have a DB and it is split. What I would like to know is it a good idea to have the backend split more than once. In other words if I have Customers in one backend with all the tables that will hold everything about a customer we will need to know but in another backend have a table that will...

On one of my forms I am using has several unbound controls for the user to choose who we are meeting with on an appointment. At these appointments there can be Dr.'s, P.T.'s and etc. I already have the names and phone #'s of these people in separate tables. What I am trying to accomplish is use...

I would like to give users the capability of adding NewData to a combo box (value list). I found code that allows you to add for that once incident. If you go to a new record or close and come back the value is no longer on the list. What I'm looking for is code that will add the NewData to the...

I have a main form frmCustomers with tab pages. On one of the tabs I have a subform that I have made a continuous form. This displays a summary of payments on one invoice #. I have given the user the capability of double clicking on a line of the summary and going to the payment details...

I would like to combine several fields into one field on my report, ie Address,City,State,Zip Code but I would like it to look like... Address City State Zip Code Can this be done? I played around with Chr(13) and vbcrlf but apparently I don't know how to use these in a string or this can't...

I have converted CustomerID (autonumber-primary key) to a combo box to look up customers. In the combo box CustomerID is the bound field. This works good except for one problem. If the user deletes the contents of the combo box and tabs out of the field they get an Access error stating can...