Search results for query: *

PHV Thanks for your reply. Your suggestion gets me part of the way there. The code counts the number of records in the recordset, but then duplicates the first record equal to the record count. Hopefully I can adjust the code so it loops through the records. Thanks

I would like the details to be in the message text of the email and not as an attachment. Can a report be pasted into messagetext??

Hi there, I have a continuous subform containing a click button that when pressed, uses the DoCmd.SendObject object to send the records from the subform using Outlook. The message text contains the records in the format line 1 :field1 line 2 :field2 line 3 :field3 The problem I have is that...

Aarggh, the flicker has returned. I added the box and used its On Mouse Move event but because the box in the centre of the form, when the form opens the mouse pointer is in the box and so the On Mouse event is triggered which causes the flickering again. AceMan, thanks for looking...

Lewds, Thanks for looking, the flashing/flickering is a widely recognised "feature" of Access, it can be quite temperamental though which may explain why you couldn't replicate it. Crowley16, The application.echo was a useful line of enquiry, I couldn't get it to work though, it caused all...

Hi there, I have a label control on a form, when clicked it opens another form. Code in the On Mouse Move event underlines the label when the mouse moves over. The underline is on a timer so after 0.5 seconds the underline disappears. The problem i have is that when the the mouse moves over...

Thanks Remou, That was my first action to try "me.WPID" but it errored, that's what led me to think I had find another way to reference a control outside of the recordset - but when I added in your suggestion it worked (without the # delimiters - the result of another thread). Alls well that...

Hi there, I have an update query shown below:- rs.Open "select [date] from vreport_workpackage_dates WHERE (WPID = 2878) and (milestone = 'integration end')", conn strSQL = "UPDATE WorkPackages1 SET [planned start date]='" & Format(rs.Fields(0), "yyyy-mm-dd") & "' WHERE WPID=2878"...

Eureka! It worked - thanks a million. I'm in so deep though I can't see the wood from the trees so am having difficulty understandiong why the extra ' used would have the affect they do. Now that answer part of my problem, I have the rest to battle through now. Cheers, my last strands of...

No its an adp - SQL Server back-end. I've been changing the data type of [Planned Start Date] to try and work out the problem. When I use the code: strsql1 = "01/01/2006" strSQL = "update [WorkPackages1] set [planned start date] = " & DateSerial(Right(strsql1, 4), Mid(strsql1, 4, 2)...

Thanks PH, This is a slight change to one of your other suggestions at the beginning of this thread. It gives the same error - Incorrect syntax near # ...I have no hair left to pull out :-(

Thanks for showing me where to go Skip. I've done as you suggest but still get the same incorrect updates. strsql1 = "01/01/2006" strSQL = "update [WorkPackages1] set [planned start date] = " & DateSerial(Right(strsql1, 4), Mid(strsql1, 4, 2), Left(strsql1, 2)) & "where [WPID] = 2878"...

Thanks for you response Skip, I've struggled to get Dateserial into the code - how do I do it? Thanks

The value of fields(0) is #25/10/2006# - this is what it should be, I'm foxed as to why it won't update.

...sorry cut off why would the error message say it's an invalid column name. I wasn't aware I was fiddling with the column name - which is still rs.fields(0) (or in actual fact [date]. I thought I was only changing the format of the value of a value int he field and not its title.

Perhaps I'm missing something or have the incorrect syntax in the update clause but I thought the (#" & Format(rs.Fields(0), "dd-mm-yyyy") & "#)" was ensuring the format of the value to be updated into the cell. Why would the error message say it' an

Sorry - yes I checked, moved, adjusted all spaces - still no difference. Rather curiously if I remove the second # the error message is "Invlaid column name '#25'". 25 is the start of the date 25/01/200 that I'm trying to update into the table.

Hmm checked spaces and they're okay but error remains. Still no joy searching for an axplanation of the error message ont he web.

Thanks Skip for your repsonse. I had that code originally (thanks PHV) but it throws up a run-time 170 error, incorrect syntax near '#'. The help option on my PC is intermittent and is not worrking today, and I've checked the web for a description of the error but to no avail. Any ideas?

Moved to thread705-1311407