Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. uncchcs

    SelStart of Controls

    I have a form that has 25 controls each of which are textboxes or combo boxes. What I am trying to do is set the SelStart of each control equal to the SelLength. What I have done so far is to set the SelStart = to the SelLength on the Enter event for each control. For example: Private Sub...
  2. uncchcs

    SelStart of Controls

    I tried the ctl.SetFocus before the With...End With block and it attempted to set the focus on all controls including labels which triggered an error. I tried adding it before the .SelStart = .SelLength line and no errors, but it wouldn't physically work.
  3. uncchcs

    SelStart of Controls

    I have a form that has 25 controls each of which are textboxes or combo boxes. What I am trying to do is set the SelStart of each control equal to the SelLength. What I have done so far is to set the SelStart = to the SelLength on the Enter event for each control. For example: Private Sub...
  4. uncchcs

    List box selection to textbox

    I have a list box with the following columns: | Product | ProductID | Category | On the same form, I have a textbox for each column in the listbox. I want the user to be able to select a row from the listbox and automatically update(fill-in) the textboxes for each control.
  5. uncchcs

    City,State Lookup From ZipCode

    Here is a link to a tool that does almost exactly what I want to do: http://secure.necaweb.com/caryp-cgi/hazel.cgi?action=serve&item=zipcodelookup.htm Download the demo and have a look and let's see if we can come close if anyone can help. Why don't I just purchase the tool? Well, I think $679...
  6. uncchcs

    Form Close,Save,Cancel...

    OK Here is what I want the form to do: User opens form and hits new to create new record... If user hits save, then either (X) or btnClose, the form will close. If user doesn't hit save, then when closing with either (X) or btnClose, prompt user with Yes,No,Cancel Yes will save record and close...
  7. uncchcs

    Form Close,Save,Cancel...

    This is the code I am using: Private Sub FormDirty() Dim Msg, Style, Title, Response, MyString Msg = "Do you want to save changes to the current record?" Style = "vbYesNoCancel" Title = "Save changes" Response = MsgBox(Msg, Style, Title)...
  8. uncchcs

    City,State Lookup From ZipCode

    I suppose I need to find another zip code table... Does anyone know where I can get a updated table with no duplicates?
  9. uncchcs

    Form Close,Save,Cancel...

    I have a form with buttons where users can save,cancel,delete,create new, or close the form. What I want to do, is if the user attempts to close the form after changing data without clicking save, prompt them on close to accept or cancel changes. The same if they attempt to close with the...
  10. uncchcs

    Save,Cancel,Delete,Close...

    I have a form with buttons where users can save,cancel,delete,create new, or close the form. What I want to do, is if the user attempts to close the form after changing data without clicking save, prompt them on close to accept or cancel changes. The same if they attempt to close with the...
  11. uncchcs

    City,State Lookup From ZipCode

    Just picking one for example: The zip code 78209 for example, corresponds to the following cities: San Antonio, TX Terrell Hills, TX Alamo Heights, TX And the zip code, 28621: Austin, NC Benham, NC Burch, NC North Elkin, NC Pleasant Hill, NC My zip code table initially has 78,000 zip codes...
  12. uncchcs

    City,State Lookup From ZipCode

    Someone pointed me to a zip code table where there are about 32,000 zip codes that correspond to more than one city. I ran an append query and removed the duplicate zip codes and checked a few of the duplicates with USPS and indeed there are a good many that do correspond to muliple cities...
  13. uncchcs

    City,State Lookup From ZipCode

    I have a form where the user enters a zip code and the city and state is automatically filled in. I am using the following code: Private Sub ZipCode_Exit(Cancel As Integer) Me!State = DLookup("State", "tblZipCode", "ZipCode = " & "'" & Me!ZipCode &...

Part and Inventory Search

Back
Top