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
Hi,
I'm designing a database in which the primary key is a combination of the first letter of first name, the first letter of last name and the date of birth.
How can I do that?
Regards,
CS
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?
Is there any way to leave a trail or history everytime a record is changed? We have kids in our database that sometimes go to follow-along when our service will not work for them at the present time. These kids go in and out sometimes several times. Since there is no absolute way of knowing, we have to create a new record everytime they come back to our service. I would like to be able to see a history of status changes along with some dates. Is there anyway to do this? If anyone knows, let me know. If not, oh well. Thanks guys.
View 6 Replies View RelatedDear All:
I have created a print command button on a form. When this button is pressed, It should print a Word document.
I have composed this document in Word already.
Any ideas on how to do this?
Many thanks in advance,
Dion
Dear all:
Code:
Private Sub Command167_Click()
On Error GoTo Err_Command167_Click
Dim objWordApp As Object
Dim objWordDoc As Object
Set oApp = CreateObject("Word.Application")
'make word not show up to user
objWordApp.Visible = False
set objWordDoc = objWordApp.Documents.Open(C:Documents and SettingsUserDesktopEXPRESS DIPLOMA LETTER.doc)
objWordDoc.PrintOut
'quits word
objWordApp.Quit
Set objWordDoc = Nothing
Set objWordApp = Nothing
Exit_Command167_Click:
Exit Sub
Err_Command167_Click:
MsgBox Err.Description
Resume Exit_Command167_Click
End Sub
I am trying to print a letter from access when a comand butting is pressed. It returns syntax error on this line:set objWordDoc = objWordApp.Documents.Open(C:Documents and SettingsUserDesktopEXPRESS DIPLOMA LETTER.doc)
HELP!!!
Many thanks,
Dion
I have a table with one field set as a hyperlink. I have to generate the hyperlink according to what else is going on in the record, I do this by assembling a text string which I can write to a text field in the same record. I have no problem doing this but when I try to copy that string into the Hyperlink field I get type mismatch. Incidentally if I put two text boxes on a form and bind one to the text and one to the hyperlink field the I can 'cut and paste' it OK so how come I can't do it with Access basic?
Dim stGunlib As String
Dim stGunlib2 As String
stGunlib2 = [Stock number]
stGunlib = "www.shooting.uk.com/Gunlibrary/" + stGunlib2 + ".jpg"
[Link] = stGunlib
[Picture] = stGunlib ([Picture] is a hyperlink field) it goes wrong here
I am using Access 2002
Thanks Dennis
I want to know if it is possible to generate reports in writable PDF format? Also, is it possible to send the report automatically to a list of emails recorded in the Access db using Outlook?
View 1 Replies View Relatedis it possible to extract the first letter of a surname in an Access Query? Below is my sample data, and below that is what I want to acheive.
Player Name
Hart, Joe
Cech, Petr
de Gea, David
Szczesny, Wojciech
Mignolet, Simon
Reina, Pepe
Lloris, Hugo
Howard, Tim
Begovic, Asmir
What I want the query to return:
Player Name
Hart, J
Cech, P
de Gea, D
Szczesny, W
Mignolet, S
Reina, P
Lloris, H
Howard, T
Begovic, A
I've inherited a few Access DB monstrosities. One of which had ODBC credentials hard coded in the MDE which I had to recently update due to some server updates. I found an unsplit version of the Access DB on a development drive (j:db...) and updated the credentials hard coded in VB and updated the linked tables from the J drive path (dev) to the K drive path (prod). I then split the DB and the MDE worked fine for me. I quickly found out that it only works fine because I had J mapped still. End users do not have the J drive mapped (development) only the K (production). Without the J drive mapped to the actual dev path the Access DB simply doesn't load. No errors.
I then tried to find any references to J in VB and fix those. At this point I can't seem to find anything else that could be referencing the J drive but still the DB will not open without J mapped.
I am using an MS Access 2010 table as a data source for a mail merge. I would like to update a field in the table with the date that the letter is printed. Is there a way to do this?
View 5 Replies View Relatedhow to generate a Report through "Form".I should be able to input the date ex: text box1= Start Date and text box2 should be End Date, by Clicking a button ...i.e Generate Report Button, a report should generate should be generated showing data in between the Start Date and End Date.
View 3 Replies View Relatedhi,
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!
hi,
I have a table that has results from races, eg.
Race No, Racer ID, Time taken.
i want to have a position field that will say which position the runner finished in. This is complecated as there are many different races.
At the moment the best thing ive been able to do is set up a query with a parameter on the race no. then the time taken is put in order and i have to manually put in the positions.
Manual is bad!
does any one have any idea about how i could make this automatic.
Thanx,
MAtt
So I've read a good 100 postings or so so far on the subject of how generating a unique identifier through any other means than an autonumber can be dangerous. But I can't resist the opportunity to simply ask if there is a way to make this possible, if only through a calculated field...
In my single user database, I have an employment table with an autonumber [EmploymentID] field as its primary key. The employment table exists in a one-to-many relationship with it's child, the income table where each form of income is recorded as it is recieved so that one form of employment (or employer) can produce many unique forms of income (like weekly paycheques).
I would like to be able to generate an identifier for the income table that is a combination of the parent [EmploymentID] field and an increasing number to produce something that looks like this:
1006789-001 -|
1006789-002 -|--> Same EmploymentID
1006789-003 -|
1006790-001 ----> New EmploymentID with a reset numeric
Any ideas?
~Chad
I have three fields, One called Key, one called IS and one called BC. I want the table to automatically copy the number from the IS field to the Key field to be used as the primary key. However, this field does not always have a value, when this occurs I want it to take the value from the BC field. Is this possible?
View 3 Replies View RelatedHey yall,
Here's one to stump the band.
I must find a way to generate multiple records that consist of a ticket number as one field, and whether they have been used or not as another. The ticket numbers need to be sequential, with an increase in value of 1 over each previous record.
The ticket numbers will be seven digits long. Users, or their supervisors, must be able to generate a block of ticket numbers, by designating the first and last number, and thus they decide both the ticket number value range, and the number of ticket numbers to be generated at the time.
The difference between the first and last number might be a key to record generation, but then, can you use that to tell the system to add a specific number of records? And, other than appending pre-existing records,can you command the generation of records at all?
Thanks for any answers on this.
I am trying to copy a field multiple times based on a number in an unbound field on a form. As well attach a consecutive number base on the number enter in the unbound text box.
Like this
[Table1] . [Field 1]
A70-3886-01
A70-7003-01
copy this many times unbound text box on form in to 3
[table2] . [Field1]
Spool Number
A70-3886-01-01
A70-3886-01-02
A70-3886-01-03
A70-7003-01-01
A70-7003-01-02
A70-7003-01-03
I dont know what to call my problem but it's not much for experts, but too much for noobs like me. I've been trying to generate a random output in one of my forms which will get it's data from one of the tables that i made (Ex. frmForm1 will generate random data from Table1, and the fields are "Name", "Age", "Sex", etc.).. i've tried doing Randomize but it doesn't work. Pls advice, and thanks to whoever will give solution to this..
View 3 Replies View Relatedhaving 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
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.
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
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 1 Replies View RelatedI 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
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!
Anyone have have any suggestions on how to create personlised job numbers instead of relying on auto numbers?
At the moment I have to freetype them in when creating a record & I would like to work out how to automatically generate them.
maybe something like
1030:101
1030:102
1030:103
1030:104......and so on.
Any suggestions would be much appreciated
thanks. :)