report like spreadsheet
Wed, 8 Oct 2008 11:33:01 -0400
How do I make this table of data:
MerchName......VendorSku......UPC.............Price
Merch1............vSku1............UPC1............Merch1Price
Merch1............vSku2............UPC2............Merch1Price
Merch1............vSku3............UPC3............Merch1Price
Merch1............vSku4............ ...
|
Batch Print - repost
Wed, 8 Oct 2008 09:17:57 -0400
Sorry for the repost. I realize -- and appreciate -- that you all donate
your time in answering questions in this forum and maybe just couldn't get
to mine. I wanted to be sure, however, that my original post had been clear
enough or that what I was trying to do was simply not possible in an Access
report.
re ...
|
Deleting Large mounts of duplicate data
Wed, 08 Oct 2008 13:13:16 GMT
I have 26,000 names and 2,000 are duplicates. I needs to delete the names
with duplicate social security numbers. I know I would set up a delete query,
but I don't know what criteria to specify. Everytime I set up the delete
query, it will choose 5,000 names to delete opposed to the 2,000. How would I
narrow thi ...
|
VBA Code instead of Expression
Wed, 8 Oct 2008 09:09:29 -0400
In a Report TextBox, instead of this expression that Access 2003 declares as
"too complex":
=SWITCH(
[State]="AL";"ALABAMA";
[State]="AK";"ALASKA";
[State]="AZ";"ARIZONA";
[State]="AR";"ARKANSAS";
[State]="CA";"CALIFORNIA";
ETC.)
We would like to use VBA Code, for example:
Private Sub Report_Load()
...
|
how to change font size when field is too long
Wed, 8 Oct 2008 08:39:37 -0400
While printing name tags from names in a database, a name is occasionally
too long to fit the text box using the prefered font size. How can I sense
overflow and reduce the font size for this particular name tag?
Sam
...
|
Report Criteria
Wed, 8 Oct 2008 00:56:01 -0700
Hi All,
I ve a table name tbl_input containes fields:
InputID, Name, address, age, Nos_of_share_alloted, share_no_from, share_no_to
If a recors is
InputID = 1
Name = ABC
address = XYZ
age = 30
Nos_of_share_alloted = 5000
share_no_from = 1
share_no_to = 5000
Could ...
|
subreport totals on Main report
Tue, 7 Oct 2008 14:36:01 -0700
Hi I am having trouble with getting a grand total on my main report from the
totals on 3 subreports. I reviewed Allen Browne's article on "Bring the
total from a subreport back onto the main report". I still can't get
anything. I get #name error. Can someone please help me with this? Thank
you. ...
|
|
|
Report with disappearing subreports - null values
Tue, 7 Oct 2008 12:31:02 -0700
I have an unbound report containing two subreports of annual information. If
we fix one then I can apply the same method to the other.
I need the subreport to show data, with the following as an example:
BIRTHDAYS
Thursday April 1, 2008:
Mr. Bentley
Mrs. Smith
Mr. Zanders
Friday April 2, 2008:
Ms. P ...
|
report asking for a value to a field that i can't find used
Tue, 7 Oct 2008 15:21:19 -0400
every time i run this report, it starts by asking me for the value to
[ManufacturersName], not anywhere, not as a datasource, not in code..
nowhere...
any suggestions on where to look?
thanks in advance,
mark
...
|
subreport in group heading continuing on multiple pages.
Tue, 07 Oct 2008 19:21:23 GMT
I am creating a report which will print out check's. The report will be
printed on pre-printed check templates. The top half of the page is the
detail of the invoice numbers / values that make up the check amount. The
bottom 1/2 of the page is the actual check.
The problem i am having is that I have creat ...
|
