Search results

Sorry for not being very clear. So I have a text box with a large note in. Lets say the note is 850 characters, I want to transfer that into multiple text box's. The requirements are, each box can only hold 208 characters and each line in a box can only be 75 characters a line before it starts...

Ah I just tried that with a test form and works perfectly thank you, one more thing. The code I current use is This takes the box with the large note in and transfers it to dynamically made textboxes 208 characters at a time as this is the maximum limit per textbox for my requirements. How...

I'm struggling to find a solution to my problem. I have a box with a long note in, I want to click a button and transfer it to another box but in the second box I need each line to be 75 characters only. So every 75 characters there needs to be a new line. Any help is much appreciated Thanks

Good Evening all, I have a problem I'm hoping someone can help me with. I will try and keep this brief. I have a paragraph of text, I have to paste it into a system which allows me 75 characters in a line and 208 in a page. I have code which creates text boxes dynamically based on the total...

Thanks for the code, it worked really well. just another question how would I go about it if I wanted to expand on your solution and make it so there are 75 characters a line while still maintaining the 208 characters a box, any help would be appreciated. thanks

thanks for the fast response, I will try this solution tomorrow when I'm in work. It could come from a memo field, I didn't realise this could be done with this solution. Still quite new to VBA and access.

Hi all, I'm stuck. I have a textbox with about 400 characters, I also have 5 textboxes next to it. I want to click a button and I want to transfer the characters to the other textboxes 208 characters at a time. Any ideas ? Thanks

Hi, Thanks for the quick reply im using this in the control source in properties, this is tied to a textbox =DLookUp("[STAFF_AREA]","[RAW]","[REFERENCE_NUMBER]=[tbID]")

Hi everyone, I'm using a Dlookup in expression builder and it's only returning the value of the first record rather than the criteria I specify. Has anyone come across this issue before? Could someone give me an example of a dlookup. Thank you

("Staff Name: " + staffName + " Date: " + dateSend + " Call Time: " + callTime + " Reason: " + reason + " Expected Time Off: " + expectedTime) So that is my code above, this is the body of a email that im sending from vba excel it works just wanting to know how to enter paragraph...

oh its excel 2003

So i have my forms completed and my workbook done, now i want to make it so i just double click on the file and just my form shows not the spreadsheet, any ideas?

So far ive got Dim rw As Long, cl As Range staffName = TextBox8.Value rw = WorksheetFunction.Match(Me.ComboBox1.Value, Worksheets(staffName).Range("A16:A18"), 0) TextBox1 = Worksheets(staffName).Range("A" & rw).Offset(0, 1) TextBox2 = Worksheets(staffName).Range("A" &...

Range("C9").Select Range1 = Range(Selection, Selection.End(xlToRight)).Select Range2 = Range(Selection, Selection.End(xlDown)).Select Selection.Name = "tempSick" Range("A1").Select ListBox1.List = Range("tempSick").Value I was thinking about doing it this way ive...

just to explain the worksheet where it says sickness and has 2 dates. i want to pick one of those dates from the drop down on the form and when one of those dates is picked it fills in the rest of the text in the boxes depending on whats in the same row as the date picked hope tht helps

is photobucket ok to use?

Hey bob, Cheers for the fast reply I looked at those solutions, there looking at taking information from a form, im doing it from a row on a spreadsheet to a form

Hey everyone I have a for with a list of staff, on each row is the staff name, age, address and a few more details I also have a view staff form, on the for i have a drop down of staff names and a few blank text boxes, I want to be able to pick a staff name from the drop down and when this...

Private Sub CommandButton1_Click() Dim iRow As Long Dim ws As Worksheet staffName = AddAb.TextBox5 Sheets(staffName).Select iRow = 7 iRow = iRow + 1 'check for a part number If Trim(Me.TextBox1.Value) = "" Then Me.TextBox1.SetFocus MsgBox "Enter details" Exit Sub End If...