Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #10859
| From | Ron Weiner <rw@domain.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: DMax with Text Field |
| Date | 2015-06-23 12:49 -0400 |
| Organization | WorksRite |
| Message-ID | <mmc2js$ntu$1@dont-email.me> (permalink) |
| References | (1 earlier) <mm9h8b$4va$1@dont-email.me> <3mrgoaljrnog66h7b9lhggv5ng1nn5b72t@4ax.com> <mmagr6$rpo$1@dont-email.me> <br0joatc8hi8qedge8q1gbj5n3965buuln@4ax.com> <vf1joatjr2hrm16u23u49u92as9b7dafgq@4ax.com> |
croy used his keyboard to write :
> On Tue, 23 Jun 2015 09:06:49 -0700, croy <croy@invalid.net>
> wrote:
>
>> On Mon, 22 Jun 2015 22:39:46 -0400, Ron Weiner
>> <rw@domain.com> wrote:
>>
>>>> Thanks for that--I think! <g>
>>>>
>>>> I wish I could understand it. What does "Replace" do in
>>>> that?
>>>>
>>> In this case the replace function will replace all/any single quote
>>> characters(') with a Pair of Single quote characters('') in the
>>> referenced textbox on your form.
>>>
>>>>> You need to wrap text values in in the Where part in quotes. I like to
>>>>> use single quotes. However, if there is a chance that the Value you
>>>>> are passing has a single quote embedded in it, you need to Escape the
>>>>> single quote by doubling it up.
>>>>
>>>> Is your example "doubled up"? I'm very confused!
>>> Thats the purpose of the Replace function.
>>
>> Thanks, but I can't get any of these suggestions to work.
>>
>> I even built a summary query to shortcut the process, and
>> then used:
>>
>> If DLookup("Depleted","qryDepleted")=0 then
>>
>> ... and that didn't work!
>
> It compiles ok, but when I open the form I get the error
> like "You cancelled the previous operation". I've checked
> spelling, table names, etc. till I'm losing sanity.
Try a Compact/Repair. If that dosent work send us the sql in
qryDepleted.
Also "Didn't work" is a rather vague term. Actual error message and
actual the line of code highlighted where it stopped will make it
easier to help you.
Rdub
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
DMax with Text Field croy <croy@invalid.net> - 2015-06-22 08:12 -0700
Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-06-22 13:40 -0400
Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-22 13:31 -0700
Re: DMax with Text Field "Phil" <phil@stantonfamily.co.uk> - 2015-06-22 22:43 +0100
Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-06-22 22:39 -0400
Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-23 09:06 -0700
Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-23 09:19 -0700
Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-06-23 12:49 -0400
Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-23 12:27 -0700
Re: DMax with Text Field croy <croy@invalid.net> - 2015-06-23 12:29 -0700
Re: DMax with Text Field Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-06-23 12:45 -0700
Re: DMax with Text Field croy <croy@invalid.net> - 2015-07-07 07:19 -0700
Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-06-23 20:46 -0400
Re: DMax with Text Field croy <croy@invalid.net> - 2015-07-07 07:17 -0700
Re: DMax with Text Field Ron Weiner <rw@domain.com> - 2015-07-07 16:40 -0400
csiph-web