Search results for query: *

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.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

Inputbox is modal too. Still struggling with it though

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

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