TextBox Text Direction
Jun 20, 2005Is there a way to set the text direction in the textbox to be vertical instead of horisental.
Or is it possible to rotate the text box to set it to be vertical instead of horisental.
Thanks
ADVERTISEMENT
Vertical Text Direction/Orientation In CrossTab Query
Jan 7, 2007I 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.
Thanks in anticipation of any help. :cool:
On Got Focus - Hover Over Text Box And Display Text In Another Textbox
Jun 18, 2014When I mouse over TEXTBOX1 I want it to display the phrase Hello World in TEXTBOX2.
When the Mouse moves away from TEXTBOX1 I want TEXTBOX2 to go back to normal.. (Empty)
How can I get the below VB to work? Or something similar.. I'm assuming a mouse move event or something
Code:
Private Sub TEXTBOX1_GotFocus()
Display Hello World in TEXTBOX2
End Sub
Code:
Private Sub TEXTBOX1_LostFocus()
Clear TEXTBOX2
End Sub
A Little Direction.....please
Oct 19, 2005Basic 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?
thanks for the help
Jake
A Point In The Right Direction Plz.
Nov 14, 2006Not 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.
thx
Damien
Someone Throw Me In The Right Direction!
Jun 9, 2007Hello 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!!
View 6 Replies View RelatedA Hint In The Right Direction.... Please :)
Nov 11, 2007We 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.
A Nudge In The Right Direction Please
Nov 21, 2007Hello,
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?
Many thanks
Need To Find A Direction
Sep 7, 2005I 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.
Point Me In The Right Direction
Sep 1, 2006Dont 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.
New Access User Needing Direction
Aug 24, 2005I 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.
Seeking Advice / Direction / Programmer
Dec 4, 2007Hello,
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...
Thanks.
Fen How
How Can I Limit Text In Textbox?
Oct 19, 2005How can i limit the user to enter the text in a textbox on a form?
suppose i want the user to enter only upto 20 chars in a textfield.
Adding Text Into A Textbox
Dec 20, 2005Hi
Is the following possible?
I have the code to add the text to a textbox, but what I would like to do is rather than to keep adding the text onto the end.
Make it so that it will add it before what I previously added, so that the newer data is always at the top.
Can I do this? The following is how I'm currently entering the data into the textbox:
If IsNull(Me.LastContact) Then
Me.LastContact = Me.List35.Value & " contacted " & Me.List38.Value & " by " & Me.cmboEngagement & " on " & Date & vbCrLf & _
txtInput.Value
Else
If Not IsNull(Me.LastContact) Then
Me.LastContact = Me.LastContact & vbCrLf & Me.txtInput.Value
End If
End If
Thanks
List Text In Textbox
Jan 3, 2006Hi
Quick question, how would you advise I do the following.
I have a form with an unbound textbox.
What I would like to do is create some sort of log in a textbox with the newest listed at the top.
I have a table with this information in that contains an ID, a memo field which lists the details, and a date field.
I would like to list all the details based on an ID, and with the newest details being the first listed.
How would I go about doing this?
Thanks
Text Hovering Over Textbox
May 25, 2006Hi
does anybody know how to get text to show over a textbox. until the user doesn't enter the text box it will show instructions or a label perhaps. i have seen it on some samples and now i can't seem to locate it. i think this is an easy one. i need to save space on a continues form. i would like to get rid of the lables.
thanks,
sam
Modules & VBA :: Value From Text Box Populates Other Textbox?
Aug 9, 2015Code:
Me.PHOTO = " & Me.text36 & " & Me.FILENAME & "" & Me.FILENAME & ".jpg"
tell me what I have to change in the " & Me.text36 & " part so that the value displays the value in text 36 and not the words me.text36
How To Input Text From Textbox Onto Table
Sep 19, 2011I have a table with a field named 'Comments'. On the form, I would like to have a text input and a command button. After the user enter the comments onto the textbox and subsequently click on the command button, the comments will be input onto the 'Comments' field of the table.
Q1. How can the text box be link to the 'Comments' field of the table?
Q2. Only after I press the command button then the input text on the text box will be transfer to the table. What is the command for that?
Enter Text As Bullet Points In A Textbox? Possible?
Apr 26, 2006I have a textbox called txtcomments on my form. It is bound to a table field defined as Memo. Now i normally would enter text and produce a report from the comments in my table.
I want to be able to enter text like this in my form, so that my report can be formatted like this: All in one textbox (memo table field).
Like this:
*************in my txtbox************************
Accomplishments
Etc
Etc
Etc
Current / Upcoming Work
Etc
Etc
Etc
Risks / Challenges
Etc
Etc
Etc
***************end of txtbox***********
Is this possible? If not, how do you think i can achieve this? I am open to suggestions, please help :D
Using A Checkbox To Return Text Based On Another Textbox
Apr 26, 2005Dear All:
I have a form with three items:a checkbox called "Check231", a textbox called "text921" and another textbox called "text762".
What I wish to do is: Enter text in textbox921, which stays the same as I scroll through each record. Then If checkbox check231 is checked, it displays text from textbox921 to textbox762. Textbox762 is bounded to the form.
Any ideas on how to get started?
Many thanks,
Dion
Forms :: Convert Certain Text From Textbox To Uppercase?
Jul 24, 2014I've got an address box on my form. When someone enters 'London' inside the box, I want only 'london' to be changed to all-caps.
View 5 Replies View RelatedForms :: Checkbox Be Visible Only If A Textbox Has Text In It
Jun 12, 2014I would like to have a checkbox be visible only if a textbox (Text246) has text in it.
Code:
Private Sub Text246_AfterUpdate()
Me.Check275.Visible = Text246
End Sub
Forms :: Textbox On Form Not Separating Out The Text?
Jul 18, 2013I have a textbox on a form that i am pulling off of a table. the table stores the infor as listed below
customer ordernumber order description
Jeff 123 -abc
-def
-ghi
Bill 456 -ghy
-hig
but when i bring the field into a form it lists it out the field of order description as below in a textbox, i used textbox b/c the the text can be pretty long
-abc-def-ghi
how can i make it so that it separates out the listing as i have it on the table?
Forms :: Fill Textbox With Text If It Is Null?
Jul 3, 2014I am trying to use this expression in my textbox to show when the textbox value is null:
=IIf(IsNull([ContractStatus]),"Null",[ContractStatus])
It gives me a circular reference error (#error in the textbox). If I change it to this:
=IIf(IsNull([ContractStatus]),"Null","ContractStatus"), it will display the text "Contract Status" (obviously).
What am I overlooking here? Does this need to be done in VBA?
Text In Textbox Repeats Itself In Multiple Fields?
Jun 20, 2012I am building a database through access 2003 and have included a text box labeled "comments" in my design view. Now when i go to input information in the "comments" column in the datasheet view, the same text will appear for every entry. If I try to change the text in the next row, it will automatically switch all of the previous "comment" text to whatever I have entered. How do I fix this?
View 13 Replies View RelatedAccess 2013 Web App - Copy All Text To One Textbox?
Feb 11, 2014I need to copy all text from all textbox to one text box.
View 14 Replies View Related