Search results

Hello! I have a form in datasheet view, and I am wondering if it's possible to specify "pages" with a set amount of records per page. Think like the search results of Google, you get a huge number of results, but only so many are displayed per page. Thanks!

I have read the Truncation of Memo fields link that you have provided, aaaand I do not believe that any of the conditions listed there are present in this database I am working with. No GROUP BY clauses in the view. There's no q-- son of an S I just fixed it! Hm, it turns out all I needed to...

I do not detect a GROUP BY clause, nor do I detect a UNION clause, in the view. I do not believe that the issue is on the server-side, since Access displays the data correctly when viewing the raw table (through Access), and MSSQL Server displays the data correctly both when viewing the table...

Oh, right, the specific issue is the length of the string being displayed... In the view, the specific way in which the data is not being displayed correctly is that only a certain number of characters are being displayed, causing the rest of the data to be cut off. Since Access "thinks" that...

Running a database with an Access front end and a MSSQL Server backend... The datatype for the offending field in MSSQL Server is "nvarchar(MAX)". The datatype as displayed in Access for the same field when looking at the table is "Memo". A VIEW object in MSSQL Server, using the offending...

Well jwaguile, while it is true that you cannot sort a report in both ascending and descending order on a single field, what you can do is make two derived fields, using the DateValue and TimeValue functions with your datetime field as an argument, and sort on those two, new, separate, derived...

I have "tests" that are performed, each with a date and time (as part of a single datetime field). My report lists these tests, but they need to be sorted such that the most recent test appears at the top of the report (ascending order), but if there are multiple tests on a single day, the...

AutoCorrupt? That's hilarious! :D Allright, you win, we don't quite have over 100 tables yet, but we're getting there...

Sorry about the lack of details, here we go... This is in Access 2003. The file is 8.3megs in size after a compact and repair. It is one Access database file that pulls data from an MSSQL Server. The computer has two gigs of ram, and is running XP Professional, SP2. This has happened on more...

It was about six months ago I first encountered the "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again." error. This was also when I learned that encountering this error is a very bad thing, as it resulted in the corruption of my form, and...

!!! !!! !!! That seems to have fixed it o__o and i was looking for some kind of "unique values only" property in my combobox properties. ._. ...then i read the last part of wiklendt's signature, like holy crap, i really can give a hug. xD ... and as far as this is concerned... i...

cascading combo boxes... I was trying for the life of me to not have to rely on visual basic code for this, I wanted to be able to do it just with the stupid access query... hm

... ... ... I just spent about 30 minutes writing a post here, taking minutes just trying to come up with the words to accurately describe my problem, just to have the page "you do not have permissions to do this" appear when I try to preview my post, and because this wonderful company thinks...