Search results

I can't seem to figure out how to preserve the paragraphs when displaying values from a memo data field. When I pull up the record to edit it in my form, the paragraphs are there, but when it displays in the FP DRW they are gone, and the memo is one big paragraph. Any ideas? Thanks Example...

Using FP2003 against ACCESS UPDATE registration SET regName='::regName::', regType='::regType::', specEvent='::specEvent::', friDinner='::friDinner::', satDinner='::satDinner::', vegetarianCouples='::vegetarianCouples::', vegetarian='::vegetarian::', specialReq='::specialReq::' WHERE...

I am using FrontPage/ASP/Access How can I embed a word file in a form and more importantly, have it save to an access database. I have a field called docfile that is set to the ole object data type. Thanks. This is a tough one, I have been searching my heart out, but the closest I came was...

I have two different search forms, one is meant to find books only, the other to find media. So for the media form there is only one extra field. For some reason, with this extra field, I get no results... Query for books (works fine) SELECT * FROM SearchActive Where title LIKE '%::title::%'...

I have two titles 'War and Peace' and 'Peace and Love'. When I search for 'Peace' I only get the 'Peace and Love' title, but not the 'War and Peace' title... SELECT * FROM SearchActive Where title LIKE '::title::%' AND author LIKE '::author::%' AND subject LIKE '::subject::%' Thanks

Im trying to return results for a month from before the current date and indefinately into the future, but under operational circumstances, I should have no records in the future. For troubleshooting purposes, i do. SELECT * FROM articles WHERE ((([ID] Mod 2)=True)) AND articledate > (date() -...

Is it possible to sort by weather the ID is even or odd? I want to display articles in two columns. I am pretty sure I can figure out how to write the date filters, but to get non-matching articles in each column I would need to filter some other way and by ID is the best I can think of...

Using FrontPage against Access DB... I have a search form, displays mathcing records with an update button. Update button submits data to update form, update form updates record and returns to search form. I want it to return to the record I have just edited. Here is what I have attempted...

SELECT * FROM SearchActive Where title LIKE '::title::' or author LIKE '::author::' or subject LIKE '::subject::' What am I doing wrong? Say I search for the word 'Time' in the title, I should expect to get all of the items with the word Time in the title, but I do not. If I search for the...

I am having a problem passing a variable to a DAP. In the simple search form, the variable (textbox) is called 'parameter' in the query it is written as [parameter]. When I open the query in access it asks me for the parameter and then it provides the appropriate results. When I submit the...

Thanks to this forum and the internet at large, I am becoming very good at developing using FP, ACCESS, and ASP. My question is, How do I create a pop-up that asks 'are you sure you want to delete/Update this record?' before the data is sent to the update form? Thanks! :) Oops! I put this...

I need to consolidate this data so that the values for 'Address' and 'City' are merged into one field or 'cell' according to the similar dates. This is a query result from two tables, one containing the Skip (Addres/City) information and another containing the Mileage and Route data. The query...