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

...Private Sub ClickButton() Dim ddbase As Database Dim rs As Object Dim sql As String Dim SiteBox As String sql = "Select * from tblSiteSelect where(tblSiteSelect.autoid = 1)" Set ddbase = CurrentDb Set rs = ddbase.OpenRecordset(sql, dbOpenSnapshot) rs.MoveFirst ' the...

...CHAR_SLASH As String Dim FILE_STR As String Dim xl As Excel.Application Set xl = New Excel.Application GetFile = xl.GetOpenFilename("Excel Files (*.xls), *.xls", , "Select Site Excel file", , True) On Error GoTo Err_btnImportData_Click: For Each item1 In GetFile For VAR_SLASH = 1 To 500...

...CHAR_SLASH As String Dim FILE_STR As String Dim xl As Excel.Application Set xl = New Excel.Application GetFile = xl.GetOpenFilename("Excel Files (*.xls), *.xls", , "Select Site Excel file", , True) On Error GoTo Err_btnImportData_Click: For Each item1 In GetFile For VAR_SLASH = 1 To 500...

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