Wow, all I can say is thank you thank you thank you. Am I really that stupid?! I've been braking my head on this for a couple of weeks now. You're the best.
Eli
emandel
Last Activity: Jul 8 '13, 02:02 AM
Joined: Dec 27 '06
Location:
-
Hello and thank you for helping out.
The report properties:
Record source: qryDonationRepo rt
filter - blank
filter on load: no
order by: blank
Order by on load: no
There is no line for Allow filters
The sql from the qryDonationRepo rt is below
...Code:SELECT Doners.ID, Doners.Title , Doners.[First Name], Doners.[Last Name] , Doners.Address, Doners.City
Leave a comment:
-
The report looks good, but has the wrong record. Where can I find the code that will dictate which record is used for the report?Leave a comment:
-
help with script
I have a form in a MS Access 2003 database.
Each time I get a donation, I'm supposed to hit the button that says "Create Receipt". After that, I'm supposed to hit the button that says "Print Receipt" and it's supposed to give me a receipt of the most recent donation(s) i.e. of donations that were not yet receipted.
The "create Receipt" button and script is working well. However when I...Last edited by zmbd; Jul 7 '13, 06:14 PM. Reason: [z{Added required code tags}{inserted picture inline} - made no attempt at formatting.] -
Ok correction, the control on the form is donations_id.
I am not getting the results I want, it is giving me a syntax error. Perhaps the report isn't right. Right now the report gives me all of the records. How do I limit the report to give me just one record, and then how do I get it to open that report to the record I want from the button.Leave a comment:
-
DoCmd.OpenRepor t "your report name",,,"ID = " & ID_Field
my report is called "Donations"
The primary key is indeed called id in the table "donations"
would it then me rewritten as follows?
DoCmd.OpenRepor t "donations",,," ID = " & IDLeave a comment:
-
Create a receipt as a report for one entry
Hello
Using MS Access 2003.
So I have a form where I enter donations which are attached to donors.
I would like to hit a button on that form that will generate a report which would essentially be a receipt for that donation.
I need help with the following.
1) how do I make the report applicable for only that one entry.
2) How do I attach the button that will take me to that report.... -
Is there anyway to do it within the table view itself and not go to the code side of things. The "r" was just one example. I want to be able to select a bunch of records and change the data in one field in all of those records all at once.Leave a comment:
-
OK fair enough.
so lets say I have a list of people and I selected all of the people whose name begins with the letter R and I used that list for something, lets say I printed a letter to them. I now want to flag all of them, so I created a new yes/no field and I want to "check" off all 150 of the records that are applicable. Is there any way for me to do that without going to each record and selecting them individually?...Leave a comment:
-
how to "fill data series" in Access?
In excel, I am able to select a whole bunch of cells in one column and copy the data from one cell to the lot of them. Is it possible to do this in access? Is it possible to enter the same date to many fields at once? -
When I import (?) data into word through a mail merge, how do I keep format
So I am importing data from a query into MS word for a mail merge, and one of the fields is a $ amount. In Access it is formatted properly as a currency and shows up fine on the screen (e.g. $24,000), but in MS Word, when I run the merge (or preview it) it comes out without the $ and with out the comma (e.g. 24000).
Please help -
sorry for bumping back up, but I am still very unclear as to how to do this....Leave a comment:
-
"which uses the ID of the current record in its WHERE clause" can you explain this sentence? I am not understanding it.
Thanks....Leave a comment:
-
How do I create a single form letter for individual data
OK I am an amateur and your patience is appreciated.
I have a database of Donors with their donations. I want to create a button (macro <?>)on my donation form that will automatically open a document in MS Word that will thank the donor for that specific donation. So this is something that I will do as the donation comes in. one donation in, one letter sent. The key is that I don't want a new query (e.g. query all donations... -
Is that true even if I create another query based on that query? or isn't there a way to create a new table from a query?...Leave a comment:
-
Question about Union Query
Is there any way to allow me to edit information in a union query? In other words can I update information from within this query? For some reason it doesn allow me to change any information in the datasheet view of the query.
[HTML]SELECT [Last Name], [First Name], [e-mail]
FROM [From Old List]
WHERE [E-MAIL] is not null
UNION SELECT [Last Name], [First name], [e-mail]
FROM [participants]
... -
I am interested in it returning only one record even if it's only the e-mail that is identical. I only want to send one e-mail out even if there are 2 unique people listed sharing that e-mail. Thanx...Leave a comment:
-
query to include an entry only once (omit second occurance)
I have a query which is giving me [first name] [last name] and [e-mail]
This is a Union Query and therefor some records are repeated. In addition some households have differant members wusing the same e-mail. How do I make a second query to show me all of the data from the first query but to OMIT the second entry when an e-mail is repeated?
Thak you! -
OK, i wasn't lazy and I did some more research. I got this:
but I really don't know much about sql,Code:SELECT [Last Name], [First Name], [e-mail] FROM [From Old List] WHERE [E-MAIL] is not null UNION SELECT [Last Name], [First name], [e-mail] FROM [participants] WHERE [E-MAIL] is not null ORDER BY [last name];
How do I add a line that will only give me DISTINCT records?...Leave a comment:
-
Query from two tables
I need to get information out of 2 tables and could use some help.
Say i have 2 tables "staff" & "customers" they each have fields "first_name " "last_name" "e-mail"
I would like to create a query that gives me a combined list of everyone's first name last name and e-mail. So that I can do a mail merge and send a common e-mail to everyone.
(do I need to create...
No activity results to display
Leave a comment: