Recent content by humbletechie

Hi, Is there a way to have a memo field keep the same format that the data is copied as? I am copying data from .doc or .html files and would like it to save in the field without loosing the format. Is this possible? Thanks!

Hi, I am trying to display an image based off the value that is stored in a database field. I put the following code in the Forms On Current event and I have the forms data source set to the proper table. Dim Path Path = CStr(Me![ImagePath]) Me!Image7.Picture = Path ImagePath is a text box...

Thank you VERY much Tarwn. This gave me exactly what I needed.

Hi, I am attempting to use the LIKE search function but it only works in certain cases. For example: If I search for Garcia it displays all results with the last name of Garcia, but if I type Judge Garcia it displays nothing. The first name in the DB is not judge but is there a way to...

Finally Success! Thank you sooooo much for your help. Below is how I finally got it to work. <% Dim fees fees = Settlements(&quot;Atty Fees&quot;) If VarType(fees) = 1 Then fees = &quot;-&quot; else If VarType(fees) = 6 Then fees = FormatCurrency(Settlements(&quot;Atty Fees&quot;),2) %> Then...

Here is the output: fees = 1 OR fees = 511000 6 Thanks.

Thanks again. It is returning a value some of the time but there are a lot of nulls in the data. Can this be causing the problem? Thanks!

Thanks for your response. The first one is giving a type mismatch error and the second one is giving me a syntax error. Any other ideas?

Thanks for the VarType tip, that's good to know. I did as you said and I am getting a VarType of 6, which I believe is currency. I also tried changing the code to <%=FormatCurrency(CInt(Settlements(&quot;Atty Fees&quot;)),2)%> and it's giving me a Overflow: 'CInt' error. Any other ideas...

Hi, The fields format is set to Currency in the Access DB but it's displaying on the page as a string. I have tried using the formatcurrency and formatnumber functions and both are giving me a Type mismatch error. Below is the code for all three ways I have tried...

Yep, that was it. Thank you VERY much to the both of you for your help.

I tried taking out the underscores from the code and the tables and I am still getting the syntax error. Below is more code: <% Dim objConn Dim connStr Dim Firms Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot;) connStr = &quot;DSN=moosensquirrel;uid=;pwd=&quot...

Hi, Can someone tell me why the following SQL statement is giving this error? Error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Atty_2_CaseNew.Atty_ID = Tbl_Unique_Attorneys.Atty ID'...

This statement updates the cart with the next available order #. I looked at the database and the order numbers are all being updated without a loop statement. Here is something that might help also, the part that writes out the html receipt prints out everything fine, but only the email is the...

The code that sends the email, only list the first item in the cart, the cart items are pulled from an access database. The items are all in the database but only the first item shows in the email that is sent. Below is the code, can someome please help? Thanks.. <% option explicit %> <%...