G
Guest
i need to create a new control source so that i can bind it to a new topic.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PC Datasheet
Me!NameOfControl = "NameOfControlSource"
Note - the name of the controlsource must be in quotes as shown.
Note - the name of the controlsource must be in quotes as shown.
B
BillCo
again with the spam... *sigh*
I'm in through google and can't see the original post, but eh,
shouldn't that be:
Me.ControlName.ControlSource = "[tblName].[SourceField]"
Me.ControlName.Refresh
Otherwise you are changing the value of the control, not the control
source, i.e. "Me!NameOfControl = " defaults to "Me!NameOfControl.Value
="
I'm in through google and can't see the original post, but eh,
shouldn't that be:
Me.ControlName.ControlSource = "[tblName].[SourceField]"
Me.ControlName.Refresh
Otherwise you are changing the value of the control, not the control
source, i.e. "Me!NameOfControl = " defaults to "Me!NameOfControl.Value
="
S
StopThisAdvertising
PC Datasheet said:Me!NameOfControl = "NameOfControlSource"
Note - the name of the controlsource must be in quotes as shown.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)
Wrong answer (again ...)
--
To Steve:
Over 360 users from the newsgroups have visited the website to read what kind of a 'resource' you are...
To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.
Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)
Arno R
B
BillCo
Arno, dude - his spam post was up for 5 hours before your retort today
- getting slow man!!! you're like a pitt-bull dog with a bone with that
whoissteve.html ...it cracks me up. Every single time he spams the
group ( usually giving wrong answers ) you pop up with your web link (
fair play to you for not letting this gobsh!te away with it ) ...and
yet still he returns over and over. It's a little like a comedy now.
- getting slow man!!! you're like a pitt-bull dog with a bone with that
whoissteve.html ...it cracks me up. Every single time he spams the
group ( usually giving wrong answers ) you pop up with your web link (
fair play to you for not letting this gobsh!te away with it ) ...and
yet still he returns over and over. It's a little like a comedy now.
P
PC Datasheet
Hey Simple Simon, you'r an ignorant bastard!!!!
From the help file ---
The following example sets the ControlSource property for a text box named
AddressPart to a field named City:
Forms!Customers!AddressPart.ControlSource = "City"
The next example sets the ControlSource property for a text box named
Expected to the expression =Date() + 7.
Me!Expected.ControlSource = "=Date() + 7"
From the help file ---
The following example sets the ControlSource property for a text box named
AddressPart to a field named City:
Forms!Customers!AddressPart.ControlSource = "City"
The next example sets the ControlSource property for a text box named
Expected to the expression =Date() + 7.
Me!Expected.ControlSource = "=Date() + 7"
S
StopThisAdvertising
Hey 'resource' Stevie...
Have you even looked at your answer (and Bill's answer) properly before your name-calling??
Oops ...??
Arno R
Have you even looked at your answer (and Bill's answer) properly before your name-calling??
Oops ...??
Arno R
PC Datasheet said:Hey Simple Simon, you'r an ignorant bastard!!!!
From the help file ---
The following example sets the ControlSource property for a text box named
AddressPart to a field named City:
Forms!Customers!AddressPart.ControlSource = "City"
The next example sets the ControlSource property for a text box named
Expected to the expression =Date() + 7.
Me!Expected.ControlSource = "=Date() + 7"
BillCo said:again with the spam... *sigh*
I'm in through google and can't see the original post, but eh,
shouldn't that be:
Me.ControlName.ControlSource = "[tblName].[SourceField]"
Me.ControlName.Refresh
Otherwise you are changing the value of the control, not the control
source, i.e. "Me!NameOfControl = " defaults to "Me!NameOfControl.Value
="
S
StopThisAdvertising
BillCo said:Arno, dude - his spam post was up for 5 hours before your retort today
- getting slow man!!! you're like a pitt-bull dog with a bone with that
whoissteve.html ...it cracks me up. Every single time he spams the
group ( usually giving wrong answers ) you pop up with your web link (
fair play to you for not letting this gobsh!te away with it ) ...and
yet still he returns over and over. It's a little like a comedy now.
Yep, it's kinda boring indeed.
If you get bored also then just killfile 'StopThisAdvertising'...
Web link is not meant for you (you know Steve's 'game') but for new posters here.
If you think I am 'slow' again, please feel free to use the link yourself ;-)
Arno R
P
PC Datasheet
............. ( usually giving wrong answers )
I certainly did, BUTT-FACE!!!!!
Hey 'resource' Stevie...
Have you even looked at your answer (and Bill's answer) properly before your
name-calling??
Oops ...??
Arno R
I certainly did, BUTT-FACE!!!!!
Hey 'resource' Stevie...
Have you even looked at your answer (and Bill's answer) properly before your
name-calling??
Oops ...??
Arno R
PC Datasheet said:Hey Simple Simon, you'r an ignorant bastard!!!!
From the help file ---
The following example sets the ControlSource property for a text box named
AddressPart to a field named City:
Forms!Customers!AddressPart.ControlSource = "City"
The next example sets the ControlSource property for a text box named
Expected to the expression =Date() + 7.
Me!Expected.ControlSource = "=Date() + 7"
BillCo said:again with the spam... *sigh*
I'm in through google and can't see the original post, but eh,
shouldn't that be:
Me.ControlName.ControlSource = "[tblName].[SourceField]"
Me.ControlName.Refresh
Otherwise you are changing the value of the control, not the control
source, i.e. "Me!NameOfControl = " defaults to "Me!NameOfControl.Value
="
R
Rob Oldfield
Damn. I hate it when he gets all intellectual like that. Is "BUTT-FACE"
Latin?
Latin?
PC Datasheet said:............ ( usually giving wrong answers )
I certainly did, BUTT-FACE!!!!!
Hey 'resource' Stevie...
Have you even looked at your answer (and Bill's answer) properly before your
name-calling??
Oops ...??
Arno R
PC Datasheet said:Hey Simple Simon, you'r an ignorant bastard!!!!
From the help file ---
The following example sets the ControlSource property for a text box named
AddressPart to a field named City:
Forms!Customers!AddressPart.ControlSource = "City"
The next example sets the ControlSource property for a text box named
Expected to the expression =Date() + 7.
Me!Expected.ControlSource = "=Date() + 7"
BillCo said:again with the spam... *sigh*
I'm in through google and can't see the original post, but eh,
shouldn't that be:
Me.ControlName.ControlSource = "[tblName].[SourceField]"
Me.ControlName.Refresh
Otherwise you are changing the value of the control, not the control
source, i.e. "Me!NameOfControl = " defaults to "Me!NameOfControl.Value
="
L
Larry Linson
Damn. I hate it when he gets all intellectual
like that. Is "BUTT-FACE" Latin?
Be kind to poor little Stevie... he's gettin' all frustrated.
P
PC Datasheet
Look again. It's your own language - pig latin.
Rob Oldfield said:Damn. I hate it when he gets all intellectual like that. Is "BUTT-FACE"
Latin?
PC Datasheet said:............ ( usually giving wrong answers )
I certainly did, BUTT-FACE!!!!!
Hey 'resource' Stevie...
Have you even looked at your answer (and Bill's answer) properly before your
name-calling??
Oops ...??
Arno R
PC Datasheet said:Hey Simple Simon, you'r an ignorant bastard!!!!
From the help file ---
The following example sets the ControlSource property for a text box named
AddressPart to a field named City:
Forms!Customers!AddressPart.ControlSource = "City"
The next example sets the ControlSource property for a text box named
Expected to the expression =Date() + 7.
Me!Expected.ControlSource = "=Date() + 7"
again with the spam... *sigh*
I'm in through google and can't see the original post, but eh,
shouldn't that be:
Me.ControlName.ControlSource = "[tblName].[SourceField]"
Me.ControlName.Refresh
Otherwise you are changing the value of the control, not the control
source, i.e. "Me!NameOfControl = " defaults to "Me!NameOfControl.Value
="
R
RoyVidar
PC Datasheet wrote in message
So - BillCo is an ignorant bastard for pointing out that your initial
suggestion does not work?
If you haven't yet figured it out by reading BillCo's reply, then allow
me to point out that what is explained in the help files, is assigning
to a controls .controlsource property, while you in your initial
suggestion claim that assigning to the default (.value) property does
just the same
sorry, no it doesn't. It won't work even if you're namecalling till
you're blue in the face, neither would it suddenly start working as a
side effect of you violating NG/Usenet charter/etiquette through
soliciting ...
Me!NameOfControl.Controlsource = "NameOfControlSource"
Hey Simple Simon, you'r an ignorant bastard!!!!
From the help file ---
The following example sets the ControlSource property for a text box named
AddressPart to a field named City:
Forms!Customers!AddressPart.ControlSource = "City"
The next example sets the ControlSource property for a text box named
Expected to the expression =Date() + 7.
Me!Expected.ControlSource = "=Date() + 7"
So - BillCo is an ignorant bastard for pointing out that your initial
suggestion does not work?
If you haven't yet figured it out by reading BillCo's reply, then allow
me to point out that what is explained in the help files, is assigning
to a controls .controlsource property, while you in your initial
suggestion claim that assigning to the default (.value) property does
just the same
Me!NameOfControl = "NameOfControlSource"
Note - the name of the controlsource must be in quotes as shown.
sorry, no it doesn't. It won't work even if you're namecalling till
you're blue in the face, neither would it suddenly start working as a
side effect of you violating NG/Usenet charter/etiquette through
soliciting ...
Me!NameOfControl.Controlsource = "NameOfControlSource"
L
Larry Linson
Look again. It's your own language - pig latin.
Otnay veneay oseclay otay igpay atinlay, evestay.
P
PC Datasheet
It is for the poster. It gets garbled after sticking his head up places
where the sun doesn't shine!!
where the sun doesn't shine!!
B
BillCo
If you think I am 'slow' again, please feel free to use the link yourself ;-)
might just do that thanks... I'm baffled by this guy. is he for real?
is he actually some kind of flame bot program that will form the basis
of some student's dissertation? Is he a giant troll hoax? he's not
really annoying me though - i'm still in "Quietly Amused" mode.
....so long as people continue to post answers correcting his bad advice
and continue give free advice / solutions to the original poster
wherever he pops up saying e-mail me then he won't be in a position to
rip anyone else off through this forum (newbees or contractors!). So
for now I'll just chuckle to myself and wonder how he pays the rent.
might just do that thanks... I'm baffled by this guy. is he for real?
is he actually some kind of flame bot program that will form the basis
of some student's dissertation? Is he a giant troll hoax? he's not
really annoying me though - i'm still in "Quietly Amused" mode.
....so long as people continue to post answers correcting his bad advice
and continue give free advice / solutions to the original poster
wherever he pops up saying e-mail me then he won't be in a position to
rip anyone else off through this forum (newbees or contractors!). So
for now I'll just chuckle to myself and wonder how he pays the rent.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.