Search results

Thanks, Shades, for persisting. I had to install the Format Painter in my standard tool bar and then tried to follow your instructions but no joy. I dug out one of my Excel manuals and tried to follow their instructions, still no joy. I'll sit down with one of my Excel fluent associates and...

Hi Shades, Am I missing something in MS Excel 2000? When I export the queried results to Excel the values displayed have the ' prefix when any cell is selected and the value is displayed in the formula bar window (ie. '1234567890). Under the number tab of the Format Cell menu the only place I...

Problem solved. Thanks Bob for your reply. I did a search on "SQL" and "Format" and found an example used to convert dates. The scary part was just to substitute my phone mask and it worked the first time. :D For those that read this far my query solution included the following: Format...

Hi All, I'm still using Access and Excel 2000. I store phone numbers in my Access DB without "()" or "-" and use the input mask "000\-000\-0000;1;_". Everything was fine until I was asked to export this information into an Excel spreadsheet. In Excel all my phone numbers were displayed...

Soved Exclamation Problem Thanks for the response RG. I finally created a new test form with a listbox and some text controls and those worked as expected. After a little comparison of the listbox property sheets I found that I had the control source bound to mlID instead of making it...

Hi All, I have been trying to improve a form used to add/edit names in a mailing list. What I want to do is check the database for possible duplicate names and alert the user to the fact that their new person may already be in the db. I used the following VBA code in the After Update event as...

Thanks Battenberg, That works! :) Now I need to find a brief summary of event explainations and in what order they and be fired as one tabs between controls of these forms. D

Thanks Bob for your response. I am still very new at Access and do not really understands the order of events when clicking from object to object in a form. This is the code I currently am using and perhaps you or another reader can explain how this list box functions as a "subroutine" of my...

Hello All, After much hunting I must come back to the Forum for further direction. I am trying to add a listbox to my form (ACC2000) which will pop up when a particular condition occurs. I have a combobox, cboPCID, that lists cities from tblPostalCodes table. I added a listbox, lstZip, with...

Thanks again Ejsterfl, Martin Green's tutorial was very helpful. After I had wrestled with my code I have been able to get a list box to display when there is more than one record in my tblPostalCodes table with city name entered in my combo box. Now I want to find a good way to rehide that...

Thanks for the replies. In reverse order, ejstefl, I am the only user of this form & database. I'm adding names to a DB from a visitors list and they don't always provide zip codes. G-T-H, use of a list would require constant scrolling to find the right zip. There has got to be a better way...

Hi all, I have a form in Access 2K that properly displays city, state and zip codes. As I type in each letter of a city's name into the combo box, I get the first city in the sorted list displayed (autofills). That's fine when there is only one zip code for a city, but when I enter "chic" for...

Found a work around Well, I came up with the following solution that seems to be working (two form letter & envelope runs later). I elected to use the AS feature in SQL to create a new merge field that incorporated Title, FirstName and LastName together rather than the three individual fields...

Thanks Sandre for the thought. I googled on it to find out what you were suggesting. For any other readers of this thread a non-breaking space is: "When Word calculates line width and wraps text to the next line, it tries to break the line at either a space or a hyphen. Sometimes, however, you...

Hello All, I have a table that has title, first name and last name attributes. Normally the title is “Mr. and Mrs.” or “Ms.” but sometimes there are no values entered. When I merge data (using a query) into Word 2000 the results are less than satisfying. <Title> <First Name> <Last Name>...

Problem solved Thanks RG, I dropped that line in and my form now displays the proper record. That's TWICE this week that you have been able to get me straight. Thanks Again.:D Dale

Still fishing for some ideas. Dale

Hi Rich, Your solution generates the "Record Not Found" branch of the if then statement. Dale

Hi Selena, That get statement is located in my basSearch Module a portion of which is here: Option Compare Database 'Use database order for string comparisons Option Explicit Public lngpcIDSelect As Long Public lngmlIDSelect As Long Public strtyTypeCodeIDSelect As String Public Function...

My code doesn't do what I want it to do (Still unresolved) Hello All, I'm trying to display a choosen record from a table with a record id that is a TEXT data type. A variation of this same code works correctly in another form where the record source is a table with a record id that is a...