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

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

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

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

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

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

Hi, I have a page that reads from a database and populates a form with the results. This form then posts to another page which updates the info. I am receiving a syntax error on the update page. The key is an order # which sometimes gives multiple item results per order #. I would like to...

Hi I am running a select statement off one database to accumulate the needed records that I would like appended to an SQL database. I have the results of my select statement output to a page and the fields I want appended I have in hidden form fields. I then have the form post to an update...

Hi I am trying create a page that shows all orders that hit the first database but never made it into the second database. The problem I am having is both databases are on different servers. The order hits the first database and then processes run that puts it into the second database. I...

Hello Is there a formula I can use that will give me results from past dates? I need qty shipped on items for last week, 2 weeks ago, 3 weeks ago, 4 weeks ago, 5 weeks ago and 6 weeks ago. I need all of these to be in a seperate field like below. Item # last week qty 2 weeks ago qty 3...

Help! I created a table with a bunch of bit data types and they all are set to allow null. I am now trying to add another bit field and it gives me the following error 'TableName' table - Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the...