Recent content by storm75m

I have already pulled out half of it, but the rest of my hair will be gone if I don't figure out this problem soon... Background: SQL 2000 Database linked to Access 2000 front end, via ODBC linked tables. I have a form with a multi-tab control on it, and on one of these tabs is a text box...

Got it, thanks again. This one worked by the way, my data changed on me and that's why I wasn't getting any results. SELECT tblLoc.ADD1 FROM tblLoc, 221Streets WHERE tblLoc.ADD1 Like '*' & STRName & '*'

OK, I lied, now I'm not getting any results...

Syntax error in From clause..." Wait, nevermind, I think that worked, thank you very much.

Get an error saying "Join Expression not supported.

I have a table with a bunch of addresses. Table Name: tblLOC Field Name: ADD1 (Ex: 1234 Maple Way) I also have a table with a bunch of street names. Table Name: 221Streets Field Name: STRName (Ex: Maple Way) I want to be able to select all addresses from the first table where the street...

I have a form in Access 2000 linked to a SQL2000 back end via ODBC. On this form I have a text box that is bound to a field, with a max of 250 characters, however when I type into the control, it stops at 150 characters. The field actually origially had a lenght of 150, but I moved it up to...

Pretty straight forward question... I have a list box on my form and I would like to create a button that selects all of the values in the list box. Is there a simple way to do this? TIA...

Thanks, I'll give this a shot. What if my Primary key is defined on two fields?

I have a table named AcctTypes with these fields defined: AcctID Name Location Phone ModUsr ModDate Any time that the data is changed in any field in this table, I would like to update the ModUsr to be the current username, and ModDate to be today's date/time. I've never created a trigger...

Let me just start off by saying I'm fairly new to SQL Server. I have a SQL2000 database that I'm developing (with an Access 2000 front end), and I'm continuously getting errors saying that "the data has been updated by another user" when working in Access and editing the data. This is still in...

Worked great, thanks. Never had to do multiple joins to the same table before.

I don't know why this is giving me so much trouble, seems pretty straight forward. I have two tables: tblEmployees EmpID EmpName tblArea AreaID AreaName PrimaryContactID (fk to Employees table) SecondaryContactID (fk to Employees table) I just need a simple query to show the data like this...

I have an Access 2000 database that I am developing, with a SQL server 2000 back end. Randomly, whenever I'm entering data into the table or moving from one record to the next, I recieve an error saying, "The Data has been changed. Another user edited this record and saved the changes before...

I have a list box control on a form and I am trying to set the recordsource property to a stored procedure. I am trying to avoid doing this at runtime. The stored procedure takes a single parameter @District, which is a value on the main form. How do I pass the value in my form...