Need To Create A Form Letter....
I need to add a basic button on a form that would populate the current on-screen data in a form letter. The fields I have are name, address, city state zip and amount. I currently have the basic buttons on my form - Search, Next, Previous,Add, Delete Print Current Record.
Thanks in advance for your assistance.
View Complete Forum Thread with Replies
Related Forum Messages:
Letter By Letter Search Through A Table
ok here is what i want.. imagine a search box, just an empty text box that allows the user to type things into it... there will be a simple table from the database behind it, here is the typical structure of a record <Country>Poland <Price1>60 <Price2>85 <Price3>95 in this table there will be say a 1000 of these records... my user is going to have to quickly search through these records while on the phone to a customer, and quote one of the relevant prices associated with that country what i would like is this most convenient system.. as the user types in the letter 'P' just below all the records with countries that begin with 'P' are displayed (with a scroll down arrow if needed)..as well as the 3 relevant prices with that record if they then type an 'O' into the box (which will now hold 'Po') all the records with countries beginin with 'Po' will be displayed (eg Poland) if they delete the 'o'. once again the displayed records below the box will return to just the countries begginin with 'p' all that is needed is for the records to be displayed, thats it.. but the adding and deleting of the letters within the text search box will need to instantly manipulate this list.. i have posted on other forums, and have been told this can be acheived in access, is it hard?
View Replies !
Form Letter Ideas
I want to pick everyone's brain on this one, because I'm not sure what I want to do can be done very easily. I have a database that tracks client information for insurance policies. I'm going to be giving it to other agents, many who are very computer illiterate. One of the requested functions is for them to be able to create form letters from the database. So, I'd like some ideas on how to do that. Ideally, I'd like for there to be a form that someone could load some letter templates, but also tweak them or even create new ones that can be saved. It would also need to have "merge fields" much like you would in Microsoft Word. Basically since every agent will want to have their own letters, it needs to be easily editable. Is there an easy way for a computer illiterate person to just select "interest letter," change some wording, and have it merge into a report? Or, is there an easy way for someone to get access to the merge fields if they were to do a Word mail merge? I don't really want people trying to find the right tables/queries amidst all the different tables in the database. Or, throw out some other ideas. I'm open for most anything. Thanks in advance.
View Replies !
Report/letter Based On Info On Current Form
I have a booking form comprising of a main form which holds the person details, and a sub form which holds the details of each course they book. I want to be able to produce a report/ letter from the current form (ie once a person has made a booking) confirming that the booking has been made and giving a print of the details. How I can produce a report based on just the current booking information just entered in the form? Can anyone please give me some advice on this one, I know how to produce general reports but cannot see how to link one to a current form's data? Regards Peter
View Replies !
Letter Help
hi, Im creating a letter. It is based on a query. I have some details that I'd like to display , one on it's own line. I cant print them out now, but they dont all fall on their own separate lines. How should I do that? If I put a carriage control at the end of each detail line, will it know to print each of the fields on its own line? I need advice . I tried doing a subreport -type letter, but it looks weird! thanks!
View Replies !
Letter Feeding From DB
having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it? cheers
View Replies !
Starting Letter
I want a criteris in access to get the records having field 2 starting with "num". Num is example. I want to do withdifferent letters. number numbiur numg numds the first three letter should be num in this example. i want for different words i.e, i need to enter the paramter message box.
View Replies !
Letter And Query
Hi, I'm fairly new to Access. I have few questions. How to set up database so it searches through my table, finds the name and inputs it into letter in a space I want? Where does this letter suppose to be located in the file? Thank you IOI
View Replies !
Does Not Start With A Letter
Hi All:given a table with, let's say, Job Numbers that start with a letter (such as RES2345) or just plain numbers (such as 253180001 or 9817) how can I set the criteria in the query to just give me jobs that start with a number?I first trimmed the field to eliminate blank characters and then I used the Not Like "A - Z" but it still gives me jobs with letters at the beginning of the name.thanks for all your help in advance. :D
View Replies !
Display Only One Letter
I am trying to get the firstname to only display the first letter in a report. I have put this format in the control source =Left([firstname],1) When I run the report I get error in the firstname field. Any suggestion. Thanks
View Replies !
How Send The Letter
Hello all: In order to set up an multi-receiver email program with ASP/AccessDB, I downloaded “Beginners ASP mailing list program” “newsletter.zip” After unzipped it, it contains 11 files. I put them all in the wwwroot of IIS. I have made the address database “newsletter.mdb” successfully. The next step is to send letter. First using “newslettercreat.htm” to write a letter and then press “submit”. After submitting, it prompt a IE page with address “newlettercreat.asp”, but says: “The page cannot be displayed” and with following information: --------------------------------------------------- Technical Information (for support personnel) Error Type: Server object, ASP 0177 (0x800401F3) Invalid class string /newslettercreate.asp, line 22So, the letter can not be sent. What is the ERROR of “Server object, ASP 0177 (0x800401F3) Invalid class string” ? My OS is winXP pro, email program is Outlook Express. Who could help l me solve this problem? Thanks!
View Replies !
How To Create Users In Form
hey guys, i just needed a guide on how to create a form with different users in it. also, is there a way in which i can create a button that will open the wizard to create a report ?? [guess wat, no deadline.... but that doesn't mean dont answer ;) ] hope a reply soon.. thanks in advance.
View Replies !
Create Form From Wizard
During the create form from wizard process, there is a screen which gives the option of applying a style. Can this be bypassed or can a 'none' option be added.I'm new to access, so any suggestions are welcome. I think creating a form in design view will build with no syle, but how do you add fields?thanks
View Replies !
How To Create A Form As An Executable
hi everyone i'm super new at access. i think it's neat for now. i just made a form that people can use to insert information. we have a network drive here and it would be super cool to be able to convert the form into an Executeable file that way people can just click on the exe Icon and open up the form without having to go into access and then open the form. please let me know
View Replies !
Create A Chart On A Form
i have about 1500 records in my database and i want to display a bar chart for each record, i can tryed creating one but when i try adding the months it says i only can add 6 fields but i want to include each month not just 6 months in the chart, this is an on going database so in the future there will be more months added. here is the picture of the form i want to be able to show 2005 and 2006 figues in the same chart
View Replies !
Create Records From A Form
Can someone direct me as to the most efficient way to add records to a table from a form? I have a table of members and a table of invoices and want to automatically create an invoice for each member by clicking a button on a form. Is there a way to do this using a macro, query, or do I write it in VBA? Thanks much!
View Replies !
Create New Record With Form
How do I create a new record (in the table to which the form is bound) automatically if, when the form opens, there is no record in the table that meets the criteria in the form filter? Thanks!
View Replies !
Help- Create Search Form
hello, i know i have seen example from here, nome of them seems to help. My is just a simple search. i have 4 tables: Artist Name, title, country and location all i want is create a form that has a search. I want to type the artist name and it lists the country of the artist. How to i do this. I create the command button and text box but it just does not work. This is the code i use on the command. Quote: Private Sub ButtonSearchForRecords_Click() Dim StringQuery As String Dim StringWhere As String StringWhere = "" If Not (TextBoxSearchName = "") Then StringWhere = StringWhere & "AND [Name] = '" & TextBoxSearchName & "' " End If StringWhere = Right$(StringWhere, Abs(Len(StringWhere) - 4)) StringQuery = "SELECT [Name], [Title], [Country], [Location] " _ & "FROM [2-75TH SCAR] WHERE " & StringWhere _ & "ORDER BY [Name], [Country]" Me.ListBoxRecordsFoundInSearch = StringQuery Me.ListBoxRecordsFoundInSearch.Requery End Sub
View Replies !
Edit A Report Letter
i'm trying to work with this database. i want to know how to change a few things we have a command button that generates a letter i need to edit that letter as it contains names and numbers no longer in the office is there a way i could find that letter i tried to have sent to a .rtf file which i could modify, but that's tolerable for a dozen of recipient not 2 to 3 hundreds thanks
View Replies !
Generating A Letter From MS Access
I need to generate a pre-formatted letter from within MS Access, where the name, address and other information will be pulled from the current record on an Access Form. Basically it is like a welcome letter I could send to any new client I enter into the data base. Since I am doing one letter at the time, mail merge in MS Word is not an option What would be the easiest way to do this? Thanks
View Replies !
Letter Storage & Retrieval
I am not sure whether this is a problem with MS Access, Visual Basic or Windows. I have taken over supporting & developing an MS Access 2000 DB for a small charity & am not an Access expert or a programmer. The Application includes processing to create, amend & store retrieve standard letters based on a Word document called MyMerge.doc. The operating systems is Windows XP for the PCs with a MS Server 2003. Each letter is allocated a number ‘CallID’ which is used to retrieve the letters later. The letter text is in MessageC. The VB code to store the letters (Save As) is Dim strTest As String, db As DAO.Database Dim td As DAO.TableDef Set db = CurrentDb For Each td In db.TableDefs If Len(td.Connect) > 0 Then MessageE = Mid(Left(td.Connect, InStrRev(td.Connect, "") - 1), 11) GoTo jumpout Next jumpout: MessageC = "%fa" & MessageE & "Db Letters" & MessageC & " " & (CStr(Forms!Contacts![PostalCode])) & " " & Trim(DLookup("[TitleType]", "Title Types", "[TitleTypeID] = Forms!Contacts![TitleTypeID]") & " " & Forms!Contacts![FirstName] & " " & Forms!Contacts![LastName]) objWord.Application.Activate SendKeys MessageC The VB code to retrieve the letters is Dim MessageE As String, db As DAO.Database Dim td As DAO.TableDef Set db = CurrentDb For Each td In db.TableDefs If Len(td.Connect) > 0 Then MessageE = Mid(Left(td.Connect, InStrRev(td.Connect, "") - 1), 11) GoTo jumpout Next jumpout: Dim WordApp As Word.Application Set WordApp = CreateObject("Word.Application") WordApp.Visible = True WordApp.Application.Activate MessageE = "%fo" & MessageE & "Db Letters*" & CallID & "*.doc" SendKeys MessageE Set WordApp = Nothing GoTo Exit_Command53_Click The success rate varies from PC to PC and user to user. It will work with one letter and not the next. It is very difficult to identify a pattern. When the Save As does not offer the expected name & path, the Application (or operating system?) offers to save ‘MyMerge’ to the user’s My Documents folder. In that case I tell the users to correct the path themselves and save the document under the CallID. Theoretically, retrieval should work since this uses the CallID and wild cards. Sometimes it does but often it will instead retrieve a document in the user’s My Documents folder. If it does go to the right folder, you sometimes have to replace the last wild card with ‘.doc’. I have tried replacing the last wild card in the VB code with ‘.doc’ but this does not work! Finally, I alone get the message ‘Save failed due to out of memory or disk space’, neither of which is true. This makes it very difficult to continue investigating the problem. If I use a copy of the DB on my hard drive rather than the network I can save but not retrieve.
View Replies !
Query To Look At The 3rd Letter In A Field
Hi, anyone know if it possibe to create a field within a query that looks at a 3 letter number code in a field of a table named "employee master" to see if the last number is an "I" or not. So for example a number code in a field named "Department" is "KTI". I would like to display "indirect" in that field if it contains a "I" in the 3rd letter of the number. And display "direct" if the third letter is a "D" intstead, tried doing IF statements but not sure how to go about it, any help would be great.
View Replies !
Membership Renewal Letter.
Ok the database that i have contain all the details about customers including thier joining date. I want to make a query that will produce relevant information for use on a membership renewal letter, It should show only members due for renewal on 1st of may (there are 3 renewal dates per year. 1st jan , 1st may and 1st sept. I need to assume that the next renewal month of membership for those joining between those months will be the next renewal date. Example if you join in June your renewal date would be 1st september) Could you please explain how i could do this in easy to understand language as i am no expert with access. Thanks
View Replies !
|
TRACKER
