Vertical Text Direction/Orientation In CrossTab Query
Jan 7, 2007
I am fairly new to developing with Access.
I would really value some advice on changing text direction in crosstab query column labels.
I have just created a crosstab query to function as a training matrix. It has rather long column labels (there are good practical reasons for this), which makes the query very wide and difficult to print one one page.
Is there a way to change the text direction of the column headings so they are printed running up the page?
I know how to change text direction in Word or Excel, but not Access.
At the moment I am copying the query results into Excel and manipulating the text direction in Excel, but this is rather cumbersome.
How to Creating a Three-Level Navigation Form, First and second level must be in horizontal orientation, third level desirable be to vertical orientation and dependent of level 2.
I have a series of Unbound control boxes in one row. some text extend to two lines and I want everything to be centered both horizontally and vertically.
Can't figure out how to vertically align the contents of the controlb boxes...
I have a text label that I would like to have vertical instead of horizontal. In the properties box, I go to the other tab and set 'Vertical' to yes and the text rotates. Except it rotates 90 degrees clockwise. (The text starts at the upper right corner and reads down, you have to tilt your head to the right to read it.) This seems the wrong direction to me and to my office mate - all the tables we've seen with vertical text has the text rotated 90 degrees counterclockwise (text starting from the lower left corner and reads up, you have to tilt you head to the left to read it.)
Is there any way I can make the text rotate counterclockwise instead of clockwise? I really don't want to create many little graphics.
Not sure if this is possible but I have a few text boxes on a report set to vertical yes under properties. They print fine, but on the pre-printed forms I'm using they print upside down. Is there a way to realign they way the text prints when using the vertical yes setting? I really need they text to be inverted. I'm I asking an impossible question? Thanks..
This is almost a cross-forum post. I started a post in the reports forum to see if it were possible to sort/group the data by field values. Everyone knows this can be done row-by-row, but I was looking for a way to do it horizontally as well.
It should look something like that where the years are values of [year] field and the seasonal quarters are values of [quarter] field.
I have been searching for something that will help me do this when I ran across information on the "crosstab" query. This, in principal is what I am looking for BUT I am not dealing with numeric data here. Is there still a away to make a crosstab query/report with text fields where there would normally be numeric data?
I would like to know how to display or change the value in crosstab query to text instead of numbers. I understand that the value must be numeric. Is there another method?
I have a Volunteer Database that has teams. There is only one team leader but some of the teams have two or three assistants. Currently I have a query that lists all the assistants for each team vertically.What I want to do is list the Assistants horizontally under headings like Assistant 1; Assistant 2; and Assistant 3 for each team on one line.
FDL00.... should be generated automatically, starting with 101 for 1st container and 201 for 2nd and so forth. The output should be in vertical manner.
I work for a Local Council and trying to streamline the DA process a bit by using Access. I have two tables.
tbl_Conditions which has ConditionID(PKey) and ConditionDescription Fields.
tbl_DA has the field DA (PKey) followed by numerous conditions for simplification let's assume I have only five conditions each with there own field. SC363, SC449, SC106, S105, SC32.
For each DA in tbl_DA I go through and if condition SC363 applies I input SC363 if it does not apply I input NO. This is repeated for other conditions.
Everything above this point I have working like a charm. However from here on in I am seriously struggling been stuck for two days with no success!!
I would then like to create a new table ready for merging into word. The table would be the following
tbl_DAMerge would have fields DA (Pkey), SC1ConditionDescription, SC2ConditionDescription....., SC5ConditionDescription.
The condition descriptions would be coming from tbl_Conditions the description would only be inputted if the condition applied otherwise it would be left blank.
I have tried Dlookup, and update queries with multiple joins but it always comes back doing something random.
Hi all, I am utterly unsure if what I want to do is even possible:
I have two crosstab queries, qryRewCOCredit and qryWrapCOCredit which show the changeover (CO) times for the specified machine when they are NOT zero. (all zero entries don't show up).
There are many cases when there is a CO for the Rewinder on a specific day, but not for the Wrapper, and vice versa.
I want to make another crosstab query which performs a calculation. To keep it simple:
If (RewCOCredit>WrapCOCredit) Then 5-RewCOCredit Else 'WrapCOCredit>RewCOCredit 5-WrapCOCredit
Each day I produce reports from access and email then out using the snapshot viewer format. The majority of recipients open this find and the report is absolutely fine, however, when other recipients open the report it comes out all slanted and blurred. It almost looks like there snapshot viewer is squashing a landscape report into a portrait view. Does anyone know how to correct this, as its driving me mad trying to find an answer?
Is there any way to change orientation of report in report footer? I mean, I want to produce report header, detail etc in landscape and after detail I have given page break, at last page only report footer should be in portrait.
Basic user here,, I know I have seen what i am looking for on someone elses database but for the life of me I cant figure it out...
I would like for a field to open upon the click of a check box...
ie...
check box: [attrite], if I check the box I would like the field [date] to open in order for me to put a date in it. if the box is not checked the [date] field will not be seen.
is this simple? if it is code could you really explain on how to do it? Can it be done with a form or something different?
Not sure what this covers so if someone could point me in the right direction, so I can get started.
I want to do a search of customers through a button on a form with names, and there you get a list of customer that match your criteria. When you click or double click on that customer you get sent to the main form with all the customer details on it.
Hello there! Im currently trying to set up a database to hold customer information and how many "hours" they have left in thier account. With a form that you can sign up new customers and minus / add hours to exsisting customers accounts. To be hounst im not really sure where to begin, it will probley sound easy to most of you though :( !I have had previous access expirence whilst doing course work - thats it.Thank Yooh for reading - please help!!
We have a small business selling computer products and now we have a website to sell the products on. We have 3 main suppliers each with a few thousand products and currently I am using a macro (many infact) in excel to combine the current data files we get from each supplier into one file that gets uploaded to the website for import. However we would like to move the whole thing over to access to hopefully speed up the daily process of creating the file for upload. I get similar data from each supplier although obviously the columns arn't in the same order etc and one supplier has info that the others do not but what is the best way to set something up so that it pulls all the products in from each supplier and rearranges the data to fit what is wanted.
I haven't used access before but I have time to put into this to try and get it to work well.
I am new to this forum and Access databases in general, me and a colleague have been given the task of recreating our course brochure into an online searchable webpage. The web side of things I am ok with, its just the designing of the database that is causing us both endless problems.
Before I go into more detail about what it is that we need and showing the example Access database we have created so far, can I ask if I am posting this is the right section and secondly can I attach a database to a post?
I have a Department status report that each of our department uses to determine in which order to process our cabinets. Management would like to create a form based on this report, so that it is listed in the same order where the user could click a checkbox on each job that was completed. When finished this would update our history table with the checkbox date for the related department.
Report example
JobCode Run Lot SpecialColor Completed(unbound checkbox) GHHT A 131 Y Y HHTY Z 13 N FRBG F 23 Y Y
I created a datasheet form that shows this information. I added an unbound checkbox but if you check one, they all check. I want to able to select lot by lot. I guessing at that point I would need to create an update query that would update tblHistory and the correct department date with date() on the ones that were selected.
Not quite sure how to proceed with this one. The special color field makes a difference on where the date goes. For example if the Mill completes these jobs and it's a special color then the date would go to tblHistory.Assembly. If it's not a special color then the date would go to tblHistory.Prefinished. The primary key between the two is DelID.
Dont use access much but I have basic db dev. skills. That said, here's my dillema:
I have a front desk entry form fro service calls. There is a entry field for customerID. I would like to auto populate f_name, l_name etc... from just entering customerID. I know what I would do in an SQL situation, but how does that transfer over to access? Any help would be great. Thanks.
I am a novice user trying to set up a db for small business and am needing a little direction. Most of the company's sales come from the contracted work for remodeling homes; however a small amount of sales are over the counter sales within their showroom. How do I set up the db to track the following: customer info, contract sales amount & date & payments & balance due, labor costs by employee and sub contractor, materials costs, and net profit from contracted amount vs deductions of costs? Payments made are directly related to contracted sale and not labor or material costs; with the exception of the over the counter sales. My boss currently tracks the above info in an spreedsheet ... please advise. Any help will be greatly appreciated.
Does anyone know of an off the shelf application I can purchase to allow users access to my Access database over the web? I have select data I want to allow my customers access to dynamically via the web.
I am familiar with ASP however I am not at a level to develop something from the ground up.
I have access to a Windows Server, an established database and a great desire to get this done.
My vision is to have a daily upload of my back-end (for the sake of current data)to the web server for access via the ASP front end or whatever the case may be.
I am sure to all who read this you understand what I am looking for.
I will definitely entertain hiring someone to work with me on this project if need be. Best case scenario is someone has already done the work and I can just buy it...
I am trying to make something like custom bar chart on a form using rectangles. I made 4 rectangles (BarBZ, BarBA, BarKI and BarMA) and have the following code:
Code:
Dim PctBZ As Double Dim PctBA As Double Dim PctKI As Double Dim PctMA As Double PctBZ = Me.BZ / (Me.BZ + Me.BA + Me.KI + Me.MA)
[Code] ....
It works perfectly except... the rectangles grow/shrink downwards and not upwards. As a result the bars are aligned to top, while I would like to have them aligned to bottom.
:confused: I am trying to help someone with a complex problem (so it seems to me) but I will first ask about what should be a simple thing....
First goal: to COUNT the number of times a TYPE of visit is made. There are several different TYPEs but only interested in tracking 2 of them.
When a crosstab query is created - if one of the 2 parameters are not "met", a blank is returned. I have been reading posts about using NZ and IIf IsNull, etc to get past that - but none of them make any sense to me and the Access help suggestions do not work. Hope someone can make it clear with this information: (can't give more specifics to keep privacy intact)
The SQL was written by Access not by me. :)
Here is an example of the Crosstab SQL (which is using a previous query):
TRANSFORM Count([qryTest2.TYPE]) AS CountOfTYPE SELECT qryTest2.CID FROM qryTest2 GROUP BY qryTest2.CID PIVOT qryTest2.TYPE;
----------- qryTest2 SQL: (Grouping by to remove dups)
SELECT DISTINCTROW tblM.CID, tblM.[M#], tblM.LNAME, tblM.FNAME, tblM.YMDBIRTH, tblC.ClDOS, tblC.TYPE FROM tblM LEFT JOIN tblC ON tblM.[M#] = tblC.[M#] GROUP BY tblM.CID, tblM.[M#], tblM.LNAME, tblM.FNAME, tblM.YMDBIRTH, tblC.ClDOS, tblC.TYPE HAVING (((tblC.TYPE)="Out" Or (tblC.TYPE)="In")) ORDER BY tblM.CID, tblM.LNAME, tblM.FNAME;
