Multi-line text box - can't get it to work in Access 2003
Link Multi Text boxes
How do I link multi text boxes. I have 1 text box with a height of say 720, on text box #2 I type in a size say 120 in another text box will say whats left e.g 600. then when I click to the next box #3 and enter say 200 the box that said 600 changes to 400. and so on.
Coloured text within the same text box
Has anyone ever used VBA to enter text into a text box with sections of the text in different colours and return to the next line? for example.
On the enter date we went to look at a problem. When we arrived it was enter time. The problem was related to enter part description. I'm currently using access 2003.
Setting multi-line text field to have both scroll bars and no line wrap, how?
Access 2007 on Windows XP
I am not seeing a property setting to enable a horizontal scroll bar for a text field.
And also I need to disable the control from doing line wrap.
Basically I want Access to display the text as-is and do no reformatting.
I have set my font to a mono-space font, so that point is successfully covered
Hide report object if no value
In Access 2003/XP/2000/97, I've created a report. In my report, I want to hide a text box if it has no value. Currently, if the text box value is nothing, a blank line is printed in the report. Is there a way to not print blank lines if my text box has no value?
Multi-value Unbound Combo Box
I've read a few posts that state it is not possible to have an unbound multi-value combo box (Access 2007). Many of my bound forms have multi-value combo boxes, and I understand many programmers dislike them as they break some formatting standard rules (or so I've read). Anyway, I have no opposition to them since they work fine for the applications in which I've used them. Is it truth, myth, legend that they cannot be unbound? Is there a way to hardheadedly code this possibility into existence?
Let's see where this gets us
Values from list box into text box
I currently have a multi select list box named 'raisedby' on a form called 'create graph'. I am trying to get all the values that are selected in multi list box onto a report at on click event of my form.
What is the best way to do this? Could I put all the value into a text box on the report?
New line in memo box
I have a text box in a form that I want to feed into a memo box on the same form I am having trouble getting this to work in VBA. I imagine that the user would type their sentence or not in the text box and then click a button and it would appear in the memo with a time tamp and the sentence. if they did a new sentence and clicked again it would add to the memo on a new line and keep any old info.
Storing Multi-Line Text in Table
I would like to know how I can store multiple lines of text into a table cell. I have been told it's possible, by using '/n' to signify a new line, though it doesn't have seem to have worked.
I am using Visual C# so it may have something to do with that, though I have yet to find an answer.
Best Practices When Using Microsoft Office Access 2003 in a Multi-user Environment
Learn techniques you can use to improve the performance and efficiency of working with your multi-user Access applications.
This article looks at ways you can improve the way you work in a multi-user environment with Access applications. By utilizing some of these techniques, you can reduce the chance for errors and improve the performance of you databases.
Change the background color of a text box based on whether a value has been entered in Access 2003
Question: In Access 2003/XP/2000/97, how can I apply a conditional format on a text box? I want to change the background color to red from white when the text box has not been filled in (null value). How do I do this?
Multi Select List box - transfer to Multi Select List box
It is Friday, I am tired and someone out there has a simple way to do this.
Attached a Access database. It has two list boxes.
Highlight one item on the left - click the > button
and it transfers to the right list box. (and vica versa with the <)
What is needed to make this a Multi Select list box?
I would even accept a link to a working demo
Multiple Line Input Box
I have been searching online for this to no avail. I am trying to make an inputbox that can show more than one line of text. I have set up a button that when clicked, will send an e-mail to the e-mail address associated with the record.
2 input boxes show up. One for the subject line and one for the message itself. you can only see a limited amount of text and I would like it to show maybe 5 or 6 lines as the message will almost definitely span longer than the text field provided.
I don't want more than one text box on the input box to enter the message, just a larger one to view the whole message at once.
Run time 2465 Error with Multi select text box
I found an article and code sample I am trying to run: [LINK] . I am running access 2003 sp3 on windows 7.
Following the example provided I get an error when opening the form: Run time error 2465 - "Access can't find the field myselections referred to in your expression" . I have a text box per the example named mySelections on my form.
I have searched on found remedies ranging from reinstalling sp3, turning off name auto correct, and of course confirming the text box is named properly. I continue to get the error. Is thisa common error and are there any other suggestions for troubleshooting this?
Importing Multi-line CSV's into MS Access Table
I have been trying to import multi-line .CSV's into an access table. (I have attached sample .CSV data)
Looking at the attached .CSV a single record consists of a 200 and 300 line (ie rows 2 & 3 = 1 record - comma de-limited files), as per the attached file there are 3 records - first and last lines are not needed. I need to be able to code the loading of multiple files each day from a directory where the files will be located.
I have had some success with an add-on called import wizard v9, however the cost is rather high and I think there might be a simple enuff alternative
Windows can't open this file: xxxxx.mdb, choose from list ...?
Recently we upgraded office from office 2003 to 2010, except for now we left access at 2003.
The mdb file she gets the message in the subject line, and when she clicks 'choose from list' access 2003 is not on it, even though access 2003 is on the start menu list.
mdb files with access 2003, or any ideas how to find access through the 'open with.' dialog box? I navigated to c:\program files\microsoft office. but couldn't find access.
How to have Multi Choice Message Box
Forum, access 2000
I can't get my head around what to look for on this issue.
I want a display of Report Choices and which ever is clicked will be acted on.
For one report, simple MsgBox yes/no but 2 or three reports? to stack the message boxes would be painful to the operator.
How do you have a box appear that has multi choices?
Should have paid more attention to the lecturer 10 years ago!
I have a 850 page text book but of course, what to look for. MsgBox doesn't cover Options such as this
Conditional formatting in Access 2003/XP/2000/97
Question: In Access 2003/XP/2000/97, how can I apply a conditional format on a text box? I want to change the background color to blue when the text box has focus. How do I do this?
Multi-selection from list box to reports
I'm trying to adapt the code shown on this website [LINK] (code attached) to my database to enable me to send multiple selections from a list box to whichever report I chose to run. The report to be used is selected from a combo box.
The selection in this combo box goes to the code embedded in the click event on the button on the form. My problem seems to be that this code is designed to have the reportname embedded in the strDoc = "Products by Category" line.
I'd like to be able to have this line pointed at the combo box,
inserting table data from a Word document into an Access table
The Word 2003/2007 document(some files are in "docx" or Word 2007 and some are in "doc" Word 2003 format) has data as indicated below:
.some text on line 1 which is not needed.
.some text on line 2 which is not needed.
.some text on line 3 which is not needed.
Filter a query based on data entered in a text box
In Access 2003/XP/2000/97, I need to search for all Usernames containing 'ahm'. I want to create a form with a text box and a button. In the text box, I want to enter the search criteria and then click on the button to open the query displaying only the results where the Username field contains the value entered in the text box.
How can I do this?