Recent content by icewiper

hello, i am new to php. my question is i am pulling a recordset from MySQL and populating it a php page. one of the fields shows the data as follows. "Ronald Smith (Ronald.Smith@domian.com)". i am only needing the actual email address to show on the php page. but with each record varying in...

Hey there fred, thanks for the response. I used the select statement a few different ways and still ended up with the same results i did before with the unique identifiers not matching while running through the recordset. But at least it will give me something to start with. Thanks again

Hello, here is the question. I have two tables, a tempProperty and a Property table. The TempProperty table gets created while being imported from an excel sheet. The TempProperty table will hold the current data and it needs to be compared to the old data. The fields on them will be the same...

well guys i want to thank you again. The only thing i could do is reinstall the OS and reinstall MS office. I tried uninstalling office and reinstalling it, but was unable to fix the problem. After redoing the OS and Office I installed my VB.NET again. the error came back. Once I uninstalled the...

hey there PHV, tried it before and made the changes again that you suggested. still the same error. thanks again for your guys help

xlApp.Workbooks(1).Worksheets(1).Range("A2").CopyFromRecordset rs

yes i am sure, I have been reading it for the last two days ... and now i am seeing it in my sleep. (ha ha) Run-Time Error '430' Class does not support Automation or does not support expected interface. Oh and i am running miscrosoft 2003 but its running at 2000 format. I tried the...

thank you i did try your suggestion but still the same error. I do understand about the reference to worksheet. we have been trying all options. But still the same error. It only happens with the copy recordset. here is the changed code as mentioned with your suggestion. Dim xlApp As...

Hello all, I have going crazy trying to figure this one out. I have used the copy record set many times and it has worked. Now for some reason I can not get past the copy recordset without getting that error 430. If I give the range an absolute value it will populate the excel sheet and work...

I have a question I can't seem to find an answer to. I would like to make a custom message box pop up in an email when I send it to employees to get there attention when I need information. I know there has to be a way with VB to write code in the back of the email. I was working on it once...

crowley, I can't believe i over looked that. Works like a charm. Thanks again

Hello, I am trying to print out timesheets in access through reports. I am running a record set and can pull the information with no problem doing debug.print. I really don’t work with reports much I am trying to figure away I can reference the record set fields to unbound fields in the report...

Hi Combo, Thanks for the reply, i was reading more in the tek-tips and ran across something PHV had said. It is pretty much the same thing you are saying too. I moved the xl.quit and the xl.workbooks.close the just before the importing. That still didn't seem to work so well until i changes the...

Hello, I have been reading the tek-tips on this issue but I still can't seem to get the matter resolved. I am importing multiple excel files into access. The importing works with no problem the first time, but I have excel.exe running in the task manager. When I import a second time the task...

PHV thank you, that works great. It will save me alot of time while coding.