I'm finding that this is a line break issue, and have set the following:
Can Grow
Enter Key Behavior = New Line in Field
This has not changed anything.
It appears to me that the text box properties need to be changed to allow line breaks, or whatever indicates a linebreak from the source is incompatable.
If the data is pasted to other office programs, it seems to work correctly, although I cannot...
dkotula
Last Activity: Dec 21 '09, 07:16 PM
Joined: Feb 20 '09
Location:
-
See attached screen shot....Leave a comment:
-
Nope, spoke too soon, just replaced it by a vertical lineLeave a comment:
-
Wow, changed the font to Txt and it works correctly.
Dave :)Leave a comment:
-
Same thing when I paste here. See below:
VALVE STEM 316L - 1/4"
MATERIAL: SA479-316L
FINISH: < 15 MICROINCHES RA ON ALL SURFACES
Font in word shows up as Calibri (Body)Leave a comment:
-
Thank you for the code above.
Strange, but if I copy the complete line from access, and paste it into word, the ? mark is gone and recognizing it as a new line. My guess is that access is placing the question mark in the fields. Do I need to change the properties for the textbox to allow additional lines in my form?Leave a comment:
-
Text box question
Hello,
Is there a way that whenever a certain symbol appears, to strip the symbol and have the line following the symbol move down to the next line in my text box.
Even if I can get the line to move down without removing the symbol would be fine.
I cannot paste the symbol on here, but it is a question mark inside a box. The symbol is coming from a Progress database I'm linking my tables to.
This... -
know what I want to achieve, just don't know how to get there.Leave a comment:
-
Could I just have qryVendor execute after update of cboRel, and have a criteria set in the query on VendorNum field. The only problem is I don't know how to push the results to the fields in the subform, and match the field name of the query with the name of the field in the subform.
Like:
qryVendor.Name = frmVendor.txtNa me
qryVendor.Addre ss1 = frmVendor.txtAd dress1
qryVendor.Addre ss2 = frmVendor.txtAd dress2...Leave a comment:
-
Thank you for your replies, and I'm sorry for confusing you all.
The cascading combo boxes are used to get a unique PO number.
example:
12345-1-1
12345-1-2
12345-2-1
12345-2-2
Each one of these would be a record ID.
I have tables that link to ODBC progress DB.
I have created queries, to get data from the linked tables, and set some criteria to reduce the number of records queried....Leave a comment:
-
Wouldn't I need something like this in a SQL statement:
Code:SELECT "qryVendor.VendorNum,qryVendor.Name, qryVendor.Address1, qryVendor.Address2, qryVendor.Address3" FROM qryVendor _ WHERE ((qryVendor.VendorNum) = Forms!frmPO!txtVendorNum) _ Order BY qryVendor.VendorNum
Leave a comment:
-
I applied this based on what you provided, and recieved a sytax error INSERT INTO statement.
I'm sorry as I'm not real proficient at this.Code:Dim strSQL As String strSQL = "INSERT INTO tblVendor (Name, Address1, Address2, Address3" _ & "Values (" & txtVendorNum & ")" DoCmd.RunSQL strSQL
DaveLeave a comment:
-
ChipR,
I have the contents of the main form working, I select PO, then Line, and then Release, and "txtVendorN um and txtJobNum" get populated. Like txtVendorNum on the main form, I have txtVendorNum on the subform "frmVendor" and would like the corresponding record associated with the Vendor number to populate the rest of the fields from qryVendor. I'm not real concerned with the way my main form functions as it is doing...Leave a comment:
-
Yes, this is still in the building stage, and may require me to add additional fields for manual entry in addition to the data I get from my queries.
I attached the DB so you can get a better idea of what I'm trying to achieve. I do relize that the linked tables won't work for you, but you can see the structure.Leave a comment:
-
Thank you for the reply.
I regards to the combo boxes, I have them disabled, and each one is enable as the selections are made. cboPo is enabled, and cboLine, and cboRel are disabled. When someone makes a selection in cboPO, the cboLine is enabled. Then when a selection is made in cboLine, cboRel is enabled.
If I have the subforms bound to my tables, is there any reason I can't add additional fields to the table, and subform...Leave a comment:
-
I'm trying to achieve this in the after update event of the last combo box. I would also like to add additional fields to my tables, and form as I construct this. If possible I would like to keep the data seperated as I will probably link the tables together and have other forms with different functions like reporting or searching.
Could you provide me with a little tidbit of the DoCmd.RunSQL to get me on my way.
Here is what I'm using...Leave a comment:
-
I have three tables thus far, that the form saves to based on selections made from a query. Main form is gets the PO#, Line#, Rel#, Job#, and Vendor# from qryPORel and saves to tblPONum. I achieve this by making a selection from the three cascading combo boxes that have a Row source pointing to qryPORel.
Subform frmVendor has a table "tblVendor that I want to save to, but I would like to get data from qryVendor. The main form...Leave a comment:
-
ChipR:
In the subform, could I do something like txtJobNum on dirty to query based on information in txtJobNum?Leave a comment:
-
You are correct in saying filter from txtJobNum. My subform is already bound to tblPart, and gets the record from qryPart. The form and subforms are set to data entry. I'm trying to pull down records from the queries, and save to a table.Leave a comment:
-
Help with DLookup
Hello,
I have a DB with linked tables to ODBC, and queries based on them. I have a form with 3 cascading combo boxes and tabs containing subforms. Along with the combo boxes on the main form I have a txtJobNum, and a txtVendorNum. The subforms I have, are Job and Vendor. In subform Job, I have txtJobNum, and in subform Vendor I have txtVendorNum. What I did was use columns from the last combo box to populate txtJobNum and txtVendorNum on...
No activity results to display
Leave a comment: