Recent content by dwilliams

  1. D

    Question Access and Outlook

    So now I have 500 or so customers and I want to send them all and email (I have all their email addresses in the table). can I get them all into the TO field an Outlook message? I have Office 2010 on Win XP Pro SP3 Thanks Dave PS I have checked some previous answers and on other boards but...
  2. D

    Append Excel records to an Access table

    Hi, I have Office 2010 working on XP Pro SP3. This is the first time I have tried to append/import a bunch of names and addresses from a spreadsheet into my access table. I thought it would be easy with all the integration of applications but it's not. What happened to the bit where I could...
  3. D

    Another DATE question...

    Thanks Coach works fine. I have been doing backups regularly using the free version of Syncback. I think a setting must have been incorrect as I don't seem to have the latest copies of things. My database was one, .pst file another. I will check that they are working next time instead of just...
  4. D

    Another DATE question...

    Hi I had a normal select query that when I ran it offered up two Message Boxxes for the user to enter the start and end date from which the records would be selected. I lost it!!! Bu99er! Can anyone help me recreate it - I can't remember whether there were two new fields in the query (...
  5. D

    Feeling dumb but ....

    What are the little plus signs you get in tables? I have never used them myself but I have just taken over another database with loads of tables that have these little plus signs placed before the first field. When you click on them they show other data. Seems a good feature but I have no idea...
  6. D

    Show day of the week

    Where do I put this code Bob? Thanks for your reply but where do I put this - in the table design or in the query? Cheers Dave
  7. D

    Show day of the week

    Hi, I have a straight forward table with a field called DATE. I run a query on that table so that I can create a Report selecting data between 2 dates. What I want to do now is to create a new field in the query that displays the actual day of the week (Monday, Tuesday etc). I have tried...
  8. D

    split databases

    Hi, I just got Access 2007 and split a database into a front and back end to see what it was like. Is there any way of joining them back again? Thanks David :o
  9. D

    Cusum charts and SPC add-ins

    Charts I suppose you have thought of embedding Excel in a form? Theres loads of stuff on that. Otherwise I have no idea. Sorry.
  10. D

    Each alternate record a different colour?

    Alternate colour - thank you all Thanks very much for all the help - brilliant. I got loads to go on now. Sorry about the duplicate thread.
  11. D

    Tabular form/report - alternate line colour?

    Hi, I am trying to produce either a report or a form that displays records 1 to a line. That bits easy enough using a tabular layout. I would like to make text boxes that hold the data a differnt colour on each alternate line. So the background colour changes from white, then green, white ...
  12. D

    VBA Developer Banking Zurich - job offer

    Get this nonsense OFF here. Its a forum not a recruitment page.
  13. D

    Each alternate record a different colour?

    Hi, I am trying to produce either a report or a form that displays records 1 to a line. That bits easy enough using a tabular layout. I would like to make text boxes that hold the data a differnt colour on each alternate line. So the background colour changes from white, then green, white ...
  14. D

    MoveLast doesn't move last...?

    Got it Thanks very much, works great now. I appreciate you taking the time to answer. David
Back
Top Bottom