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!

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

Search results for query: *

  • Users: andytodd
  • Order by date
  1. andytodd

    query fails from access, works in mySQL-front

    Hi bboffin, I had looked, and even keyed through the data in various interfaces, but still no sign of any spaces. Your suggestion to use TRIM in the SQL statement (I didn't know you could do that) has fixed the problem. Thank you.
  2. andytodd

    Problem with join in mySQL

    Hi Bob, Thanks for the tip. As you say, hard to see a trailing space, especially as Access doesn't always allow you to key over them. Combining this with a suggestion from bboffin to use TRIM in the SQL statement (I didn't know you could do that) has fixed the problem. Thank you.
  3. andytodd

    query fails from access, works in mySQL-front

    Our database is mySQL, but has an MS Access (2000 at present) interface. We have a script which imports a comma delimited file and updates various tables in our db. As the data is supplied from Personnel (Human Resources) it is frequently misspelt, or prone to format change without warning...
  4. andytodd

    mySQL Problem with join in VBA

    This also posted on Access VBA scripts as not sure who is best placed to answer. Our database is mySQL, but has an MS Access (2000 at present) interface. We have a script which imports a comma delimited file and updates various tables in our db. As the data is supplied from Personnel (Human...
  5. andytodd

    Problem with join in mySQL

    Our database is mySQL, but has an MS Access (2000 at present) interface. We have a script which imports a comma delimited file and updates various tables in our db. As the data is supplied from Personnel (Human Resources) it is frequently misspelt, or prone to format change without warning...
  6. andytodd

    Connecting to Calander in Public Folder

    Hi Both, I've got similar code writing multiple appointments into individual calendars, but have been so far - 12 months in trying on and off - unable to write to a public folder. It is possible to read in from a public folder quite easily. Our short term solution is give the items a specific...
  7. andytodd

    Outlook edited hyperlinks break

    We send a lot of hyperlinks containing parameters to our own staff. When copied from the browser address box, or automated from VB these work both on the sender and recipients' machines. If the hyperlink is edited, whilst it looks and acts ok at our end (Outlook 2000), we get a lot of...
  8. andytodd

    outlook appointment startdate field not in linked table

    Just got it to sort and add in recurring items. problem with recurrances is they seem to recurr ad infinitum. So far it thinks my boss will get to be 1250 years old. Hmmmmmm When I get it out of the loop it is in now, I'll paste up the how on the FAQ
  9. andytodd

    outlook appointment startdate field not in linked table

    Hi Hap and any one else interested, I've been searching all of today (it's 5pm here), and can now read from a public folder using: Set olItems = MyFolder3.Items.GetFirst after setting the path and removing Set objAppt = objOutlook.CreateItem(olAppointmentItem) So far I can't sort or...
  10. andytodd

    outlook appointment startdate field not in linked table

    Hi Hap, The main requirement is to synchronise so rooms are not double booked, and if that works, the Head of Dept will use the same approach to check for tutor clashes. admin people do not want to include all random room use in the Staff Training database. The code used to write appointments...
  11. andytodd

    outlook appointment startdate field not in linked table

    Hi, I have to select, insert, delete and update a database and a Outlook calendar in a public folder in such a way that they either have (or appear to have) the same datastore. I have automated Outlook 2000 to send emails, and can write appointments from Access 2000. Am now trying to read...
  12. andytodd

    Automated Outlook, Have changed "replyto", want to change "From&q

    Thanks to both of you for your much appreciated assistance. [cheers]
  13. andytodd

    Automated Outlook, Have changed "replyto", want to change "From&q

    Sorry, Hit the wrong button. Any help at all would be useful as four of us are currently very confused. Andy
  14. andytodd

    Automated Outlook, Have changed "replyto", want to change "From&q

    Hi PJM, Thanks for the property name which works. It does however fail due to permissions as you said it might! Problem we now have is that I have no permissions to speak of, and those that do have permissions do not know where to start looking. Do I need to get them to change something in...
  15. andytodd

    Automated Outlook, Have changed "replyto", want to change "From&q

    Hi, We have an Access 2000 database controlling participants for our courses. It sends personalised mails automatically and when instructed to by controlling Outlook. We can set "to", "subject", "body", "importance" and "reply to" with code...
  16. andytodd

    inputbox too small, msgbox too modal

    Inputbox is modal too. Still struggling with it though
  17. andytodd

    inputbox too small, msgbox too modal

    Hi, We bulk send various standard e-mails to students based on their status / course status etc. This system draws information from a lot of tables and follows runs through a lot of automatic selections. To do this quickly and accurately, presonalising each email we use VB code in Access which...
  18. andytodd

    An IF Statement Needed!!

    In a text box try an =IIF statement as the control source. this uses the =IIF(SOMETHING,THEN,ELSE) format. The code here compares the field enddate to the field startdate. If they are the same, it displays startdate, if they are different, it displays both with an & in between (separated by...

Part and Inventory Search

Back
Top