Search results for query: *

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.

i have it on continuous form and it only shows the first record. not all of them. I know i can do it in the record source. but i really would like to do it with record sets. that ok, its sunday evening here. I had my morning fun too.

thanks fneily i will try that and see. but beleive it or not i got it working. there were 3 issues (1) i didn't dim the sql as a string (2) I had to set the focus each time for each box (3) I had to remove the table name from each rs.field and only leave the field names. here is what i have...

I checked and the reference is there. I did the changes as you suggested and still the same error. I have used this code many times but only pulling from one table. I should have mentioned I am trying to pull from 2 different tables. Also this is the first time i am trying to populate fields. I...

Hello, I am new to recordsets and need a little help if you would. I am tring to populate a form with a recordset with unbound text boxes and i am getting a "run-time error '3265' Item not found in this colection" I have tried several different ways but nothing is working for me. I have my...

Rick, again i thank you so much. it worked perfectly. Except I had to change the ex.dsecription to err.description. I still have a lot to learn but it great to know there is help from people like you. Thank again from over here in Iraq