SEARCH YOUR SOLUTION HERE  

why does this not work?

Why does this not produce any records (should be 2) Code SQL = "SELECT * " & vbCr & "FROM [TblVendors]" & vbCr SearchStr = "WHERE (((TblVendors.Name) Like '" & Chr(42) & FrmSearch.SearchText & Chr(42) & "')); Debug.Print SQL & ...

Posted On: Sunday 11th of November 2012 09:00:16 PM Total Views:  176
View Complete with Replies




Related Messages:

Filesystemobject doesnt return the folder.size in case of very large folders   (308 Views)
I am trying to get the size of a folder using the filesystem object. This code seems to work fine, except for very large folders (i.e. c:\ or c:\Documents and Settings) The code I am using: Dim fso Dim fldr ...
Moving text / graphics in a canvas so it doesn't lock up the program in the process   (470 Views)
I guess you could say I'd like to draw some scrolling credits with some text and graphics. But I want this to keep running while the program is doing other things. e.g. accepting input in EditFields and PushButton clicks... ...
HELP - Form doesnt show when in debug mode (VB .net)   (467 Views)
, bit of strange one this, I have a VB .net application that has Sub Main() as its startup procedure, this then creates and shows a form. Up till now when I pressed F5 the form would duly appear. Whats ...
Right$ doesn't work   (198 Views)
A project in VB6 recently worked without any problems but now it's complaining when I try to use 'Right$'. In immediate mode, when I'm typing 'print left$("123456",2)' I get the correct result '12'. When I type 'print right$("123456",2) I ...
VB6 code doesnt compile properly?   (385 Views)
, I'm editing a server and adding commands into it. (It's a chat game). But none of the commands work in game. It compiles fine. I didn't make the server myself and i followed the guide that worked for others... nothing compiles right. Help
VB Object doesn't support property or method when it should. - Data control problem.   (411 Views)
Hi I'm developing aa number of applications to trawl through the files on a computer and perhaps process them in various ways, but I have hit a problem To step through the hard disks I set up drive, directory and ...
Scrollbar does not update while tabbing through controls   (272 Views)
i have an SSTAB control on a form. on each tab, i have a Frame which acts as a container for a picturebox. the picturebox in turn acts as a container for a no of textboxes, combos, optionbuttons & checkboxes, placed one below the other. i have placed a single Vscrollbar towards the right edge of the form. when i tab / shift-tab through the controls on the picturebox, using tab key or Enter key, the vscrollbar does not update itself. therefore i am unable to see the next control down below. i have googled for answers but not found any. how do i automatically update the vscrollbar when i tab through the controls on the picturebox lying on a particular tab Can anyone help me with this P.S: i have attached a sample file containing the code. Attached File(s) test.zip (2.06K) Number of downloads: 32
need help: ADOX - DefinedSize does not what I want.   (412 Views)
World, I'm creating a new ACCESS2000 DB via ADOX under a VB6 project. Everything works fine but the column size in the database tables is always the same for all columns, no matter how I set the "DefinedSize" property ...
WriteFile (or CreateFile) Why doesn't this work   (354 Views)
Copied directly from exaple book but not working.... i get is an empty 0 byte file Call to GetLastError directly after the call to WriteFile returns 0 (NO_ERROR) but no data sees to be written :-( Thx The ...
SetCursorPos does not set Y position correctly   (254 Views)
I used SetCursorPos but it does not set Y position correctly, although the X position is set correctly. I can see the mouse being positioned in the upper left corner of the screen and the X position is changing ...
What does "Me." mean?   (127 Views)
I am not a VB coder but need to modify VB code. What does "Me" mean I have a line of code that says: Me.MAPISession1.UserName I am trying to understadn what this means. I am running a script and ...
Playing Windows Media Files in RB 5.5.4 does not work! Any ideas?   (137 Views)
, I am building an app that should be able to play both: Quicktime and WMV Files. I get the Quicktime thing working fine. But Windows Media does not want to work. Here is what I did: In the ...
Common Dialog Control doesnt allow orientation from Landscape to Portrait programmatically   (236 Views)
, I am having a big problem with the Common Dialog control being used in a Windows app developed using VB6 SP6 running on XP and 98. When trying to print using the common dialog and set the common ...
Help! It does not scan all the records of my database!   (168 Views)
I am trying to write a code for the login. I have took into account of the all the possibilities and therefore came with the following code: Private Sub cmdLogin_Click() Dim db As Database Dim rs As Recordset Set db ...
compare emails through Subject doesn't work   (337 Views)
Hi , We have two accounts on which emails arrive. A lot of the time the same emails arrive at both accounts so we created this code to check the inbox of account2 with the deleted items of account1. We ...
Why does FtpGetFile sometime put a file in "Temporary Internet Files\Content.IE"?   (121 Views)
For some years, we have been running at many sites a service written in VB .NET that calls a DLL written in Microsoft Visual Basic 6. This DLL uses wininet.dll's FtpGetFile to copy files from an FTP directory to a ...
MP3 in VB does not loop seamlessly   (153 Views)
I have tried using both the Windows Media Player control as well as the mciSendString method for playing an MP3 within my Visual Basic 2003 app. The problem is that when the MP3 is looping there is always a small ...
Things I need help with...Database Looping doesn't seems to work   (404 Views)
\Private Sub tmupds_Timer() Dim j As Long Dim leng As String Dim lret As Long Dim phoneline As Long Dat.MoveFirst While Not Dat.EOF ino = Dat.Fields(0) iname = Dat.Fields(1) If Dat.Fields(2) = 0 Then txtS.Text = txtS.Text + vbCrLf + ...
True DBGrid RowColChange doesn't fire on first mouse click   (296 Views)
I spent a good portion of my workday today on a bug-hunt. I'm working on records management app which relies on the True DBGrid control in a number of places to display information pulled from the database. The main app ...
RB does always print a blank page   (243 Views)
How comes that I have always an extra blank page printed Mine code looks like this: == dim ps as printerSetup dim page as graphics page = openPrinterDialog (ps) dim i as integer if page <> nil then for i ...