Search results

Ha ha. So much for banging my chest in my Tarzan like moment of glory. Yes, fixed single position.

Ahhh. Yep, results are displaying character equivelant of 2.5 êêó Well, spoiled my 5 minutes of victory. Any suggestions?

Nope. Just once. Thanks!

vbaInet. Thanks again for your help. I was able to obtain the results that I needed by slightly tweaking your formula as such: =String(Fix([OVERALL_RATING_NBR]),"ê") & "ó" & String(Val(Mid([OVERALL_RATING_NBR],InStr(1,[OVERALL_RATING_NBR])+1))," ") So 2.5 would yield: êêó (characters not text)...

Duh, thanks. Although, now the entire result is a repeated value. For example, a rating of 2.5 is appearing as êê.óóóóóóóóóóó (actual wingding characters) Formula is: =String(Fix([OVERALL_RATING_NBR]),"ê") & "." & String(Val(Mid([OVERALL_RATING_NBR],InStr(1,[OVERALL_RATING_NBR],".")+1)),"ó")

Thank you. I receive a 'Enter the Parameter value' dialog for the "ó" character. The character is in the font set, any ideas? Thanks again.

Thanks in advance for suggestions. Within a specific report, I have a field named ‘Rating’ that will have a numerical range from 0.0-5.0. Basically, I was hoping to insert a ratings view by utilizing special wingdings characters. I can achieve the results I need until the introduction of a...

Wow...that simple. I feel ashamed. Thanks for your assistance!

Thanks in advance for any assistance. I have a basic report that lists product records by date for each date/product occurrence. Example here: Date-----------Product 1/1/11---------ABCD 1/1/11---------EFGH 1/1/11---------IJKL 1/2/11---------12345 1/3/11---------98765 1/3/11--------111111...

Ok DCrake, quick issue. Code runs perfect, file is saved accordingly, however for some unapparent reason, the second column in my table is not transferred to Excel. This field is used in the filename, but the data does not appear in the Excel file? Any thoughts? --Edit:Disregard, somehow the...

Disregard. I made the changes prior to your post with the DB attached. Your revision worked perfect!!! Many thanks to you and B. Larson for all the patience, explanations and assistance! Thanks again!!

Hi, DCrake. I was able to modify and get the code to run without errors. However, the export file is now including the folder name as part of the filename. So instead of: ABCD-R1234567 I'm getting: My DocumentsABCD-R1234567 How can I trim out the folder from the actual file name. Thanks!

Thanks for the feedback. Removed the lines you suggested, however I continue to receive the following: "1004 "SaveAs Method of Workbook Class Failed". Any ideas?

Ok Bob, attached is a very stripped down version of the DB and export file. With the exception of the test module and data table, all remaining objects were removed as they are irrelevant to this. When running the code, the data is transferred from tblReqDetails to MS Excel file Test.xls...

Yes, I checked to ensure that no instances were running & all was well. I am currently out of the office, however I will post the DB & test file tomorrow morning. I really appreciate all the help!

Well, unfortunately that did not work either. Also, this revision did not peform a rename of the file. The data was transferred, however the file remained name Test.xls Error: File could not be accessed.

Got the file renamed accordingly. However the workbook will not close and the error code: 1004 "SaveAs Method of Workbook Class Failed". Thoughts?

Still not working. Code runs passed the data to Excel, then stalls. Workbook remains open as filename Test.xls. Error code in VB is "No current record" 3021. Any ideas? Public Function TferTbls() ' strTQName is the name of the table or query you want to send to Excel ' strSheetName is the name...

Obviously I have inserted the code incorrectly. The data is transferred, however the code freezes after the data is passed to MS Excel and the file remains opened. Yes, I know, this is probaby elementary, but I have no clue...which I why I have lurked on this DB all day. Any help is appreciated...

Thank you DCrake, but perhaps I am overlooking something (which is highly probable), but if I set the code immediately after the rst has been set, I will be bypassing the transfer option to my file 'Test.xls'. If I was simply creating a new file with the 'Vendor' & 'OrderID', that would be...