Search results for query: *

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 %> <%...

Thanks wemeier! This is very helpful.

Hi, I figured out how to do this. I just created 1 update query against 1 table. I then created a form that the user inputs a table name into. In the OnClick event on the update button, I used the rename command to rename the table the user specified in the form to the table name the update...

Hi, Is it possible to have an update query prompt for the table name that is being updated. I need to run an update query that will need to update different tables depending on what the user chooses. The tables all have the same field names. Thanks in advance!

I would like to be able to send an HTML or ASP page by email. I would like it to work like IE's send page by email. I need it to open up the default email on the PC and insert the page into the body. I also need it to insert the to, from and subject from what I have specified in the URL's...

Hi, I have a form drop down list with 8 options. I would like to make it so if one of the options is selected, it routes to another form. If any of the other 7 are selected it stays on the same page. I would like the 1 option to re-oute to another form without having to submit the original...