If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error 1304 - How do I verify?
When trying to use the "lookup" wizard feature in Access, I get an Error 1304
writing to file asking me to verify that I have access to that directory. However, the only options are to "retry" or "cancel". How do you verify you have access to a directory? Doesn't make sense to me. -- Thanks for your help. Maureen |
#2
|
|||
|
|||
Error 1304 - How do I verify?
Maureen:
I don't know why you should be getting the error, but I'd simply advise you never to use the lookup wizard. Its generally regarded as worse than useless. For some reasons why take a look at: http://www.mvps.org/access/lookupfields.htm In table design view merely select the data type appropriate to the actual data in the field. This will usually be a number of long integer type which references a long integer primary key (often an autonumber) of the referenced table. To see the value from the other table use a combo box on a form; which is where data should be entered and edited, not in raw datasheet view. The combo box wizard can set it up for you, but its easy enough to hand-craft it. Say for instance you have a field CityID in a Customers table and on a Customers form you want to be able to select a city by name from a Cities table the combo box's RowSource property would be like this: SELECT CityID, City FROM Cities ORDER BY City; and its other properties would be like this: ControlSource CityID BoundColumn 1 ColumnCount 2 ColumnWidths 0cm;8cm (or rough equivalent in inches but the first dimension must be zero to hide the first, CityID, column, so only the name shows) Ken Sheridan Stafford, England "Maureen" wrote: When trying to use the "lookup" wizard feature in Access, I get an Error 1304 writing to file asking me to verify that I have access to that directory. However, the only options are to "retry" or "cancel". How do you verify you have access to a directory? Doesn't make sense to me. -- Thanks for your help. Maureen |
Thread Tools | |
Display Modes | |
|
|