Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by australia3

  1. australia3

    Copying from Excel column into Access combo box field

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

    Copying from Excel column into Access combo box field

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

    Copying from Excel column into Access combo box field

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

    using an agent to run other agents

    Hi, can I write an agent using formula language preferably to run other multiple agents? thanks in advance for any help.
  5. australia3

    automatic e-mail based on a date field

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

    automatic e-mail based on a date field

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

    allow multiple values with calendar/time control

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

    Importing into existing documents

    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?
  9. australia3

    importing into a checkbox

    Thank you, I'll give it a go.
  10. australia3

    importing into a checkbox

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

    importing into a checkbox

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

    importing into a checkbox

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

    replicating different elements at different locations

    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)?
  14. australia3

    change colour of calender entry based on location

    Yes and I dabble in the development. I've had a go but can't work it out.

Part and Inventory Search

Back
Top