I have a postcode labelled column of data in Excel. The data looks like this, CF8, CF9, NP10. I have an Access table called Postcode with a combo box field called Postcode. The row source is a query on another table
SELECT [Postcode district].District FROM [Postcode district] ORDER BY [Postcode...
No it's not linked. In Excel I have data stored like this: -
column a
a,b,c
c,a,b
e,f,g
In the combo box field in Access the data source is a table of data with the letters in
a
b
c
d
e
f
g
I'd like to copy the Excel column to the Access field so that I have 3 records (as example) that contain...
Hi all, I'm hoping you can help. I have a column of data in Excel where each cell has multiple data entries separated by commas. I'd like to copy this into an existing (empty of records) combo box field. The combo box field is linked to a table and every record in Excel exists in the list. When...
Thanks for that Pascal. The view option is my best option. Would you use formula language in the agent and if so do you have an example of how it would look? Thanks very much
Hi, can you help? I've searced the forum but can't quite find what I'm looking for.
I want an automatic reminder or just an e-mail with static text to be sent to a static e-mail address when the date in a date field in our database passes or comes within a specific number of days of today's...
I'd like a field in my database that has calendar control (users are forced to use calendar format) where users can enter more than 1 date. When you specify allow multiple values the ption to control disappears? Then users, can put in whatever they want. Anyone any ideas? Thanks in advance for...
I've had some success importing into a Notes database and creating new documents as a result. is there a way to import into existing documents? I need to add data into a specific field within existing documents. Can anyone help?
I'm not sure what you mean. I have a checkbox on a form. The values have been entered manually in the design.
I am now trying to import from a csv file to the database so that I create multiple documents. This is easy for text fields and easy for the checkbox field when only one option is...
Yep, I appreciate that. The design of the checkbox field has the options as: -
Mon
Tue
Wed
Thu
Fri
Sat
Sun
I want to import data into this field so that Mon and Tues are checked when you go into to document. I can import one day so that one day is checked but can not do mor ethan one.
I am importing data into a checkbox on a form. The choices are Mon, Tue, Wed etc. The document properties of existing documents show this data as "Mon""Tue""Wed" but I can't import from a csv format when specifying the data in this way. Does anyone know how I need to specify this data to import...
Is it possible to configure the replication settings so that some aspects of the design (changes to views etc) are not replicated at certain locations (i.e. on a dial-up)?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.