ARRAY(0x5d5dcb8)
I have a problem in a setfocus comm...
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What is interesting here?
• Duels		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Register!
QAIX > MS Access database development > I have a problem in a setfocus comm... 10 November 2008 15:26:29
  Top users: 
1. Minako l Love friends l

"~Snowly the world ~"
Age: 14 years
2.Kipi Cosplay
"{•Sexy•}"

How to become a leader?
  Recent blog posts: 
How to convert videos…
Nowadays, Apple Mac is more and more popular among our life. But there are few high quality compitible…

AMV Converter for Mac - How to…
AMV converter for Mac is a Mac OS X application that supports both Intel Processor and PowerPc. If you…

How to break the itunes…
How to break the iPhone ringtone 30s length limit? The following is the step by step guide on how to…

How to bypass DRM protection…
You may find most of videos and music downloaded from online shops like iTunes, Wal-Mart Music…

How to convert Limewire videos…
Video converter for Mac, for successful converting Limewire videos to Apple iPad Video converter for…

....
http://akjhfbxfnnf.­­beon.ru/14089-689-m­i­ni-vecherinochka.z­ht­ml#e221501233&hel­lip;

Greeting
Greeting I span-new here. All may. Come http://gyxe.com/ I…

/-/
Duels xaxa shok :-O­

’ My preface


’ Lonely (=
I feel like on a deserted island *click*

  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
Connect property of linked ODBC…
Hi I am trying to refresh table links at startup in an Access 2002 application. The following code is…

Access 97 - Multiuser databases…
I've just spent some time looking through FAQ sites and searching the google archives of this newsgroup…

How to calculate the sum of a…
Dear reader, I am an occasional user of MS Access 2000 running on Windows 98. My hobby is ship model…

I have a problem in a setfocus…
I have a problem in a setfocus command. Can any1 help? Any advice is much appreciated Private Sub…

Access beginner User..Need help…
I need help setting up a database which includes a list of about 1200 urls. Anyone who accesses the…
  Recent forum topics: 
.....
http://mindmix.ru/ http://ltalk.ru/

...
http://mindmix.ru/

Russia rylezzzz
Russia rylezzzz

Hello everyone, I have guests…
Hello everyone, I have guests! And you amerekantsi?

Russia rylezzzz
Russia rylezzzz

Good afternoon ^^
Good afternoon ^^
  Recent forum comments:
RE: Change decimal to fraction
hi can somone help me with this problem it's decimals and fraction two boards were placed end to…

RE: system recovery
do not hesitate trying various tools for import .sql files into sql query file…

RE: Help, pls, re- data recovery
do not hesitate trying various tools for how to repair sql server database…

RE: Recovery model problem; db…
do not hesitate trying various tools for recovery sql server mdf…

RE: Incomplete Recovery of…
do not hesitate trying various tools for mssql database repair…

RE: Fast Recovery (CKPT REQ)?
do not hesitate trying various sql server repair tools…

RE: china sell wholesale just…
Do you want to show and blossom your beauty? louis vuitton production is your first choice,life like…

RE: DataSource connection problem
Hi, I am facing same problem. Anyone please let me know on this. Regards, Sathish

RE: highlight text in an RTF…
The code is awesome, and works well for text, however: it doesn't seem to work, for numbers, even if…

RE: Controlling Windows Media…
but this is just opening a file, some way with library control mp
  Модератор:
 Administrator

I have a problem in a setfocus comm...

Guest 13 October 2008 10:41:21
 I have a problem in a setfocus command. Can any1 help? Any advice is much appreciated

Private Sub btnFind_Click()
Dim strSQL, strSelect, strFrom, strTitle, strDescription, strSubmitter, strOwner As String

Set db = CurrentDb

strSelect = ("SELECT tblCore.[c_ID], tblCore.c_Title, tblCore.c_Descripti­on, tblCore.c_Submitter­, tblCore.c_CloseDate­, tblCore.c_LastUpdat­e, tblCore.c_Owner ")
strFrom = ("FROM tblCore ")

strTitle = ("WHERE (((tblCore.c_Title)­Like " & Chr(34) & "*" & Chr(34) & "&" & Chr(34) & [Forms]![frmCoreMain]![txtSearch] & Chr(34) & "&" & Chr(34) & "*" & Chr(34) & "));")

********** Continued

Select Case Me.optSearchCriteri­a.Value
Case 1
strSQL = strSelect & strFrom & strTitle
Case 2
strSQL = strSelect & strFrom & strDescription
Case 3
strSQL = strSelect & strFrom & strSubmitter
Case 4
strSQL = strSelect & strFrom & strOwner
End Select

Me!txtSearchDump.Se­tFocus 'Problem occurs here Run Time Error: cannot move focus to the control txtSearchDump'
Me!txtSearchDump.Te­xt = strSQL
CurrentDb.QueryDefs­("qryCoreSearch").SQ­L = strSQL
Me.lstCoreSearch.Re­query
End Sub
Add comment
Guest 10 November 2008 15:26:29 [ permanent link ]
 somehow there is a problem setting the focus on txtSearchDump
easy way not to set focus and
dont use .text at txtSearchDump

like this :


Me!txtSearchDump = strSQL
CurrentDb.QueryDefs­("qryCoreSearch").SQ­L = strSQL
Me.lstCoreSearch.Re­query
End Sub
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или законы РФ. Ваш ip-адрес записывается.

QAIX > MS Access database development > I have a problem in a setfocus comm... 10 November 2008 15:26:29
see also:
[JBoss Portal] - Re: Portlet navigation…
[Installation, Configuration &…
[JBoss Seam] - Re: having problem with…
pass tests:
You and sex.
see also:
Eye-catching:Sony XPERIA X1 with its…
How to Get Videos from Youtube and Use…
How to Get Movie and Music…
  Copyright © 2001—2010 QAIX
Идея: Монашёв Михаил.
Авторами текстов, изображений и видео, размещённых на этой странице, являются пользователи сайта.
See Help and FAQ in the community support.qaix.com.
Write in the community about the bugs you have noticedbugs.qaix.com.
Write your offers and comments in the communities suggest.qaix.com.
Information for parents.
Пишите нам на .
If you would like to report an abuse of our service, such as a spam message, please .
Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .