Search results

This should work, right? This is driving me crazy... If I close the form, and run the query, and am asked to set the value for the txtstrWhere, and give it a single digit, say "5", it works fine - so doubt its the query - or some problem with conversion of str to int. But if I give it two...

Hello, I have a multi select listbox that is used to add id's to a query. Specifically: SELECT dbo_tblTaggedItems.TaggedItemID, dbo_tblItems.ItemDescription, ' ' AS [space], dbo_tblTags.TagDescription FROM (dbo_tblTaggedItems INNER JOIN dbo_tblItems ON dbo_tblTaggedItems.ItemID =...

Wazz, you rock. Thanks!

Hello, I just can't think of a nice way to do this... I have a listbox that contains a column whose data is greater in width than what seems to be access's ability to scroll horizontally. (even after much grief trying to find out why the H-scroll bar wouldn't appear, I can't get the H-scroll...

Ok, I noticed that the sql server backend tables' text fields that were misbehaving were char(n) instead of varchar(n) - which was an error on my part when I typed up the DDL. I mod'd the tables to be varchar and the odd behavior stopped. So, while it is no longer a problem, it does remain a...

Rats. I just took the same form and tried it against an access table and not the sql server linked table, and the problem went away... Double rats. I guess it is a driver issue. I do some testing and report back when I make some headway...

Well, I'll go so far and say we had an app here that was made for Acc2000 which would blow up when opened under 2007, and it didn't after adding sp2. I haven't fully tested the app to see if it will behave, but it *seems* to have made a difference at least in so far the app doesn't auto crash...

Wow. I am stumped. I can't for the life of me see why this is happening... I am using a 2003 mdb against a SQL Server db. The table on the sql server side is char(1000), so when I link the table to the mdb it sees it as memo. Ok, no problem... (All SQL Server driver for ODBC defaults)...

you can make a query that will help... update your_table_name set column1 = 'Yes' where column1='No'; just create new query, and choose design view, then click ok, and just close the box... right click on the window and choose sql view... and just manually type in the SQL. You can do it...

ahh, nevermind. ='9' & Mid([Office Fax],3,2) & Mid([Office Fax],3,7) & Right([Office Fax],4) ...just was easier in the end. :)

Hello, I had a rather odd request that I can't quite figure out how to fulfill... A user wants on a report to not have the phone numbers masked such as: (123) 456-7890 format, but all out as a string like 1234567890... (weird, but whatever) It is being stored via the mask in the table as...

I don't think you merely want a query, but rather some VBA code that checks the condition of the checkbox and toggles the recordsource between two queries, one that select * from tablename, and the other select * from tablename where condition is met...

It is my understanding that User Level Security is only disabled on the .accdb access db's and not the .mdb access databases. Maybe just not convert the .mdb to an .accdb and you'll retain the ULS. http://office.microsoft.com/en-us/access/HA102345611033.aspx -MattG.

Thanks guys! I think I'll do some more testing with the sql92 standard turned on... Thanks for the tip! -MattG.

Ok, It seems that I am hitting a wall here writing some queries to analyze this mdb I was given to fix up... SELECT * FROM qryMGG_CustomersNotTrends WHERE customers.username not like '%@%'; ...works fine, but removing the NOT in NOT LIKE... SELECT * FROM qryMGG_CustomersNotTrends WHERE...

Rabbie, Thanks :) I should have tried that, no? It does work. Thanks. Still, just for nerd's sake - does what I wrote not work in Access? Or is it a jet db driver sql thingy? Curious...

Ok, I never used the wizard before... it seems to have made a left join and where null... The trimmed down version of the resulting query was this: SELECT * FROM Customers LEFT JOIN Trends ON Customers.CustomerID = Trends.CustomerID WHERE Trends.CustomerID Is Null; But for the record...

Ok - Please someone point out what is my silly mistake... SELECT * FROM Customers WHERE Customers.CustomerID not in ( select Trends.CustomerID from Trends ); I have a table called Trends and a table called Customers... The Trends table has a field called CustomerID, which is a fkey to the...

Ok, so yea... I am gonna go with two tables in the access front end - one that looks via a read-only view (to teachers) to sql server... and the other is set to a read/write view to a table collecting the contacts' info. Ok - maybe I just had to hear myself write it out and read it aloud -...

Hello Gang, I was hoping someone could help me think this through. :) I have an access db that is being heavily modified, and I was trying to make sure that the architecture was being done right at the start of the mods... The current situation is this: Two of the tables in the current db...