Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Bind variable field to a text box
Started 1 month ago by ppataki
Dear All, I have a text box on a form, and what I would like to do is to bind not a fix field of the datasource (eg Result2004) to this control, but to bind a field that is a result of an expression eg. if the value of combo0 is 2004, then bind field Result2004 from the datasource, if the value of combo0 is 2005 then bind field Result2005 etc etc I tried ="result"&me.combo0, but I got a #...
Site: Access World Forums  Access World Forums - site profile
Forum: Forms  Forms - forum profile
Total authors: 606 authors
Total thread posts: 5 posts
Thread activity: 459 new posts during last week
Domain info for: access-programmers.co.uk

Other posts in this thread:

Simon_MT Registered User replied 3 months, 2 weeks ago
Are the tables linked to a Backend. I would use a Subreport in the Header from tblCompanyInfo and the Detail without a subreport. You could put Company into all your tables and create a Parent / Child relationship on the Subreport. Simon
Size: 255 bytes
Customize:  Customize "<b>Reply 1</b>: Reports are causing Access to crash :: Forms :: Access World Forums"

krellda Registered User replied 3 months, 2 weeks ago
I need to post to move this back up the forum. Would it be a case of making primary keys and linking them, and then making some kind of function, or macro or whatever to open the other form to the form of the same primary key? if so what function can do this?
Size: 276 bytes
Customize:  Customize "<b>Reply 2</b>: Opening a second form to the Same Record Number - Page 2 - Access World Forums :: Forms :: Access World Forums"

krellda Registered User replied 3 months, 2 weeks ago
I have figured out the solution to this problem. I feel i should post it here to help the other person involved. The simplest way to do this is to create a Field with unique information in my system it is 'Case Number' i fill in the case number which currently is just 1, 2, 3 and so on but when finalise everything i may use something more meaningful. Make this field on both tables and ...
Size: 1,261 bytes
Customize:  Customize "<b>Reply 3</b>: Opening a second form to the Same Record Number - Page 2 - Access World Forums :: Forms :: Access World Forums"

MayoRR5 Registered User replied 3 months, 2 weeks ago
Hi all, I'm having a problem with a "calculating text box". In the [Item_Total] box I have the control source "=[SumOfQuantity]*[Unit_Rate]" and [Unit_Rate] is a value that is calculated in the Query controlling the Report. All works fine to this point. Then I have a group header and report footer and have a Sum control in a text box in both the header and the footer (not linked). ...
Size: 704 bytes
Customize:  Customize "<b>Reply 4</b>: "Calculating Text Boxes" :: Forms :: Access World Forums"

MayoRR5 Registered User replied 3 months, 2 weeks ago
Thanks Neil!!! That worked. Any idea's why the SUM function just didn't work? Thanks again for the help. MayoRR5
Size: 256 bytes
Customize:  Customize "<b>Reply 5</b>: "Calculating Text Boxes" :: Forms :: Access World Forums"

timothyl Registered User replied 3 months, 2 weeks ago
lagbolt, thank you for the code that worked, alas I can't do what I had hoped, which was to take the transparent form and also hide the Access window and match the text boxes to the input form of a data system we use here and auto populate it with the data in access. I had hoped the data would "shine through". I thought I was being clever. But no I was'nt. Thanks again
Size: 385 bytes
Customize:  Customize "<b>Reply 6</b>: Transparent form with solid text :: Forms :: Access World Forums"

Atomic Shrimp Humanoid lifeform replied 3 months, 2 weeks ago
that's right - osk.exe
Size: 22 bytes
Customize:  Customize "<b>Reply 7</b>: Virtual Keyboard :: Forms :: Access World Forums"

Atomic Shrimp Humanoid lifeform replied 3 months, 2 weeks ago
For extra credit, see if you can work out how you would launch it without using the hardware keyboard or any helpful shortcuts... (i.e. if asked to assist in a case of broken keyboard)
Size: 201 bytes
Customize:  Customize "<b>Reply 8</b>: Virtual Keyboard :: Forms :: Access World Forums"

ashleybyrdnc Registered User replied 3 months, 2 weeks ago
I want to have a Form where a list of Sales Reps with a Check Box appear. If the check box is selected I would like a certain date and the rep name appended to a table. Any Ideas where to start?
Size: 215 bytes
Customize:  Customize "<b>Reply 9</b>: Query/Form Question :: Forms :: Access World Forums"

wiklendt replied 3 months, 2 weeks ago
Quote: Originally Posted by gemma-the-husky not sure how you are doing this but i do it like this have a "selected" flag in the table you are using base the left list, on a query selecting those items where selected=false base the right list, on a query selecting those items where selected=true all your "move" button ...
Size: 3,502 bytes
Customize:  Customize "<b>Reply 10</b>: more help with double listboxes for item transfer :: Forms :: Access World Forums"

 

Top contributing authors

Name
Posts
boblarson
228
user's latest post:
Refresh calculated field after...
Published (2009-12-14 15:50:00)
In the after update event of each of the controls you might be updating put: Me.Recalc
missinglinq
109
user's latest post:
Copy a partial record.
Published (2009-12-14 06:56:00)
Or, if you're not comfortable working with queries, you could just add a line or lines to the Wizard generated code to reset the values of the fields you don't want copied: DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append Me.Textbox1 = Null Me.Textbox2 = Null Me.Textbox3 = Null People say the...
John Big Booty
93
user's latest post:
IF STatement
Published (2009-12-11 17:44:00)
It may be because one of your controls has a space in it's name, try; Code: If Me. [ Amount Due ] .Value = 0 Then Me.Paid.Value = -1 End If
pbaldy
89
user's latest post:
Open form to specific record?
Published (2009-12-11 10:44:00)
You could use this technique: http://www.baldyweb.com/wherecondition.htm with a DMax to get the largest tracking number instead of getting the value from the form.
ajetrumpet
76
user's latest post:
Adding a table / subform into a...
Published (2009-12-14 11:38:00)
you're talking about an invoice here. you probably need to use a report for that. for help with the BOL though, you may need to upload the database, because it is very hard to gague what you actually need or what needs to be done just by seeing a picture.
wiklendt
44
user's latest post:
Adding multiple records onto a...
Published (2009-12-10 22:50:00)
Quote: Originally Posted by kyuball (I'm a pretty stupid dude...) I was hoping someone would be able to give me at least some hints as to how to approach this... i doubt very much if that were true. we'll sort it out, don't worry mate
RuralGuy
42
user's latest post:
Syntax Error 3075
Published (2009-12-12 09:39:00)
I put the last quote in the wrong location when I first posted. I have since edited the post moved it.
smig
37
user's latest post:
send value to a report, query
Published (2009-12-11 12:47:00)
I like using the registery for these task. I find it real easy to use. look for SaveSetting, GetSetting functions.
YNWA
36
user's latest post:
Relationships with combo boxes?
Published (2009-12-08 08:46:00)
Cheers, I do have a primary key in my dicipline field set to auto number. Then a text field with the disciplines in. Thats why I think it has to do with my tblStaff and the fldDiscipline within it. This is a text field and in my form, my form field cboDiscipline has 2 columns, Bound column = 2 and field sizes are 0cm;5cm. I think its just my relationship and field names in the 2 tables. I have a number of fields on my form which are combos...
DCrake
36
user's latest post:
Combo selection box 3 rows...
Published (2009-12-11 07:18:00)
If you have three fields and you only want to show 2 then Example: Columnwidths :0cm;3cm;3cm you choose which column to hide by setting it/them to zero David

Related threads on "Access World Forums":

Re-Bind a Combo-box by other in same datagrid  Access World Forums - site profile VB.NET - forum profile Re-Bind a Combo-box by other in same datagrid
Re-Bind a Combo-box by other in same datagrid
VBA to query with variable field names?  Access World Forums - site profile Modules & VBA - forum profile VBA to query with variable field names?
VBA to query with variable field names?
Setting the value of a variable field  Access World Forums - site profile General - forum profile Setting the value of a variable field
Setting the value of a variable field
Variable field lookup  Access World Forums - site profile Queries - forum profile Variable field lookup
Variable field lookup
Variable field name in query  Access World Forums - site profile Queries - forum profile Variable field name in query
Variable field name in query
Last modifed Field Box Populated Automaticallu  Access World Forums - site profile Forms - forum profile Last modifed Field Box Populated Automaticallu
Last modifed Field Box Populated Automaticallu
Changing field format based on variable value of another...  Access World Forums - site profile Forms - forum profile Changing field format based on variable value of another field
Changing field format based on variable value of another field
Textbox won't bind to table field  Access World Forums - site profile Forms - forum profile Textbox won't bind to table field
Textbox won't bind to table field
Text box query bind  Access World Forums - site profile Reports - forum profile Text box query bind
Text box query bind
Using a combo (value list) to open a form and use...  Access World Forums - site profile Forms - forum profile Using a combo (value list) to open a form and use variable to insert valueto a field
Using a combo (value list) to open a form and use variable to insert valueto a field

Related threads on other sites:

LOV Bind Variable field show/hide during runtime  www.oracle.com - site profile JDeveloper - forum profile LOV Bind Variable field show/hide during runtime
LOV Bind Variable field show/hide during runtime
Update a variable field from a text box value in...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Update a variable field from a text box value in microsoft.public.access
Update a variable field from a text box value in microsoft.public.access
Bind a text box to a different field / expression Access...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Bind a text box to a different field / expression Access 2007 in microsoft.public.access.reports
Bind a text box to a different field / expression Access 2007 in microsoft.public.access.reports
Bind a text box with an expression to a field in a table...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Bind a text box with an expression to a field in a table in microsoft.public.access.forms
Bind a text box with an expression to a field in a table in microsoft.public.access.forms
Bind a text box to a different field / expression Access...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Bind a text box to a different field / expression Access 2007
Bind a text box to a different field / expression Access 2007
Bind a text box with an expression to a field in a table  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Using Forms - forum profile Bind a text box with an expression to a field in a table
Bind a text box with an expression to a field in a table
ADF BC / view object editor / bind variable editor /...  www.oracle.com - site profile JDeveloper and OC4J 11g Technology Preview - forum profile ADF BC / view object editor / bind variable editor / Value edit field
ADF BC / view object editor / bind variable editor / Value edit field
How to assign :APP_USER Bind variable value to Database...  www.oracle.com - site profile Application Express - forum profile How to assign :APP_USER Bind variable value to Database Field
How to assign :APP_USER Bind variable value to Database Field
Community - Reporting on a Variable Field Comparison to...  Salesforce.com Community - site profile General Development - forum profile Community - Reporting on a Variable Field Comparison to another Variable Field (not static value) - General Development - Salesforce.com Community
Community - Reporting on a Variable Field Comparison to another Variable Field (not static value) - General Development - Salesforce.com Community
Update a variable field from a text box value  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Update a variable field from a text box value
Update a variable field from a text box value
Thread profile page for "Bind variable field to a text box" on http://www.access-programmers.co.uk. This report page is a snippet summary view from a single thread "Bind variable field to a text box", located on the Message Board at http://www.access-programmers.co.uk. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity