Search results

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

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

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

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

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

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

Hello All, Has this happened to you? I'm pretty new here and was working my way thru some code (Using Access 2000) when I tried using breakpoints. When I ran the code it does not stop at the breakpoint and I am not able to get the variables' values by hovering the mouse. Closed that project...

Is it possible to get a combo box control (in Access 2000) to accept a string of characters not on the list and then as a result to run a modified query employing that string of characters and displaying a reduced list from which to make ones selection? Column 1 in the record ID and column 2...

Is there a way around this occasional problem with and combo box using a select query in Access 2000? The query in Row Source is: SELECT [qryCSZ].[pcID], [qryCSZ].[pcCity], [qryCSZ].[pcStProv], [qryCSZ].[pcZip] FROM qryCSZ ORDER BY [qryCSZ].[pcCity], [qryCSZ].[pcStProv], [qryCSZ].[pcZip]; The...

Never Mind... Need help with DLookup Function While everyone was taking a few well deserved days off, I kept googling and found the solution : strMemberCode = DLookup("[tyMember]", "tblTypeCodes", "[tyTypeCodeID]=Forms!frmAddEditMemberListings![cboTypeCode]") Divit11 :confused: I am having no...

Hello all, I am trying to create a users manual to be used with my newly designed database. I think it's pretty user freindly already but if one hasn't spent hours with Access manuals they may need some help. Anyway the Relationship Window is a handy way to understand what is in the database...

Hello All, I am just beginning to work with Access 2000 and though my first address book database seems to be working well by itself it does not want to play nicely with MS Word 2000. The current problem is that data seems to be merging into my Word documents in lower case (yes, the data was...

Hello All, I'm just beginning to work with Access 2000 and VBA. I've been reading a lot of your threads and have been able to incorporate some of your solutions into my first address book project. Do you remember those early successes? Well, I wanted to do a mail merge using MS Word 2000...