473,386 Members | 1,830 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions > error in rowsource statement

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Error in RowSource statement

134 100+
Could someone assist to correct the statement, as I want to search base on 2 conditions -
that is txtpartno and txtcustid, there something wrong in my statement here,
no result displayed.


Me!List0.RowSource = "select custpart, vndpartno, vendor, qty_requested, unit, date_quoted, quoted_price " & _
"FROM tblcustquote Where custpart Like '*" & Me.txtpartno & "*'" & "and [tblcustcode.custid] = " & Me.txtcustid & "ORDER BY custpart:"
Nov 30 '07 #1
2 1275
jamesnkk
134 100+
Sorry, Please ignore this message , I have manage to solve it , but couldn;t delete off this message.
Nov 30 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
For anyone coming to this thread later the error was in the lack of a space before the ... and [tblcustcode.custid] ... and the ... ORDER BY ...


Always watch your spacing when creating dynamic queries in code.
Dec 11 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
stored procedure with paramater as rowsource
by: Glenn Davy | last post by:
hi Is it possible to have a storedprocedure with a parameter as a rowsource to a combo/list box: e.g. me.cbMyCombo.rowsource='exec spMyLookup @Key=12345' or ...
Microsoft Access / VBA
0
Lengthy error message when attempting to select from a combobox list
by: Susan Bricker | last post by:
The following error: "The current field must match the join key '?' in the table that seves as t the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the...
Microsoft Access / VBA
2
Repost (corrected explanation): Lengthy Error from Combobox
by: Susan Bricker | last post by:
I went back to read my post and found an error in my description ... here is the post, again, corrected: The following error: "The current field must match the join key '?' in the table that...
Microsoft Access / VBA
10
A97 error #2109 ?
by: MLH | last post by:
Anybody know why I might be getting error #2109 during the procedure below? It does not occur on 2 desktops, but did on a laptop. The error said: "The following unexpected error occurred in Sub...
Microsoft Access / VBA
0
Linked table error or not?
by: EJO | last post by:
Thanks everyone! My workgroup is in a mixed enviroment for using an Access 2k mde as the front end of a sql server 2000 which is running on the same machine that some of my users access using...
Microsoft Access / VBA
15
Code for combo boxes returns error message!!!
by: deanndra | last post by:
I thought I had it figured out yesterday. WRONG! I have 2 combo boxes, CBUnit and CBSub. When value is clicked within CBUnit, it should bring up corresponding sub-values in CBSub. These combo boxes...
Microsoft Access / VBA
17
Multi-Select List Box 3075 Syntax Error
by: trose178 | last post by:
Good day all, I am working on a multi-select list box for a standard question checklist database and I am running into a syntax error in the code that I cannot seem to correct. I will also note...
Microsoft Access / VBA
18
Run-time error 2115?
by: OldBirdman | last post by:
I have a listbox named lbxSelect which has RowSource = strSQL set in VBA code. This displays correctly on my form (fAAA). Once displayed, I want to use it to select a record, and display the...
Microsoft Access / VBA
1
MS Access Database Runtime Error 2137
by: resqtech | last post by:
I am having an issue with an Access Database that worked at one time and after a Windows Update that screwed up the profile it stopped working. The following is what VB is stating causes the error. ...
Visual Basic 4 / 5 / 6
0
Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
General
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Basic Javascript concepts
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
Javascript
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!