Search results for query: *

cheers

I'm trying to open an excel file and subsequently run an excel macro through a vbs file. I've got this far but can't seem to finish off. Set objExcel = createobject("Excel.application") objexcel.Visible = True objexcel.Workbooks.open "c:\training 2.xls" objexcel.application.run macro ="test"...

I've been successfully running a website using php and mysql with a (non-technical) friend for the past 12 months and am about to take 6 months leave to go travelling. To date the database has been populated using data from an MS Access database importing txt files when needed through the...

Royvidar Cheers Reading back on my thread I'd missed out quite a bit of code on the thread which appears in the real code (shouldn't rush). The line I was looking for is rst2(fieldtoupdate) = "Value" Thanks again

I'm currently trying to update a field in a recordset based upon a variable defined in an earlier recordset. eg recordset1 identifies field3 as the field to be updated so I've captured this data as a string. recordset2 will then update field3 with a specific value. I can't get the update to...

thanks I'd started heading in the same direction. I've used the Restrict command to filter out the activities for the day and time and am currently working through the rest of the code. Cheers Dave

I've set up an application in Access 97 which currently creates calender activities within Outlook 2000(as well as recording the date and time in Access). This works well. What I'd now like to do is from access delete the activity from outlook, based upon the recorded date and time. Or...

Thanks Gerard1979 Environ(1) gives the computer name which will allow me to tie in who's logging on where. Cheers Dave

Hi There I'm trying to identify the IP address and or Machine Name as the users log on to a shared (10 users) access database. Any suggestions? Thanks in advance Dave