Search results

Hi, I have the (really helpfull) error "You canceled the previous operation" coming up on the piece of code marked with a string of stars below: Dim IntMaxRev As Integer Dim strOpen As String strOpen = "[ProjectNumber] = '" & Me.ProjNo & "' and [PNo] = " & Me.PNo IntMaxRev = Nz(DMax("Rev"...

great, thank you... was kind of hoping that was what was wrong though!!

Hi, Im trying to have more than where criteria in a CurrentDb.Execute statement. I was wondering if you could tell me if i needed a 'where' for every 'and' (eg where x and where y). This is what i have at the moment: CurrentDb.Execute "Update TblPvnJustSTORE set...

Nigel, So sorry for not replying, I have been a bit manic recently. In the process of getting this into my db but at the moment it looks like its working a treat. Thank you!

HiTechCoach - That was the website i found as well- very usefull! Thank you all for your continued feedback - its interesting to see whats going on and nice to know i wasnt just going crazy!!

Just fixed it: CurrentDb.Execute "UPDATE TblPvnMain SET TblPvnMain.EmailDate = Now() WHERE [PvnNo] = " & Me.PvnNo & " AND [Rev] = " & Me.Rev Thank you all for your suggestions- if i hadnt been looking further into them then i wouldnt have stumbled across this answer!

Right... I think i may know why its doing it. I have just found an article that says: 'In VBA code, delimit dates with the "#" symbol. Regardless or your regional settings, Access expects these literal dates to be in the American format, e.g. #12/31/1999#.' I do indeed have '#' around my...

Thanks for all your suggestions - ill be giving them all a go today. dcb - the error is in the form (and table) I dont think i have the date showing anywhere on the e-mail.

Not quite sure how to explain, but ill do my best. I have auto dates in a form (for example, when someone presses a button which sends an automatic e-mail, a box is populated with todays date, using the now() function) This box is formatted to show the date as dd-mmm-yy (eg. today would be...

Oh thank you so much, thats very kind. Looking forward to having a look!

Nigel, This sounds like it would be great - but i cant seem to open it... is it in an access version later than 2003?

Hi all, I have a table all ready set up and populated with 1 column contianing OLE objects. Is there an easy way of getting this table to show the size of the OLE objects? I have seen quite a few queries and vba that looks like it should work, but i cant seem to get any of it to actually...

That looks like the exact thing that im looking for. Thank you!

Thanks for all your suggestions. I am aware that i would be able to change and update the front end very easily in this case, but i need the message ability to get people out of the back end as well. NigelShaw - thanks for your suggestion, i will have a think of how i can apply that idea.

Hi, I have just copied in the code shown in this mS access support page. http://support.microsoft.com/?id=285822 I was hoping that it would give me a list of unique computer names so i can work out who is in my system at any one time. It sort of worked... It gives me a list of computer names...

Thanks. I will try and think of a way of distributing the front end. This may well solve some other problems ive been having. However... this still doesnt give me a way of getting a message to everyone who is using it if i need to get them out of the whole thing (i.e. so i can make changes to...

Hi, I have a database with muiltiple users being able to enter the front end at the same time. Is there a way that if a button is pressed in ANY copy then a pop up appears on ALL the users screens? Basically i want a way of saying from my copy that all the users must exit the database so i can...

Great, Ill have a look. Thanks!

Hi, I have looked on the internet for the answer to this, and found loads of information, but i cant seem to pic out the answer i need from it all (I blame the thursday afternoon feeling!) Basically, what i want to do is this: I have a date (say a). I am outputing an e-mail with a...

Hum, yeah, that could be it. I spose that means i just have to deal with it?!