Search results

Emailing Report? Hi All: I want to email my report as an attachment using Outlook. I have downloaded Snapshot viewer but I don't know where to put the code for making it work. I tried adding a button on custom toolbar but it does not give me the option of adding the sendobject code. I also...

Hi there, I have a table, notes, which has two fields-Notes and NotesDate. I want to create a report based on this table where users want to see only the last record added to the notes table. How can I do this? Thanx, Ekta

Thanx for replyin Raskew. I tried your function and it works great. Here is another function that removes both xtra spacing and double quotes. Public Function SingleSpace(InText As String) As String Dim S As String S = InText Dim D As String Do S = Replace(S, " ", " ") Loop Until InStr(1...

Hi I have had some success in this. But I need more help. Right now I have 2 seperate functions. One removes the extra spacing and the other removes double quotes. Then I have update queries for both functions. It does what I want seperately but I want to combine these 2 functions into one. I...

double quotes and extra spacing can be anywhere in the string. I am using Access 2000. Comments field might look like this 1. "Arrived at Site", "Departed from Site" 2. "CONTACTED ATCT TZ AND TOOK LOCAL CONTROL OF THE SYSTEM, Performed Weekly PM, on SYSTEM/FA999 per CONTACTED ATCT...

Thanx for replying fuzzygeek and llkhoutx I looked at Raskew's function but I am not sure how I would use it to remove double quote and extra spacing. I am not very good with coding. I would really appreciate if you can guide me a little more. llkhoutx, where can I get this program called...

Hi All: I have a table "tblComments". This table has a field called "Comments". I want to remove quotes and any extra spacing in this field. For example data in this field might look like this. "ALSF/SSALR CERTIFIED" I want to remove the quotes and the extra spacing so that it looks like this...

Thanks for replying Pat. You are absoultely correct, I made the changes that you told me to do. But I still can't figure out how to delete a document from the list box. I would appreciated it if you could help me with that. Thanks again, Ekta

Hi: I have alist box that displays a list of documents added by the user. As soon as the user click on a document listed, it opens it. Right now I don't have a delete button to allow the user to delete a document. I was thinkin of adding 2 navigation buttons that would let the users move up and...

Here you go... Ekta

Thanx AncientOne: Works purrrrfect...:D Ekta

AncientOne: Sorry, didn't see that :p. I have another problem. I added my expressions in qryAllColumn. But now if I go to the search form and search for any string using "Any Words", I din't set it up for other search options, it gives me an error Error #3079: The specified field...

Thanx for your help and time AncientOne. I have one extra column "Capabilities" in qryPot. I am not sure as to how I should add it using a further query. Ekta

Thanx so much.

Hello AncientOne: I have created the two queries using left outer joins. How do I create a union query to display all the rows from the data tables, including the nulls from both sides? Thanx Ekta

Thanx AncientOne: It makes sense. I will try it. Thanx Ekta

Hello: I need some suggestion on document linking. I want to link documents to my form. Every record can have one or multiple documents associated with it. These documents can be Word, Excel, PowerPoint, pdf..etc. Users should be able to link to these documents to the reocrd and also open them...

Hi Brian: Thanx for taking the time to look at it and replying..:) You are right. Previously I had 2 search engines- one for Potential Partner table and the other for BusinessOpportunity. It worked great. But now the managers here don't want to seperate search engines. They want a general...

Anyone????

Thanx for replying jeremie. I think you misunderstood me. I want to return data for the records without a match in the other table. I am attaching my db. The search form that opens up. There you enter MASS. It is a opportunity but it wont find it because it does not have a match in the other...