Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by goffc
-
Need help with recordset.
I'm gonna check on that. The weird thing is that it works when I send the variable through as say "12345", a number, and have the column in the database set to number. But when I change the column to text and try to sent the variable through as MBR-12345, it chokes.- goffc
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
Need help with recordset.
Actually, It says "Syntax error" and points to that line.- goffc
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Need help with recordset.
Hey, Here's the code: (It's saying script error and pointing to this line --> RS.Open "SELECT * FROM Members WHERE memberID='" & member_ID & "'" The page before this one is sending the variable MBR-000005, to this page as mid. <a...- goffc
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Need help with recordset.
Hey, I appreciate the reply. I tried to use what you told me and I get a script error.- goffc
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Need help with recordset.
I'm new to SQL. I have a page that is requesing an memberID from another page. It takes it inserts it into a table and displays the members info. it used to be a number, but i am switching it to text and it's not working. The database record has been set to text. I would really appreciate any...- goffc
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
