I have an Access database which I export to a .csv file for searching with a script online. In both the table and the form, I have an input mask for phone number in the phone field. It views in both the table and the query (for sorting) as (xxx)xxx-xxxx
But when I export to .csv - it is removing the mask and just displaying as xxxxxxxxxx.
I did an .xls export to see if that worked - but it didn't
How can...
gryffyn
Last Activity: Feb 2 '07, 11:26 PM
Joined: Jan 26 '07
Location:
-
Exporting Removes Phone # Mask
-
Thanks for the help.
I managed to find the following at databasedev.co. uk - and so far it's working!:
...Code:Private Sub cboBookCategory_NotInList(NewData As String, Response As Integer) Dim strSQL As String Dim i As Integer Dim Msg As String 'Exit this sub if the combo box is cleared If NewData = "" Then Exit Sub Msg -
column widths for that is 1"Leave a comment:
-
Yes - that's where I put it. The Row Source of the combo box (for the breed field) on the Clubs form....Leave a comment:
-
I added that code to the Row Source property of the Clubs form (which is for the tbl_clubs)
The Combo box is not not populated with anything (completely blank when I click on the arrow instead of a list corresponding to the breed field in tbl_breeds), and does not add new entries to the tbl_breeds
:(Leave a comment:
-
Thanks - where/exactly how do I enter the code??Leave a comment:
-
Combo Box Lists
First off - I am not very technical when it comes to this (well, or any)program, so explain it as you would to a child <vbg>>
Currently I have three tables with accompanying forms for 2 of them - they are tbl_breeds, tbl_clubs and tbl_rescues
They have a field in common - "breed" (no quotes)
I am using a combo box in the forms (for the club and rescue tables) for the "breed"...
No activity results to display
Leave a comment: